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 InputExpected OutputREG1 | 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

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

Hi @vinodbombale ,

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

Simple Regex:

regex is my friend.yxmd

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335