Idoc issues - value changes

[Former Member]

I have an issue where we recieve a field in an IDOC -

<E1PLOGI SEGMENT="1">

<E1PITYP SEGMENT="1">

<E1P1001 SEGMENT="1">

<SOBID>UK76610 XE10FINANCE</SOBID>

But from another system it appears as

<E1PLOGI SEGMENT="1">

<E1PITYP SEGMENT="1">

<E1P1001 SEGMENT="1">

<SOBID>UK76610 XE10FINANCE</SOBID>

As you can see there are to additional spaces in the second example.

I am using a rather complex mapping sequence to chop the data up (substring without length), lookup values, add a number mask then concatanate a value on the end. Can you use the substring from a space within a field, instead of a fixed point?

It works perfectly in Development but in test the fewer spaces cause a problem with the mapping.

[Former Member]

All fixed and working!

[Former Member]

Barry,

Then what you have to do is to write a UDF. It will check the space and take the substring starting from the space to the end. Is this what you are looking for?

---Satish

[Former Member]

> Barry,

>

> Then what you have to do is to write a UDF. It will

> check the space and take the substring starting from

> the space to the end. Is this what you are looking

> for?

>

> ---Satish

That is it!

I have a udf I've written already, but that was for a fixed point and not a space.

int i = Integer.parseInt(a);

String c = b.substring(10,i);

return c;

I will change this then?

[prabhu_s2]

couldnt figure out the difference between the two strucutres

[Former Member]

It doesn't make it clear.

There are three spaces in one and only one space in another.

From position 1(0) to the X is ten characters with one system and eight characters in another.