Only keep specified characters

[mac95]

Hi there,

I have a spreadsheet with addresses in different alphabets, but I only want to keep characters from the Latin alphabet as well as some symbols. For example:

河南省 Henan Province becomes just Henan Province

*221/B, [Baker Street] * becomes just *221/B, Baker Street *

I know there’s a way to filter out rows containing undesired characters, and another way to specify which characters to remove, but I think it’d be easier in my case to specify which characters to keep. Is this possible?

Many thanks!

[Daniel_Weikert]

@mac95

221/B, [Baker Street]

you probably want to use regex with e.g. string manipulation

This needs some refinement for your case (we do not know what special characters you want to keep) but could hopefully get you started
br

[tqAkshay95]

Hello @mac95 ,
You can use the ‘String Manipulation’ node in KNIME with the expression like:

" regexReplace($COL-1$, “[^a-zA-Z*\/\\.,\s]+”, “”)"

Please refer to the attached images for additional context.

output:

[mac95]

This seems to have done the trick - many thanks!

[mac95]

That seems to have done it - thank you