| Author |
Message
|
| Ajju. |
 Posted: Mon Dec 09, 2002 11:38 am Post subject: HOW TO ELIMINATE SPACES |
 |
|
Voyager
Joined: 26 Jul 2002
Posts: 77
|
Hi all,
I am having problem parsing the input data which has trailing white spaces in it.
my input is TDS format and output shud be XML format.
this is in context to my previous submitted question.
input is data1:vaue1||data2:value2||
and output shud be xml.... whcih i am getting when using debugger on and it goes to fail queue if debugger is OFF.
thanks in ADV.
Ajju. |
|
| Back to top |
|
 |
| lung |
| Posted: Mon Dec 09, 2002 4:58 pm Post subject: |
|
|
Master
Joined: 27 Aug 2002
Posts: 291
Location: Malaysia
|
Have u try using the 'TRIM' function? 
_________________
lung |
|
| Back to top |
|
|
| Ajju. |
| Posted: Tue Dec 10, 2002 4:31 pm Post subject: |
|
|
Voyager
Joined: 26 Jul 2002
Posts: 77
|
Thanks Lung,
But can u give a code exactly how to trim leading spaces of incommming message.
Thanks in adv,
Ajju. |
|
| Back to top |
|
|
| lung |
| Posted: Tue Dec 10, 2002 4:48 pm Post subject: |
|
|
Master
Joined: 27 Aug 2002
Posts: 291
Location: Malaysia
|
Well, for example if InputBody.CustomerName is 'Ajju ' and u just want 'Ajju' without the trailing spaces...
| Code: |
| SET abc = TRIM(InputBody.CustomerName); |
Where abc is simply a variable...
_________________
lung |
|
| Back to top |
|
|
| Ajju. |
| Posted: Tue Dec 10, 2002 6:55 pm Post subject: |
|
|
Voyager
Joined: 26 Jul 2002
Posts: 77
|
Thanks lung,
But i think that what u are guessing is wrong....
My input data is like
data1:value1|| data2:value2||~~
Assume ~ is a space and i want to remove this from the incomming message.
input is tagged data and ouput generation is XML
it will be gr8 help if u can resolve this.
Thanks in adv,
Ajju. |
|
| Back to top |
|
|
| lung |
| Posted: Wed Dec 11, 2002 1:59 am Post subject: |
|
|
Master
Joined: 27 Aug 2002
Posts: 291
Location: Malaysia
|
Well, then maybe you can try this...
| Code: |
| SET OutputRoot.MRM = TRIM(InputRoot.MRM); |
Probably won't work, but you can give it a try
Sorry but I've no experience when it comes to working with tagged delimited messages...
_________________
lung |
|
| Back to top |
|
|
| Ajju. |
| Posted: Fri Dec 13, 2002 9:34 am Post subject: |
|
|
Voyager
Joined: 26 Jul 2002
Posts: 77
|
thanks lung,
but that did not helped..... now i am trying to eliminate the spaces using my java which parses the output XML.
thanks,
Ajju. |
|
| Back to top |
|
|
|
|
