Splitting to Rows

[nickmarlboroughGS]

Hi,

In a field I have the text:

charlie,groves[CG],emilia,banks[EB]

I want to return two rows:

charlie,groves[CG]
emilia,banks[EB]

How would I do this? As the delimiter comma is frequent

[ShankerV]

Hi @nickmarlboroughGS 

One way of doing this.

Many thanks

Shanker V 

[ShankerV]

Hi @nickmarlboroughGS 

Step 1: Input

Step 2:

 

Step 3:

 

Many thanks

Shanker V 

[flying008]

Hi, @nickmarlboroughGS 

You can use comma and $ as regex delimiters to split string.

INPUT		OUTPUT
Txt		Txt
charlie,groves[CG],emilia,banks[EB]		charlie,groves[CG]
ABC.123[ABC],EFG.456[EFG],opq[123]		emilia,banks[EB]
		ABC.123[ABC]
		EFG.456[EFG]
		opq[123]

[Ranga116]

Hi, @nickmarlboroughGS  by replacing one comma that we want to split at with any letter/character bybusing formula tool and then splitting by using that perticular character/letter using text to column tool.