Hi,
I have a file which has fields seperated by ","(double quotes comma double quotes.
So data is like
"LAA","1644/10","+Jul","","","SURNAME-","FORENAME","1 FLOATED ONE "
I want to read each record in a single column - col1 and then cut the fields according to "," and do some validations on them. I am not reading it as a normal file as the data to be validated can come in any field like field 3 or field 4 . This 3 or 4 i am getting from a reference table.
I tried performing
Field(INP_3.col1, ('","'), INP_3.amend_flag_pos) where INP_3.amend_flag_pos is the position of the amend flag coming in from a reference table which is currently 3. So my output should be--------- +Jul
But my output is coming as --------------- ,"+Jul(comma double quote +Jul).
All the columns I cut using the field command has a ," before the actual data. Can anyone help me get the clean data.
Thanks
Harshada
Remove "," from a file to read each field
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 125
- Joined: Mon Sep 11, 2006 4:22 am
- Location: India