UiUser
July 16, 2019, 1:52pm
1
I need help using regex to find the numbers in this email body that are at the end of each line:
Please respond back with the hours you worked today:
WAM: Hours
WAM 1: 1323454.3254324.54, (General project): 0
WAM 2: 1323454.3254324.54, (General Training): 0
WAM 3: 1323454.3254324.54, (Project 3): 0
WAM 4: 1323454.3254324.54, (Project 4): 0
1 Like
UiUser:
WAM 1: 1323454.3254324.54, (General project): 0
WAM 2: 1323454.3254324.54, (General Training): 0
WAM 3: 1323454.3254324.54, (Project 3): 0
WAM 4: 1323454.3254324.54, (Project 4): 0
Hi @UiUser
kindly use this expression in the Matches activity
“[\d-]+$”
and it worked
Cheers @UiUser
UiUser
July 16, 2019, 2:46pm
3
@Palaniyappan
Thanks for getting the right Regex, just new to the activity so where would i put that rule in? and also how would i save those matches to different variables?
Do I use the configure regex button?
1 Like
UiUser:
WAM: Hours
WAM 1: 1323454.3254324.54, (General project): 0
WAM 2: 1323454.3254324.54, (General Training): 0
WAM 3: 1323454.3254324.54, (Project 3): 0
WAM 4: 1323454.3254324.54, (Project 4): 0
here you go
hope its resolvedd
regex.zip (10.9 KB)
kindly revert back for any queries or clarification
Cheers @UiUser
1 Like
any issues still to be discussed
Cheers @UiUser
UiUser
July 16, 2019, 4:57pm
7
I am having trouble when trying to get it to return all of the different numbers? the only one that is able to be returned is the first one?
1 Like
Kindly enable these properties in the Matches activity and try once
it worked for me
Cheers @UiUser