asked on Convert .csv to tab delimited text
I am working with a comma delimited .csv file and want to convert to tab delimited .txt file. However, there are more than 1 million records so I cannot accomplish using Excel unless I split the records which I do not want to do. Is there another method I can use to convert the .csv to tab delmited .txt file? I can access the .csv file with Notepad++ or CSVedit but I don't use see any method to convert the delimiter from , comma to tab and save as text. Thanks for any help with this.
Scripting LanguagesWindows BatchVB Script
Last Comment
Bill Prew
Are there any commas embedded in the data fields, or are commas only used as delimiters?
~bp
~bp
ASKER
thanks for the replies. I will try the notepad++ find and replace and see how it works. With regards to the comma's they are only used as delimiters.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I tried to do the n notepad++, you can do a Edit > Replace
Set Search Mode = Extended
Find what ,
Replace with \t
but I don't see the Set Search Mode, in Find replace it will just replace the , with \t
I can open in Wordpad and do a find , and replace with ^t to accomplish but the file is so large it tends to freeze up when I do this.
Set Search Mode = Extended
Find what ,
Replace with \t
but I don't see the Set Search Mode, in Find replace it will just replace the , with \t
I can open in Wordpad and do a find , and replace with ^t to accomplish but the file is so large it tends to freeze up when I do this.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
If your old version has the Search Mode = Regular Expression option, it works with that, also.
ASKER
I found setting in Notepad++ (thanks for the updated info), I tested the VBscript method and it works great. Its much easier to use a script when you have very large files. Thanks for all the help
ASKER
Thanks again
ASKER
thanks again
Very welcome, glad that was helpful, thanks for the feedback.
~bp
~bp
Set Search Mode = Extended
Find what ,
Replace with \t
Save as. Just change ext to txt. e.g. newfile.txt