Forum Discussion

SL12345's avatar
SL12345
New Contributor III
2 years ago
Solved

Split string into rows and save it to file row by row, not in one string

Lets say i have this input string in my mapper: "Mercedes;6658;TypeS;2022;\r\nAudi;5558;TypeA8;2022;Diesel" How can i save it to csv file as single rows? in this example it should be: Mercedes;665...
SL12345's avatar
SL12345
New Contributor III
2 years ago

Looks good but question .... in my example  - one row has more fields than another row

Is it possible to "connect"/export two  lines into one file but without empty field at the and of shorter row? 

(Mercedes is shorter and CSV formatter creates last empty field) instead of this:
"Mercedes";"6658";"TypeS";"2022";""
"Audi";"5558";"TypeA8";"2022";"Diesel"

get This

"Mercedes";"6658";"TypeS";"2022";
"Audi";"5558";"TypeA8";"2022";"Diesel"

Thank you

 

    • SL12345's avatar
      SL12345
      New Contributor III
      2 years ago

      This works for my example really well 🙂 

       

      Sorry but last

    • SL12345's avatar
      SL12345
      New Contributor III
      2 years ago

      Hi Alexandar, curious,  if scenatio below is possible to do in snaplogic: 

      Scenario  first row has fixed length 10 fields

      "Audi";"5558";"TypeA8";"2022";"Diesel";"";test1;"";"";"Germany";

      Second row has  5

      "Mercedes";"";"TypeS";"2022";"India";

      there can be empty space in both in first row and in second row as well. Is it possible instead of this: 

      "Audi";"5558";"TypeA8";"2022";"Diesel";"";test1;"";"";"Germany";
      "Mercedes";"";"TypeS";"2022";"India";"";"";"";"";"";

       

      get this? (get rid of empty fields(from field 6  to field 10)

      "Audi";"5558";"TypeA8";"2022";"Diesel";"";test1;"";"";"Germany";
      "Mercedes";"";"TypeS";"2022";"India";

       

      thank you