Regex ,split
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm confused. If the total length of each part is 5 characters long, why not parse with the left () and right() function's?
Cheers,
mark
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Forget it, understoood something different
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @Nandy,
The formula tool removes all the trailing and leading whitespaces. If you need them or want them you just need to remove the tool.
If it is something else you want I couldnt understand you well.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi ,
The point i was trying to say is there are spaces in between strings ,
example AR(space)(space)D(space)DEEAK what happens to this is ,
it comes out as AR(Space)(space)D,(Space)DEEA.
Above case i would need AR K,DEEAK whereas the K is left because of the space considered between the strings.
Similar DE(space)(space)K(space)FJGE6-result as DE(Space)(space)K,(Space)FJGE.
I mean to say there would be always 5 characters including spaces , but not starting with spaces.
examples of strings AC D GAABI-->AC D,GAABI
Thanks,
Nandy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hI @Nandy How about this:
\s*(.{5})\s*(.{5})
Which will parse out 5 character strings, but will ignore any leading spaces for those strings
Ollie
