topic Re: Remove symbol in Application Development and Automation Discussions

Remove symbol

divsmart — Wed, 01 Jul 2020 10:48:46 GMT

I need to remove the "special character ' (what ever character could).. I now "Replace all occurances statment".

I tried it but not resolve , someone help me..

Attached an sample program...

Sandra_Rossi — Wed, 01 Jul 2020 11:09:31 GMT

What do you call "normal character", and what do you call "special character"?

divsmart — Wed, 01 Jul 2020 11:12:53 GMT

Sandra ,

Special character...

felipe_dimmu23 — Wed, 01 Jul 2020 11:30:28 GMT

You could use regular expressions,

replace all ocurrences of regex `[^0-9a-zA-Z]+` of ... with ''.

Regards,

Felipe Silva

venkateswaran_k — Wed, 01 Jul 2020 11:30:52 GMT

try this code

REPLACE ALL OCCURRENCES OF REGEX '[^\D]' IN c_name WITH ''

Regards,

Venkat

felipe_dimmu23 — Wed, 01 Jul 2020 11:31:32 GMT

I'm not sure my regex is right, usually I use this site to test them

Sandra_Rossi — Wed, 01 Jul 2020 11:46:26 GMT

You mean the ellipsis …? Only this character? It seems easy to remove it, can you clarify your problem?

PS: please use COMMENT. The button ANSWER is only for proposing a solution.

venkateswaran_k — Thu, 02 Jul 2020 09:29:56 GMT

Is your problem resolved?

navneeta — Thu, 02 Jul 2020 12:20:39 GMT

Try this code it will remove all special characters .

   REPLACE ALL OCCURRENCES OF REGEX '([^a-zA-Z0-9\s])' IN wa_test-name  WITH ''.

Thanks

Navneet