How to remove string character

[Beginer]

Customer09

how to remove string characters while linking one sheet data to another

($##%$)Customer09

eg:- PurgeChar("Customer Name", '(&$#^*%)') as "Customer Name"    {its not working}

[Clever_Anjos]

By "not working" you mean that any character is already at the string? any specific one?

[BrunPierre]

Hi, in your example the output string value is Customer09.

Perhaps you wish to remove the special characters and numbers from the string to get Customer

Then try this

KeepChar("Customer Name", 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz')

[Beginer]

yes there is bcz its not getting linked

[Clever_Anjos]

Maybe instead of purging to keep only the chars you are insterested in?

Like KeepChar("Customer Name",'ABCDEFGHIJKLM... ?

[NadiaB]

Hi @Beginer 

Could it be possible provide more details about what is being linked ? Could you provide an example or details of what is being implemented, probably step by steps to reproduce, a screenshot or a sample code? 

If you do  PurgeChar('($##%$)Customer09','(&$#^*%)')  you will get Customer09 as result. So it was not clear to me what is not working and what are you trying to accomplish, probably providing more details about my question above will help to clarify things. 

Hope it helps.