CODEWITHSUNDEEP
alteryx
Mkh
Mkh

Reputation: 1

regular expression help for parsing in alteryx

I have a string (without doble qoutes) "2022-12-15 21:23:22 - a123456 (Remarks) 2022-12-15 22:12:22 - a123456 (Remarks) User acknowledgement time"

There are 2 date/time stamps in this string in need the date/time stamp appearing before User acknowledgement time. I am using regex (\.*\d{4}-\d{2}-\d{2}\s\d{2}:\d{2}:\d{2}.*User acknowledgement time) my regex is capturing very first time stamp showing up in string but I need date/time stamp right before User acknowledgement time. Please help.

(\.*\d{4}-\d{2}-\d{2}\s\d{2}:\d{2}:\d{2}.*User acknowledgement time)

I am expecting result as 2022-12-15 22:12:22 - a123456 (Remarks) User acknowledgement time

but I am getting result 2022-12-15 21:23:22 - a123456 (Remarks) User acknowledgement time

Upvotes: 0

Views: 55

Answers (1)

Gary_W
Gary_W

Reputation: 10360

I think your group just needs to move. Group 1 is what you are after:

.*(\d{4}-\d{2}-\d{2}\s\d{2}:\d{2}:\d{2}).*User acknowledgement time

regex101

Upvotes: 0

Related Questions