Hi Guys,
i have a scenario where i have a string like BB(SPACE)(SPACE)R(SPACE)DD(SPACE)(SPACE)A.
I need output as BB R,DD A. That is always 5 characters & 5 characters include space sometimes or may not have spaces like WBBBCDEEES as WBBBC , DEEES.
which regex function would satisfy both?
Thanks,
Nandy
Solved! Go to Solution.
Hi@clarke,
it works , but I need more than two columns i.e split and put in as many columns it needs.
I tried the same using Tokenize but it threw an error.
Hello @Nandy,
This will always start with a letter now
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards
Hello @Nandy,
As far as I can see, my formula is giving the correct results.
Do you want them to be in the same column?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards
Thanks Yeah it works 🙂
HI Marq,
([[:alpha:]].{4})-- Could you explain the function , this works actually.
Thanks
Hello @Nandy,
What this function does is parse the data from 5 in 5 characters always taking a letter as the first one, if there is none (like a space) it gets skipped and goes for the next one.
Regards
Hi ,
what if it starts with number , sometimes data is like that as well. Will it still work
Thanks,
Nandy
Hello @Nandy,
Then change it tho this:
([[:alpha:]].{4}|\d.{4})
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards
Thanks a lot .
It worked .
Thanks,
Nandy