Jan 30, 2003, 8:10 AM
Post #1 of 4
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,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