Regex and datatable

Help Studio
, ,
1

hi all,

i am trying to loop through a log file using regex based on criteria from a data table and write the results of the regex out back to the data table

so i want to report on what is in DT_Main ID(1,3,5 )and the results of the regex should be output to Details

i have problem in that when i add a variable to the regex pattern the results are not what i want to see. when i do a write line on the regex pattern no variable is present. Also the output includes data i do not want to see

the work flow is attached and also a log file as a source

any help greatly appreciated

Logfile.txt (667 Bytes)
Main.xaml (14.7 KB)

2

Hi @adrian_sullivan ,

  1. Use the activities inside the loop and do not provide default value to the variable.
  2. Also remove the text written inside the regex patten and only use property panel to add the Regex pattern
    image
  3. See the attached code for quick reference for the below result
    image
    image547×517 8.67 KB

Main.xaml (15.0 KB)

3

hi @mayur.pawanikar

that worked perfectly for me. i spent a week trying to fix and so very much appreciared

adrian