Save multiple txt files as csv files but with the same filename

Question

Hi All,

I've around 200+ txt files in a folder, how to save all of these files as .csv file instead of .txt

Example:

Sample Input files >>

File1: Payments.txt

File2: Region.txt

Output file >>

File1: Payments.csv

File2: Region.csv

Here I'm just trying to save the file in csv format.

Shaaz · Answer

Hi,

No, they are different.

Please find the attached sample files.

Here my files are in .txt format (tab delimited), I would like use these files in my input tool, run workflow and save them as .csv file (comma delimited).

Income.txt

CountryInfo.txt

atcodedog05 · Answer

Hi @Shaaz

Does all files have the same schema. Can you provide sample files.

Happy to help : )

Shaaz · Answer

In txt file, it will be tab delimited... csv file should be comma delimited.