cancel
Showing results for 
Search instead for 
Did you mean: 

Handle prefix $ in message mapping

former_member196519
Participant
0 Kudos

HI Team,

Could you please suggest me how we can remove prefix $ in input string in message mapping..

Input string:

$546.00

$67899.09

$54.00

Expected output:

546.00

67899.09

54.00

Thanks for your suggestion!

Kumar

Accepted Solutions (1)

Accepted Solutions (1)

markangelo_dihiansan
Active Contributor
0 Kudos

Hello,

Just use the string function called substring in message mapping: start: 1, end: 0

Hope this helps,

Mark

Answers (2)

Answers (2)

former_member201264
Active Contributor
0 Kudos

Hi Kumar,

Just try with this below, Use your field name in place of LNAME.

Regards,

Sreeni.

Former Member
0 Kudos

Hi Kumar,

Just use substring function and assign the values start from 1 and end 0 in the properties.

That will remove the $ symbol from the payload.