Output is _x000d_

[Sayeed1]

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

[Sayeed1]

Please review the attachment.

[CharlieS · Accepted solution]

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. 

[Sayeed1]

Thank you so much. It is the best solution.