How do I find and remove funny characters?,How do I find and remove funny characters from a string?

Hi @jessbeach,

I simulated your case with a transformer AttributeCreator: att = ^Canada

The transformer StringReplacer do what you want.

In Text to Replace you write your symbol: ^

Attached the template file ( FMWT )

Thanks,

Danilo - -workspace-replace.fmwt

Just add to @danilo_inovacao answer which replaces any ^ symbol, but you mention funny characters so possibly you have additional characters. You can still use the StringReplacer but in Replace Regular Expression Mode where you can use Regex to list the characters. But be aware some Regex characters have special meaning including ^ so you would have to escape them.

Here is an example with some funny characters.

Why would you want to remove the funny characters? If a character makes you laugh, it should be worth keeping - I say, remove the non-funny ones! ;-)

Hi @jessbeach

if you have a number of 'funny characters' to remove, you might want to use StringPairReplacer to replace all of them with... 'something' that can then be replaced with 'nothing' using StringReplacer.

In the attached example I am getting rid of #, ^, and ( in my string:

• first I replace each not needed character with © which is not used in my data;
• then I replace all © characters with nothing;
• then... I get some not needed multiple spaces (removed characters were surrounded with spaces, we took the characters away leaving all the spaces in place) - we can fix this using regex.removefunnycharacters.fmw

Jess,

A tool you can try is the StringCleaner Transformer available from the FME Hub.

Download directly from within FME thru the Transformer Panel - FME Hub - Strings - StringCleaner OR visit:

StringCleaner Transformer Link

..............

Regular Expressions - VERY useful within FME - these will help in with your particular question.

A good place to start learning / testing them is:

http://rubular.com/

..................

Hope this helps

Howard L'

Sometimes it's easier to keep the non-funny characters than removing the specific characters you do not want

e.g. removing everything that's not a space or a word character in a stringreplacer with the following regular expression

[^\\s\\w]