Remove space characters before ":"

[TigerCole]

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

or …

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.

Thanks.

tC/.

[HansS]

@TigerCole

How about a String Manipulation node with:
replace($column1$," :" ,":" )
gr. Hans

[TigerCole]

@HansS

I managed to get the “replace” to work eventually but had to put an intermediate step in place to write the data to a CSV file and then read it back again. I don’t know why, but the exact same node “miraculously” did what it was supposed to.

Thanks for the reply… appreciated.

tC/.