Splitting CSV or TXT

Post Reply
nfulton
Newbie
Posts: 10
Joined: Thu Jul 21, 2022 3:00 pm
Contact:

Splitting CSV or TXT

Post by nfulton »

Hi. I am new to Switch and could use some help working with a csv/txt file.

I need to accomplish a few things:
1.Split the file into multiple files based on who the "Salesperson ID".
2. Add a column called email "address"
3. combine the files back together.

There are a few steps in-between and after but these are the things I am stuck on. Any and all help would be appreciated.
Attachments
Archive.zip
Contains my starting list
(3.98 KiB) Downloaded 113 times
User avatar
JimmyHartington
Advanced member
Posts: 282
Joined: Tue Mar 22, 2011 7:38 am

Re: Splitting CSV or TXT

Post by JimmyHartington »

I have used https://www.easydatatransform.com to transform csv-files (and other datafiles).
And this can be integrated into Switch since it can run in as a commandline tool.
nfulton
Newbie
Posts: 10
Joined: Thu Jul 21, 2022 3:00 pm
Contact:

Re: Splitting CSV or TXT

Post by nfulton »

Thank you Jimmy! I will dive into that.
joaodaffonsojr
Member
Posts: 23
Joined: Wed Sep 08, 2021 4:36 pm

Re: Splitting CSV or TXT

Post by joaodaffonsojr »

JimmyHartington wrote: Wed Oct 05, 2022 8:48 am I have used https://www.easydatatransform.com to transform csv-files (and other datafiles).
And this can be integrated into Switch since it can run in as a commandline tool.
Great Tip !
It helped me so much !

Thanks !
User avatar
JimmyHartington
Advanced member
Posts: 282
Joined: Tue Mar 22, 2011 7:38 am

Re: Splitting CSV or TXT

Post by JimmyHartington »

That is nice.
And I would like to point out the the developer of EasyDataTransform is very active on their forum (https://forum.easydatatransform.com), if you have a question.
Post Reply