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
Solved! Go to 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.
Thank you so much. It is the best solution.