Extracting data within a string field split into different columns

[Lauren_Holmes]

Hello,

I am trying to extract some data within a couple of string fields. I have used text to columns, however i am not sure if there is a better way to do this? I have two columns TEXT 1 and TEXT 2 these both contain codes within the hashtags. I would like to extract these codes so the outputs are like columns "PARSE TEXT 1" "PARSE TEXT 2". I would then like to extract from TEXT 1 the date into it's own column.

I would be very grateful for any ideas on the best way to use this - i did wonder whether RegEx would work?

Example below.

TEXT 1	TEXT 2	PARSE TEXT 1	PARSE TEXT 2	DATE EXTRACT TEXT 1
LH1234 - 12 Jun 2021 - #ABC#	notified customer #JKL#	ABC	JKL	12 JUN 2021
LH1234 - 10 Jun 2021 - #DEF#	notified customer #MNO#	DEF	MNO	10 JUN 2021
LH1234 - 01 Jun 2021 - #GHI#	notified customer #PQR#	GHO	PQR	01 JUN 2021

[DawnDuong]

hi @Lauren_Holmes 

I think the comma is added because in the Summarise tool, you have set comma to be delimeter.

If you want a space to be delimeter instead, just replace it with \s.

Dawn.

[Lauren_Holmes]

Ahh yes you are right!

Thank you so much for all your help!