| Author |
Message
|
| elvis_gn |
 Posted: Wed Mar 15, 2006 1:48 am Post subject: |
 |
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi ssk,
Are the fields fixed length....I don't suppose they are.
You will not be able to handle the comma between the fields, it will fail...
You could ask the sender of the message to convert the "," into some "#" and then after parsing, convert the "#" back to ","....
Or, define an extra field in the message set, and then concat then in the code  naughty right, i just thought of it 
Regards. |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Wed Mar 15, 2006 2:19 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi ssk,
I did not realise from your post that quotes were ACTUALLY part of the message.
I am not sure, but i guess you can make use of a combo of ," as the delimiter between the fields...and then trim the other ending "
I am not sure whether you can use two symbols as the delimiter, maybe put it between ' ' too 
Regards. |
|
| Back to top |
|
|
| Mensch |
| Posted: Wed Mar 15, 2006 3:24 am Post subject: |
|
|
Disciple
Joined: 17 Jul 2005
Posts: 166
|
|
| Back to top |
|
|
| elvis_gn |
| Posted: Wed Mar 15, 2006 3:52 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi Mensch,
| Quote: |
| u can use data patterns instead .. |
will effect performance
| Quote: |
| must be as efficient as possible even though we are attempting to use TDS. |
Regards. |
|
| Back to top |
|
|
| Mensch |
| Posted: Wed Mar 15, 2006 4:23 am Post subject: |
|
|
Disciple
Joined: 17 Jul 2005
Posts: 166
|
yeah Elvis ..you are right .
But when the incoming message is tricky .. using data pattern is the most effecient way to develope message set
but there are other options like using different combinations of group indicator and group terminator .
_________________
Thanks and Regards ,
Mensch |
|
| Back to top |
|
|
| shanson |
| Posted: Wed Mar 15, 2006 6:08 am Post subject: |
|
|
Partisan
Joined: 17 Oct 2003
Posts: 344
Location: IBM Hursley
|
| WMB V6 has sample message sets for modelling several variations of CSV message, including where fields are in quotes. It shows you how to handle optional quotes and to strip/preserve them. |
|
| Back to top |
|
|
|
|
