Enfocus Community

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.

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.

Thank you Jimmy! I will dive into that.

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 !

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.