Regex ,split

[Nandy]

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

[Nandy]

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.

[afv2688]

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

[Nandy]

Sorry ignore the attachment.  i have attached the right one.

Thanks a lot for helping me.

[afv2688 · Accepted solution]

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

[Nandy]

Thanks Yeah it works 🙂

[Nandy]

HI Marq,

([[:alpha:]].{4})-- Could you explain the function , this works actually.

Thanks

[afv2688]

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

[Nandy]

Hi ,

what if it starts with number , sometimes data is like that as well. Will it still work

Thanks,

Nandy

[afv2688 · Accepted solution]

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

[Nandy]

Thanks a lot .

It worked .

Thanks,

Nandy