Merge field value if space exists

[Former Member]

Hi experts,

I have defined source and target field type as string. My requirement is ....

When i get a field value like 1.02 5687, it should combine both. Means the field value to be 1.025687. But am not sure the spaces are sometimes single or double space or triple spaces occur. Irrespective of the number of spaces it should merge and should be sent to the target field.

Is there any UDF or MAPPING for fulling this requirement?

Thanks.

[Former Member · Accepted solution]

Hi Swarna

Use the Text functions 'trim' and 'concat'

You dont need an UDF for this

[KennethEriksen]

Hi,

Or if you get the two values inside one source field and just want to remove the spaces (blanks) from the inputstring, use standard function "replaceString" with input " " and "".

Br,

Kenneth

[Former Member]

Hello Ken,

Great. Its done with mapping. Used replaceString with 1 space constant and empty constant as inputs & and mapped to the target field.

Works fine.

Rewarded.

Thanks.