How to Format and Import Data from a Single String into Excel Correctly

[samliew]

Welcome to the Make community!

You can use the built-in function split

e.g.:

{{ split("aaaaa;bbbbb;ccccc"; ";") }}

For more information, see https://www.make.com/en/help/functions/string-functions#split--text--separator-

You can do this in a Set Variable module, then use the built-in function get

e.g.: This will return the third item

{{ get(array; 3) }}

For more information, see https://www.make.com/en/help/functions/general-functions#get--object-or-array--path-

Links

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 —

General

• Help Center | Tutorials
• Make Academy – learn Make and get your certificate ← CHECK THIS OUT
• Make Blog – get the latest updates
• Features & Pricing

Help Center Basics

• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array ← CHECK THIS OUT
• Aggregate an array for mapping complex fields
• 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 use Regex in Make