Regex ,split

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

Regex

Parse

Accepted answers

afv2688

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

afv2688

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

All comments

MarqueeCrew

@Nandy ,

have you tried something simple, like:

left(field,5)+","+right(field,5)

cheers,

mark

Nandy

Marq,

i would need a code to satisfy cases like that as well as cases where there are no spaces like .

I have list of different rows , example one would be CA T FA T --I want this as CA T,FA T

another one would be APPLETANGO as APPLE,TANGO.

Thanks,

Nandy

afv2688

Hello @Nandy,

I think I got it right now:

Since I don't know if you wanted the data in the same cell or in different I give you both options.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

parse_data.yxmd

Nandy

Hi ,

Great thanks , but i face another scenario if i use it.

Sometimes the data has leading white spaces in front or at the end of & data includes numbers as well.

Attached the scenario. think need small alterations in the workflow .

Thanks,

Nandy

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703