Replace ChiNA as China

[Bkau_40]

Hi Team, is there an easy way to change ChiNA to China in column. Also for Usa to USA 

[Qiu]

@Bkau_40 
Find and Replace is the one here, and easy for maintenance also.

[CharlieS · Accepted solution]

Hi @Bkau_40 

The general idea I'm going to suggest is to use the Replace( function. It will look something like this, where [Field] is where the values are stored:

Replace({Field1],"ChiNA","China")

But when you're working with multiple replacements, it might be easier to use the Find Replace tool. It has a case insensitive match (which I suggest), and then the replacement will have the capitalization you set.

Check out the attached workflow, there's an example of both in there. 

[Bkau_40]

Thanks very much you save me a lot of time. You are the best. Bravo

[Qiu]

@Bkau_40 

Anything wrong with mine?😁