Link to home
Start Free TrialLog in
Avatar of Star Gazr1
Star Gazr1Flag for United States of America

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.
Avatar of NVIT
NVIT
Flag of United States of America image

In notepad++, you can do a Edit > Replace
Set Search Mode = Extended
Find what ,
Replace with \t

Save as. Just change ext to txt. e.g. newfile.txt
Avatar of Bill Prew
Bill Prew

Are there any commas embedded in the data fields, or are commas only used as delimiters?

~bp
Avatar of Star Gazr1

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
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If your old version has the Search Mode = Regular Expression option, it works with that, also.
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
Thanks  again
thanks again
Very welcome, glad that was helpful, thanks for the feedback.

~bp