Forum Discussion

aditya_gupta41's avatar
aditya_gupta41
Contributor
5 years ago

Formatting excel data

I have an Excel sheet with with below format: In this Excel, column 1,2 and 3 remains common, and the data which i am suppose to send is in below output csv format: Output: QWE;1234;567890...
j_angelevski's avatar
j_angelevski
Contributor III
5 years ago

Hi @aditya.gupta41 ,

I created a solution for this. You can download and import the pipeline. This pipeline will work for more fields, it is not limited to only those shown on the image here.
Sample result:

Formatting_Excel_Data_SL_Community_2021_08_19.slp (9.0 KB)

Edit:
I forgot to change the csv delimiter, to do this, open the CSV Formatter snap and change the Delimiter setting to ;

You can also remove the quote characters if you want to. To do this just leave the Quote character setting empty.

And it will create a result like this