cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

CPI: SubString Function Issue while mapping target field

babruvahana
Contributor
9,839

Hi Experts,

I working on a mapping where I need to restrict the char length of the source field.

If the character length is less than the character count defined in the substring function, the mapping fails with String out of index

The same mapping workings in PI. But it failed in CPI.

Is it a normal behavior or I am doing wrong with my mapping or any other ways to achieve this simple mapping in CPI?

Any pointers would be of great help.

View Entire Topic
MateuszAdamus
Active Contributor
0 Likes

Hello babruvahana

Is the IF (or IF$) even required here? Same goes for LENGTH.

Can't you CONCAT 30 spaces at the end of the input string, then take the first 30 characters of the resulting string with SUBSTRING and then TRIM the result of SUBSTRING?

Kind regards,
Mateusz