Home » U++ Library support » U++ Core » Retriving data in record containing ""
Re: Retriving data in record containing "" [message #33645 is a reply to message #33644] |
Sat, 03 September 2011 19:16   |
|
Hi,
It is very simple:
0. if first char is new line then create new record
1. first check if the next char is "
2. if first char is " yes then get value till next ", skip "," and repeat 1
3. if first isn't " then get next value till ,, skip "," and repeat 1
in your example, point 3 is never used.
Hope this help you.
Ion.
forlano wrote on Sat, 03 September 2011 17:47 | Hello,
I have records like this
"81116","180","","Lüigi,MacFarlane,Dr.","M","D","1948 ","201113","2577","173","2593","GM","4600010","GER "
I need to retrive the data separated by ','. Unfortunately this sign is used inside column 4 and give problem to Split(). Column 4 sometime has one ',' and sometime two ','.
Is there some special method to process such a record?
Thanks,
Luigi
|
|
|
|
Goto Forum:
Current Time: Tue Aug 26 04:41:43 CEST 2025
Total time taken to generate the page: 0.00393 seconds
|