Convert all .csv files in a folder to .txt format.

[TheHack22]

Hi All,

I have numerous files in a folder that's in .csv format. I would like to convert all the .csv files to .txt format.

Can someone please help me with a VBA code to accomplish this, if this is possible?

Thanks
Imran

 

[Joe4]

You need to provide more details.
There are many different "txt" file formats (i.e. fixed-width space delimited, tab-delimited, etc).
So we need to know exactly what kind of txt files you need.
Is it fixed-width or delimited?

If fixed-width, we need to know the size of each field.

If delimited, we need to know what the delimiter is.

And does the file require any sort of text qualifiers?

 

[TheHack22]

You need to provide more details.
There are many different "txt" file formats (i.e. fixed-width space delimited, tab-delimited, etc).
So we need to know exactly what kind of txt files you need.
Is it fixed-width or delimited?

If fixed-width, we need to know the size of each field.

If delimited, we need to know what the delimiter is.

And does the file require any sort of text qualifiers?

 

[TheHack22]

Hi Joe,

Thanks for your question. It's delimited - comma. The text qualifier is also a comma.

Imran

 

[Joe4]

Thanks for your question. It's delimited - comma. The text qualifier is also a comma.

I am not asking you what the current format is. I am asking what format you want to convert it to.
"Text" does not really tell us very much, as that can mean many different things.

Also, commas cannot be text qualifiers. Text qualifiers are used to surround text.
For example, if you have text that may have commas in it, you would need some way to differentiate commas that are delimiters versus commas that are literal text.
Quite commonly, double-quotes are used as Text Qualifiers, meaning that any commas found between two sets of double-quotes are to be treated as literal text, and not delimiters.

For example, let's that that you have data like the following:

Name	Address	Age
Jane Smith	1 Main St, New York, NY 11111	24​
Bill White, Jr.	15 River Way, Miami, FL 22222	37​

In a CSV file with text qualifiers, it might look something like this:
"Jane Smith","1 Main St, New York, NY 11111",24
"Bill White, Jr.","15 River Way, Miami, FL 22222",37
(color coded to show each piece).

Notice how all commas inside of double-quotes are literal text, and the ones outside are delimiters.

Back to the original question, it might be helpful for you to post a small sample of your CSV data, and what you want your expected result to look like.
Just be sure to remove/dummy-up any sensitive/personal data.