Output is _x000d_

Hi all,

My data has range of number like 1-10, 20-30, till 90-100. I want the same range in output. However, the output in excel is 1-10_x000d_ , 20-30_x000d_ and so on.

Please help me how to get rid of _x000d_

Thank you so much,

Sayeed

Tips and Tricks

Accepted answers

CharlieS

One way to resolve this is to edit the string to only take the value to the left of the first "_" character. Here's an IF statement to achieve this in a Multi Field Formula tool:

IF Contains([_CurrentField_],"_") THEN Left([_CurrentField_],FindString([_CurrentField_],"_"))
ELSE [_CurrentField_] ENDIF

Check out the attached example to see this in action.

20191204-RemoveSuffix.yxmd

All comments

Sayeed1

Please review the attachment.

error.PNG

CharlieS

One way to resolve this is to edit the string to only take the value to the left of the first "_" character. Here's an IF statement to achieve this in a Multi Field Formula tool:

IF Contains([_CurrentField_],"_") THEN Left([_CurrentField_],FindString([_CurrentField_],"_"))
ELSE [_CurrentField_] ENDIF

Check out the attached example to see this in action.

20191204-RemoveSuffix.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703