Remove rows from CSV

Post Reply
User avatar
vernonvd
Member
Posts: 38
Joined: Tue Oct 09, 2012 9:21 am
Location: Pretoria, South Africa

Remove rows from CSV

Post by 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 :shock:
User avatar
magnussandstrom
Advanced member
Posts: 356
Joined: Thu Jul 30, 2020 6:34 pm
Location: Sweden
Contact:

Re: Remove rows from CSV

Post by 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
User avatar
vernonvd
Member
Posts: 38
Joined: Tue Oct 09, 2012 9:21 am
Location: Pretoria, South Africa

Re: Remove rows from CSV

Post by vernonvd »

Hi magnussandstrom,

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

Thanks.
User avatar
magnussandstrom
Advanced member
Posts: 356
Joined: Thu Jul 30, 2020 6:34 pm
Location: Sweden
Contact:

Re: Remove rows from CSV

Post by 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.
User avatar
magnussandstrom
Advanced member
Posts: 356
Joined: Thu Jul 30, 2020 6:34 pm
Location: Sweden
Contact:

Re: Remove rows from CSV

Post by 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

flow.png
flow.png (22.13 KiB) Viewed 2544 times
Post Reply