Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

xslt to find substring

bobSep 17 2014 — edited Sep 17 2014

Hi All,

we have below id coming from source system:

1111-000-2222-1234567890-333-4444-555

we need to pass different id to target system such as:

target_ID1 = 1234567890  (i.e. segment 4)

target_ID2=2222 (i.e. segment 3)

target_ID3=000 (i.e. segment 2)

there is also one more rule applicable that, if segment 3 of source ID is less than 4 character i.e.(222) then for target_ID, one '0' should be prefixed so target_ID2 will become 0222.

Please let us know how to achieve this using xslt transformation, or if there is any better way.

TIA,

Bob

This post has been answered by Daniel R. Dias on Sep 17 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 15 2014
Added on Sep 17 2014
3 comments
1,330 views