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.
Splitting CSV or TXT
Splitting CSV or TXT
- Attachments
-
- Archive.zip
- Contains my starting list
- (3.98 KiB) Downloaded 227 times
- JimmyHartington
- Advanced member
- Posts: 356
- Joined: Tue Mar 22, 2011 7:38 am
Re: Splitting CSV or TXT
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.
And this can be integrated into Switch since it can run in as a commandline tool.
Re: Splitting CSV or TXT
Thank you Jimmy! I will dive into that.
-
- Member
- Posts: 25
- Joined: Wed Sep 08, 2021 4:36 pm
Re: Splitting CSV or TXT
Great Tip !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.
It helped me so much !
Thanks !
- JimmyHartington
- Advanced member
- Posts: 356
- Joined: Tue Mar 22, 2011 7:38 am
Re: Splitting CSV or TXT
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.
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.