I have a problem in which i have to clean the data to remove the leading special characters
Input output
_5abc_%agdj 5abc_%agdj
//rsf_@qtr_ rsf_@qtr
Thanks for your help
Hi @npd
Try this:
REGEX_Replace([Field1], '[^A-Za-z0-9]+(\w.*)', '$1')
Hello @LUKE_C I tried this it is not providing the exact result if there is a single special character or if there is a space and special character one after the other example A & B it is giving output as AB but it should clean only the starting special characters
Hi @npd - please provide a more representative dataset
Please find the sample data that i have:
_.ab. &q23
/bgj_try%abd_23− CAM FIELD:CODE & TEST
@npd
