Regular Expression

[Angiebels]

Hi All,

I'm trying to separate this data below in two columns which the second column is the existing one in the file.

Input:

Column1

ADCOUNCILAdCouncil

Output:

Column 1

ADCOUNCIL

Column 2 (existing column within file)

AdCouncil

I'm not sure what pattern to use in RegEx as there is no specific separator for that one.

Appreciate your help on this.

Thanks!

[Qiu · Accepted solution]

@Angiebels 
We can use a normal Replace function, if I understand your intention correctly.
We can also use a RegReplace, if you insist 😁

[Angiebels · Accepted solution]

Hi @Qiu

Thanks for the quick response.

The input should be ADCOUNCILAdCouncil and will be separated in two the first word (ADCOUNCIL)  to replace the originate column then the AdCouncil to the next column.

[Qiu · Accepted solution]

@Angiebels 
Like this?

[Angiebels · Accepted solution]

Thanks @Qui

That's exactly what I'm looking for.

Appreciate your help!!!

Best,

Angie

[Qiu · Accepted solution]

@Angiebels 
Glad I can help. 😁