Okay, well dump your variables and see what the content actually is to validate it.
Are you writing the full Date/Time to Excel and Excel is formatting the display to be Date only?
Swapping your PDF out for a text file with the same content…
" 30-Jul-2018 16:26 PM"
Trim(splitdata(1).ToString) is not valid. changing it to an index of
0, will get you a step further, but the format in
does not match the content
30-Jul-2018 16:26 PM which I pointed out in an earlier post.
Based on the test.xaml file you provided, You NEED to change either 1) Regex, 2) Date format, that you are expected along with the few index changes based on your current Regex.
Swapped PDF for TXT, Inserted Log Message activities
Fixed the out of bounds due to the original Regex expected capture
Updated date format to match the captured date/time text