
gokavar
New User
Jan 30, 2003, 8:10 AM
Post #1 of 4
(2248 views)
|
File Splitting
|
Can't Post
|
|
Hi, I am having a csv file with 5 columns.One of the column is a description of length 50characters and may have any characters like comma or hypen as part of the description. I am using comma as the delimiter to split the file to do the validations as the columns may not be of fixed length. But if the description has a comma , it is being split in to two sample data looks like this... C5,L10,ACTB,"OldACTB-MultisDecile1,2""", gokavars C5,L05,ACTM,New LTV/ACTB - Manhattan , gokavars N4,L52,ACTB,ACTB - 3X+ MULTIS DECILE 4 ,gokavars After running my program my data looks like this C5 | L10 |ACTB |"OldACTB-MultisDecile1| 2""" C5 | L05 | ACTM | New LTV/ACTB - Manhattan | gokavars N4 |L52 |ACTB | ACTB - 3X+ MULTIS DECILE 4 |gokavars Is there anyway I can make the first row look like C5 | L10 |ACTB |"OldACTB-MultisDecile1 2""" | gokavars
|