RegEx

[RolandG]

Hallo zusammen

Ich möchte mit dem RegEx Tool zwei Spalten hinzufügen. Die Informationen sind in einer Spalte vorhanden.

Alt

Name

BC297 Zürich (471)

BC186 Bern (198)

BC1364 Aarau 2nd Currency (4154)

Neu

BC	BK	Name
297	471	Zürich
186	198	Bern
1364	4154	Aarau 2nd Currency

[alexnajm]

Try this:

[Jonathan-Sherman]

Hi @RolandG,

You could use, i've also attached the example.

.*?(\d+)\s+(.*?)\s+\((\d+)\)

Kind regards,

Jonathan

[Jonathan-Sherman]

To add a bit of understanding to the regex, effectively the \d+ searches for numbers at the start and end of the text, wrapped in the brackets to extract them. Then we're searching and extracting for any text between the two spaces after and before the set of numbers at the start and end.

[Rhys_Cooper]

Hi @RolandG 

thank you for posting your question. This Regex parsing problem requires the following regex statement to split into the three columns:

 .*?(\d+) ([a-zA-Z0-9\s]+) \((\d*)\)

The regex parse tool is used to rename the fields. Since the original field shares the same name with one of the desired field names, the select tool has to be used subsequently to achieve this. Hope this solution is dynamic enough for your problem! 

Please see the screenshot below and solution workflow attached.

Regards - Rhys Cooper