Remove rows from CSV

[vernonvd]

Hi
I am looking for a way to remove the fist 3 rows from an incoming csv file in Switch, any ideas will be apricated

[magnussandstrom]

I would try to use Easy Data Transform with Run Command app to do this.

https://forum.easydatatransform.com/t/f ... bers/204/2

[vernonvd]

Hi magnussandstrom,

Great! I did read about Easy Data Transform a while back, will look into this.

Thanks.

[magnussandstrom]

Please post here if you get stuck on the Run Command "Command" for Easy Data Transform, It was a bit tricky to get it to work initially.

[magnussandstrom]

I made a Switch flow and an 'Easy data transform preset' that removes the first 5 rows. You can edit it and change file format to fit your specific case.

Download (avaliable for 2 weeks): https://bit.ly/3Lp8eQ8

Example of Run Command command: "C:\Program Files\EasyDataTransform_1_44_0\EasyDataTransform_1_44_0.exe" "\\URL-to-preset\preset.transform" -file "Input=%%InputFilePath%%" -file "output=%%OutputPath%%\[Job.NameProper].xlsx" -cli

flow.png (22.13 KiB) Viewed 5643 times