Steps I am doing -
- Read csv with delimeter tab (need to use tab as some issue with other delimeters) and store in DT
- Add three columns to DT
- Write csv with delimeter semicolon (because if other delimeters used then all column data is written in one column ony)
What happens is new column added are appended to last column with ; separated
I want it to write to csv with separate columns like
Please help with this!
Thanks in advance,