Hi, Anyone know of a fast way to separate this: Input 123-Apple-ABC-123-Apple-DEF123-Grapes-QRS-123-Apple-XYZ123-Pears-ABC-123-Grapes-TUV Desired Output: 123-Apple-ABC123-Apple-DEF123-Grapes-QRS123-Apple-XYZ123-Pears-ABC123-Grapes-TUV In the input there are no spaces. If there is a similar post can someone provide a link? Thanks!

Separate a string that has multiple delimiters by middle delimiter only

bleu

Hi,

Anyone know of a fast way to separate this:

Input

123-Apple-ABC-123-Apple-DEF

123-Grapes-QRS-123-Apple-XYZ

123-Pears-ABC-123-Grapes-TUV

Desired Output:

123-Apple-ABC	123-Apple-DEF
123-Grapes-QRS	123-Apple-XYZ
123-Pears-ABC	123-Grapes-TUV

In the input there are no spaces.

If there is a similar post can someone provide a link?

Thanks!

Regex

Tips and Tricks

Preparation

Interface Tools

Accepted answers

ArtApa

@bleu - Here is a possible solution:

String AA.yxmd

flying008

Hi, @bleu

As your want, after the 3rd '-' must be a number ? or the second 123 must be like the first 123?

^([\w\-]+?)-(\d.+?)$

bleu

Thank you ArtApa, never used the Tile before

All comments

ArtApa

@bleu - Here is a possible solution:

String AA.yxmd

flying008

Hi, @bleu

As your want, after the 3rd '-' must be a number ? or the second 123 must be like the first 123?

^([\w\-]+?)-(\d.+?)$

bleu

Thank you ArtApa, never used the Tile before

bleu

flying008 I'd like it to work for any number or string or character at any length. There will always be a total of 5 "-"s in the string

I want it to always separate it by the third "-"

So I'd like it to work for something like this too:

Input

123W-ABC-67-123W-RTP-55

112W-ABC-4G-456W-QRS-55

789W-ABC-2-123W-LPN-22R

Output

123W-ABC-67	123W-RTP-55
112W-ABC-4G	456W-QRS-55
789W-ABC-2	123W-LPN-22R

flying008

Hi, @bleu

As you said, so the below regex expression for you:

^(\w+\-\w+\-\w+?)\-([\w-]+?)$

bleu

Thank you flying008!

It's tricky but I'm starting to get the hang of it.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703