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

[Shaaz]

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.

[Qiu]

@Shaaz 
It depends on the data structure of your text file input.
And also are all the text files having same schema?
Can you share a sample input?

[Shaaz]

No, each file has different column names.

Here I don't want to append or do anything, just trying to save all 200+ files as csv file.

[Qiu]

@Shaaz 

We still need to know the data structure and decide delimeter in the original text file.

[Shaaz]

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

[atcodedog05]

Hi @Shaaz 

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

Happy to help : )

[Shaaz]

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).