Find and extract selected characters from the string, sequence is important

[vinodbombale]

Hello team,

I want to extract |, ~ and __ from the string value. sequence of these character matters in output. String value may have sentences.

Below is the example for expected output

Input	Expected Output
REG1 | REG4	|
REG2a ~ REG2b | REG5	~|
REG3a ~ REG3b ~ REG3c | REG6	~~|
HTA2a __ HTA2b | HTA5	__|
HTA3a__HTA3b1~HTA3b2__HTA3c | HTA6	__~__|

It would be great if you can help with work flow for character extraction.

Thanks in advance

Vinod

[MarqueeCrew]

@vinodbombale ,

 let's try:

regex_replace([your field],"[~\|\,\~\ _]","")

 cheers,

 mark

[KarolinaRoza]

Hi @vinodbombale 

to extract these characters you can use regex and then I removed white spaces.

Let me know if it works for you.

Regards,

Karolina

[RaviP]

Hi @vinodbombale, here's one without using regex, using the data cleansing tool. Works when your input has only numbers and letters, along with the special characters.

[mceleavey · Accepted solution]

Hi @vinodbombale ,

I think mine might be the simplest (in fitting with my personality).

Simple Regex:

M.