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
Solved! Go to Solution.
let's try:
regex_replace([your field],"[~\|\,\~\ _]","")
cheers,
mark
to extract these characters you can use regex and then I removed white spaces.
Let me know if it works for you.
Regards,
Karolina
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.
Hi @vinodbombale ,
I think mine might be the simplest (in fitting with my personality).
Simple Regex:
M.