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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mvistan
    New Member
    • Apr 2010
    • 1

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

    Hi,
    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

    "Destinati on_" "___Code___ " "______Date____ __" "Origin" "IPAddress"
    16268087322 16268087 04/04/10 11:56 PM 4147554720 "70.42.72.1 57"
    12128774091 "1212877_" 04/04/10 11:11 PM 296055180 "70.42.72.1 57"
    18013620280 "1801362_" 04/04/10 11:51 PM 7783730894 "70.42.72.1 57"
    17322667065 "1732266_" 04/04/10 11:39 PM 4147554720 "70.42.72.1 57"
    16178405990 "1617840_" 04/04/10 11:06 PM 4147554720 "70.42.72.1 57"


    Thanks!
    Mvistan
  • numberwhun
    Recognized Expert Moderator Specialist
    • May 2007
    • 3467

    #2
    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.

    Regards,

    Jeff

    Comment

    Working...