By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,933 Members | 1,675 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,933 IT Pros & Developers. It's quick & easy.

parses a cvs file: open and save in a new file but needs to check a certain column

P: 1
I have a csv file with multiple rows and columns. I need to check a certain columns like column 5 from its first field, its contains numbers. I need to check if those numbers has zero in front of every number.

my file is like below

"Destination_" "___Code___" "______Date______" "Origin" "IPAddress"
16268087322 16268087 04/04/10 11:56 PM 4147554720 ""
12128774091 "1212877_" 04/04/10 11:11 PM 296055180 ""
18013620280 "1801362_" 04/04/10 11:51 PM 7783730894 ""
17322667065 "1732266_" 04/04/10 11:39 PM 4147554720 ""
16178405990 "1617840_" 04/04/10 11:06 PM 4147554720 ""

Apr 27 '10 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 3,503
Ok, do you have a question? We are not a coding shop and will not write your code for you. You are going to have to do the main legwork on this. Why not try to code it, and if you get stuck, post your code here with an explanation of where you are stuck. Then, we will gladly help you with your code.


Apr 28 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.