AnsweredAssumed Answered

String Left Trim function in Boomi

Question asked by faisal.ali397074 on Apr 17, 2018
Latest reply on Apr 17, 2018 by faisal.ali397074

Hi

I have two strings:

0008671560

0000000048

 

Within Boomi, I need to convert them to 8 characters (from the right side)

 

08671560

00000048

 

To do this, I am using map function left character trim

 

1.With 'fix to length' set to 8, I get: 

 

671560 (incorrect)

00000048 (correct)

 

2.Now if I try fix to length set to 10, I get:

08671560 (correct)

0000000048 (incorrect)

 

What is the correct function/setting to use? Left trim is a bit confusing in Boomi, do I need to resort to scripts?

 

Thanks for your help!

Outcomes