01-30-2024 03:41 AM
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;6658;TypeS;2022;
Audi;5558;TypeA8;2022;Diesel
I've tried myString.split('\r\n') it creates two strings which i can not export/save as file because its list, or these strings were comma separated and stored as one line in export file
Thank you for your help
Solved! Go to Solution.
01-30-2024 04:45 AM
01-30-2024 04:01 AM
Hello @SL12345,
Please refer to the attached sample pipeline, and let me know if this helps you!
Regards,
Aleksandar.
01-30-2024 04:36 AM
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
01-30-2024 04:45 AM
01-30-2024 05:01 AM
This works for my example really well 🙂
Sorry but last