|
-
Jul 17th, 2014, 03:57 PM
#1
Thread Starter
New Member
How do I process a csv file and save to the same file?
Hello,
I have a csv file to be processed, here is what I want:
The file is huge (>1GB), it's in fixed width, I need to remove all the blank spaces between each column, the last column seems to be 20 characters width but when the value is 0 it becomes only one character width following carriage return and starts another line of data.
I want to write a program to read into the file and replace all the blank spaces with a tab so that the csv is changed to tab delimited.
And as the file is huge, I wonder if I can do the replacement in the same file? I don't want to generate another huge file on my machine.
Can someone give me any suggestion? Thank you very much.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|