This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Tried and read everything but still have some issue...
need to be:
Look like the number between '60400' ~D and ^D is not being replace.
Hi @truct-kp ,
Hope this helps.
Nope, I tried that before. I even put \ before my special character, but it not working
Strange, it's working when I test it,, alternative is
Regex_Replace([ARRAY], "~D.+D","") ?
your suggest solution is very straightforward and I had try them and other variation as well.
All attempts are not working. very weird.
Will open a case with support.
If you can, post your workflow or data extract - your data might have some end spaces or newlines etc not copying across on your original post.
Give it a shot.
You have not removed the null condition from your RegEx, it is showing as: Regex_Replace([CVRG_ARRAY_TX_CHOICE],"~D.+D",null())
The null() is replaced by ""
Sorry, please try this package