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.
Set Search Mode = Extended
Find what ,
Replace with \t
Save as. Just change ext to txt. e.g. newfile.txt