A certain string in cells of a column should be preserved

[USCHUKN1ME]

Hello,

I would like to enter the following text in a column, for example

“Universal Praez. Machine shoe
UMS6-KDSA (pat.)
*with screw compensation *
without vibration isolation,
support surface x total height
L x W x H: 110 x 110 x 65 mm.
F max = 60.000 N
*F max = Fvsp + Fg *
Adjustment range +5/-4 mm
Note: text text!”

keep only the string “Adjustment range +5/-4 mm”, everything else should be removed. The two numbers “5” and “4” can vary, but remain numbers without decimal places.

I have already tried with the String Replacer node and StringManipulation.

regexReplace($column with range$, “.(range \+ \d+ / - \d+ mm).|.*”, “$1”)

But all without much success.

What is wrong and what can i do to solve it.

Greetings

[USCHUKN1ME]

I found a solution with Chat GPT

regexReplace($Spalte mit Verstellbereich$, “(?s).?(Verstellbereich[^\n])|.*”, “$1”)

Thx anyway

[ScottF]

Thanks for posting your solution! It’s nice that ChatGPT can help solve some of these more tedious syntax problems.

[Daniel_Weikert]

And obviously it also translated Adjustment range → “Verstellbereich”
br