Hello! I have line in my data, that contains someone chars and integers (example JRQ-215-42), i need post only 42, without others, can someone suggest, how can i do this in boomi?
Be grateful for any help.
Ok, in that case you could use the string split map function. Split by "-" and then define 3 outputs. The 3rd output will contain the number.
What's the format of the field? Is it always AAA-BBB-CC, and you want CC?
it always AAA$-111-X, where X is integer, and it variable 0 - 9999
you can do that very easily using the predefined string functions of Boomi.
Retrieving data ...