RegEX - grab everything to the right of a pattern

[SylviaK]

Hi, 

Again struggling with RegEx. I would like to get from field 1 to field 2.  Essentially I want everything from "TEEST_XYZ File Name" onwards.

Field 1	Field 2
1/22/2021 SDFSD ASDFASDF-fix ADSFASDF SDFSDFSD -42.224061 < -35 67 COUNT(s):23,67 :TEEST_XYZ File Name - XYZ_zudds_20210122  has following  COUNT(s):23,67 1/23/2021 8:30:28 PM Low	TEEST_XYZ File Name - XYZ_zudds_20210122  has following  COUNT(s):23,67 1/23/2021 8:30:28 PM Low
TEEST_XYZ-COUNT   :    :TEEST_XYZ File Name - XYZ_ererg_20210125  Source_ID: 33134  File_ID: 40074  has following  COUNT(s):22	TEEST_XYZ File Name - XYZ_ererg_20210125  Source_ID: 33134  File_ID: 40074  has following  COUNT(s):22

I have tried using the REGEX Replace function as follows: (\.*)(\u{5}_\u{3}\s\w{4}\s\w{4}\.*) with replacement value $2, but that doesn't work. What am I doing wrong?

Thanks

[atcodedog05 · Accepted solution]

Hi @SylviaK 

Use a regex tool parse mode below pattern it gets everything after TEEST_XYZ File Name

(TEEST_XYZ File Name.*)

or formula

REGEX_Replace([Field 1], ".*(TEEST_XYZ File Name.*)", "$1")

Workflow:

Hope this helps 🙂

[MarqueeCrew · Accepted solution]

@SylviaK ,

Would something simple like:

REGEX_Replace([Field 1], "(.*:)(\u+.*)", '$2')

work for you?

Cheers,

Mark

[SylviaK]

Many thanks. Always looks so simple with hindsight 🙂