Hi … I have a column of text that is the output from the Document Data Extractor node and have space characters before “:” and parenthesis characters that I need to remove before I can have a reasonable chance of effectively using the “Regex Extractor” node to get any usable data.
I have tried String Manipulation a number of ways and get nowhere. Below is an example of the text.
From 2020/09/30 07 :28:26 to 2020/09/30 ( Summary : 0 km averaging - km/h ) 07 :28:52 Parked
From 2020/09/29 14:22:52 to 2020/09/29 15 :27 :19
The space character in the time is inconsistent, sometimes it is there sometimes it is not.
I would appreciate any suggestions.