How to organize/split this text into bundles

[Internet]

Hi! How’s everyone doing? New in Make and in almost every tool that it have. I’m here to ask for your wisdom.
I want to split this (long) text response separating it into 4 variables all along the text response.
As you can see in the screenshot the response has 4 lines and a blank space. The idea is to assign each line to a variable/mappable output to input it later in a google sheet as but the thing is I need to repeat it after each blank space. Sorry for my english and technical language, the idea would be to group in rows on a Google Sheets:

A1: Ropa y Bebés
B1: “Anavana”
C1: 20% OFF
D1: Martes a Jueves

The thing is I need this to continue grouping it because the next paragraph would be inputed the same as:

A2: Combustible
B2: “Axion Energy”
C2: 10% OFF
D2: Martes

Does anyone have or known a solution/workaround/similar tutorial to learn how to do this? <3 Thanks for your help!!

[samliew]

Welcome to the Make community!

You can use a Text Parser “Match Pattern” module with this Pattern (regular expression):

(.+)\n(.+)\n(.+)\n(.+)

Proof https://regex101.com/r/tOedWc/1

Important Info

• Global match must be set to YES!

Screenshot

Output

---

For more information, see Text Parser in the Make Help Center:

Match Pattern
The Match pattern module enables you to find and extract string elements matching a search pattern from a given text. The search pattern is a regular expression (aka regex or regexp), which is a sequence of characters in which each character is either a metacharacter, having a special meaning, or a regular character that has a literal meaning.

• The complete list of metacharacters can be found on the MDN web docs website.
• For a tutorial on how to create regular expressions, we recommend the RegexOne website.
• For an easy, quick regex generator, try the Regular Expressions generator.
• For experimenting with regular expressions, we recommend the regular expressions 101 website. Just make sure to tick the ECMAScript (JavaScript) FLAVOR in the left panel.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

[Internet]

Sam, you’re the best. You comment on every single post and you’re always right!
When I see strangers helping other strangers on internet it’s always heart warming.

Have a nice end of the year! Thanks!

[samliew]

No problem, glad I could help!

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

• Help Centre | Tutorials – Make “Manual”
• Make Academy – Basics 101: Learn Make and get certified

Help Centre Basics

• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Aggregate an array for mapping complex fields
• Date Format: tokens for parseDate | tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

Articles & Videos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Getting started with OpenAI - How to setup and use OpenAI (ChatGPT) in Make
• How to use Regex in Make - How to use pattern matching to extract the text you want
• Webhooks – Make Academy – tutorial on how to use Webhooks

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.