strip out after condition

KNIME Analytics Platform
1

Hi,

I have a column with fields like:
0.13:37:55.659860932
124.13:20:32.49885348
45.15:31:43.430995899

How can I strip out directly only what comes after the second dot “.” to get to a result like
0.13:37:55
124.13:20:32
45.15:31:43

2

From the top of my head (therefore untested), a String Replacer node with a regular expression that looks like this:

(.*?:.*?:.*?)\..*

Replaced by

$1
1 Like
3

You can also do it without regex only with the logic of the amazing string manipulation node.
truncate_string_after_points.knwf (10.7 KB)

4

Hi,

A “String Manipulation” would do that by applying this expression:
regexReplace($targetColumn$, "\\.[0-9]*$", "")

Best,
Armin