Extracting Text or Date with condition, parsing

[umutcankurt]

Hi; I want to extract the date information from the text samples below to a different column. But " ( " I want to clear the previous numbers. But there is no standard in the number of characters of numbers, only " ( " can be used as a reference dividing point.

Can you send me a sample workflow.
28(2023-10-02)
35(2023-10-09)
10(2023-09-14)
30(2023-10-04)
9(2023-09-13)
1457(2027-08-31)

after editing

(2023-10-02)
(2023-10-09)
(2023-09-14)
(2023-10-04)
(2023-09-13)
(2027-08-31)

[ipazin]

Hello @umutcankurt,

you can use String Manipulation with following expression:
substr( $yourColumnName$, indexOf( $yourColumnName$, "(" ))

or regular expressions in Regex Split/Regex Extractor node:
.*(\(.*)

Br,
Ivan

[umutcankurt]

@ipazin

substr( $yourColumnName$, indexOf( $yourColumnName$, “(” ))

Hi; @ipazin
Thank you very much for the answer, exactly the solution I was looking for.

[umutcankurt]

@ipazin

.((.)

Hi; @ipazin
How should I write in the opposite scenario?
Example : Germany-Berlin: Adult and other education services Type of

reference “-”
I just want to get Country names.

Edit: Germany

[ipazin]

Hello @umutcankurt,

start from beginning and stop when you find “-”:
substr( $yourColumnName$, 0, indexOf($yourColumnName$, "-" ))

Br,
Ivan