MQSeries.net :: View topic

satyasheel15 · Posted: Thu Jul 03, 2003 9:23 pm Post subject:

Question:

I need to locate the position of CRLF in a string.
The POSITION function does not return it and SUBSTRING returns it as space ' '.

EXAMPLE:
-----------
In the following xml message :

<AccountNumberAtDeliveryInstitution>803-3093-455</AccountNumberAtDeliveryInstitution><AccountWithInstitutionAccountNumber>44444</AccountWithInstitutionAccountNumber><AccountWithInstitutionBIC>BBBBBBBB</AccountWithInstitutionBIC><AccountWithInstitutionNameAddress>44 St.
London
Line3
Line4</AccountWithInstitutionNameAddress><........

For the xml portion from the above message:

<AccountWithInstitutionNameAddress>44 St.
London
Line3
Line4</AccountWithInstitutionNameAddress>

we have written the following ESQL code to map :

Set Temp_Crlf = '
';

POSITION(Temp_Crlf in InputBody.TMESSAGE.TMDIRECTIVE.AccountWithInstitutionNameAddress)
returns 0 ;

and

SUSBTRING(InputBody.TMESSAGE.TMDIRECTIVE.AccountWithInstitutionNameAddressFROM 14 FOR 1 )

returns ' ';

But this particular piece of code is not serving our purpose. Please let me how to handle this scenario.
Kindly advise and suggest.

Regards Always

Satyasheel