Hi Guys, I hope u all doing well.
I have a text as |Dividend income|66|25|78|1,256|361 and I want how can i get the values till second pipe from the end using Regex_Replace formula only (not via Regex tool),
required output is |1,256|361 please help with the Regex formula. Thanks.
Solved! Go to Solution.
Hi @RajatRehria
One way of doing this.
REGEX_Replace([Field1], "(.+)(\|.+\|.+)","$2")
Many thanks
Shanker V
Many thanks to both of you guys, it worked. Can u please help me in one more thing that how can I learn the RegEx the way you guys are expert, any book, cheat sheet, or article where i can learn from very basic to advanced then please let me know. Many thanks again.
I recommend practicing through regex101: build, test, and debug regex!
Hi @RajatRehria
@alexnajm suggestion is the best which I will also suggest too. In additional, you can also make use of the below.
https://www.youtube.com/watch?v=Mxx0Or8oBYc
Many thanks
Shanker V
Thanks again :)
what if I want to pull everything to the right of the first space
FRLP72S 12
IHLE41AL 144
SFLM54AB 60
desired output from the above
12
144
60
@Meggan RegEx_Replace([Field], ".+\s(\d+)", "$1")
@alexnajm worked beautifully - thank you!