Replace special character with string

[Payal1]

Hi community,

I am using text file as an input where few rows has Up arrows(as shown below), I want to replace that with a string 'Up Arrow'.

Thanks

[DeanWest]

Hello,

 You can use a formula tool to find that value within a field and replace/flag that row with the string "Up Arrow".

Try the following formula to create a new field containing the desired string:

If [Field1] = "↑"
THEN "Up Arrow"
ELSE Null()
ENDIF

Try the following formula to replace the "↑" with "Up Arrow" in the same field:

If [Field1] = "↑"
THEN "Up Arrow"
ELSE [Field1]
ENDIF

Here is a snippet of an example I created: 

Please let me know if you need any more help with this issue 🙂

[Payal1]

Hi Dean,

Sorry the formula did not work. The arrows look like this

[DeanWest]

In addition, you could also use a Find & Replace Tool or Join Tool if you want to use a lookup table (if it suits your use case better).

I've attached some more examples below:

Create a Lookup Table:

Replace the "↑" with an "Up Arrow" string:

Or create a flag by appending the "Up Arrow" string to the row containing the "↑".

Please let me know if you need any more assistance 🙂

[DeanWest]

@Payal1 

To fix the formula replace the "↑" with the Unicode character you are using. You can copy it in the results menu by clicking on a cell that contains the character or copy it from your text input. 🙂