Long String ( complete .txt separate with tab ) into single arrays

Hi make heroes :slight_smile:

I had a problem, i tried to convert a .txt file that was separate with tab ( and headers ) into separate strings. ( I hope I use the right words to describe ).

It was a amazon report - i fix all problems with the decoding and the german “umlaute” problem:

But i got know that:

The file has a header:

  • Artikelbezeichnung
  • Artikelbeschreibung
  • Angebotsnummer
  • Händler-SKU
  • Preis
    -…

I want so separate the individual columns out of that big string. Anyone a idea or a hint what kind of solution I can use?

Have a nice day and thank you for reading and help! :slight_smile:

Hi @movo

Try splitting by new line and then by tab using functions. You can use the split function with {{newline}} in an Iterator.

This will loop across each row. Then on further splitting, you can get each column value.

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support | Book Live Implementation
Visit us here
Youtube Channel

2 Likes

Hi @Msquare_Automation, first thanks for your time to read my problem! And your help. :slight_smile:

I search for splitting but I don’t find the correct Modul. Can you gave me please a hint? Sorry I am a real beginner.

Thanks for your help and have a nice day!

1 Like

Hi @movo , hope you are doing well.

As @Msquare_Automation said use split( ) function (text separator) with ‘tab’ and ‘newline’ keyword in an ‘Iterator’ Module.

Please check this link for split( ) function - LINK

And please use Make Academy as resource to learn more about it. LINK

2 Likes

Welcome to the Make community!

If you need further assistance, please provide the following:

Please provide the output bundles of the module shown in your screenshot by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.

A.

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

Uploading them here will look like this:

module-1-output-bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles in this manner:

  • Either add three backticks ``` before and after the code, like this:

    ```
    input/output bundle content goes here
    ```

  • Or use the format code button in the editor:

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

samliew – request private consultation

Join the Make Fans Discord server to chat with other makers!

1 Like