Question

question relate to how to split a cell with text and numbers

  • 24 May 2023
  • 2 replies
  • 2 views

Hello everyone, 

I am trying to split a text with the attribute splitter. The text is formatted this way : text1 ( number1), text2 ( number2), text 3 (number3)… I want to extract only the value of the numbers to put it in another attribute. 

Can you help?


2 replies

Userlevel 1
Badge +21

I would use a stringsearcher to extract the numbers

If the numbers are always within brackets you could do

(?<=\()\d+

This will match all numbers that occur after an opening bracket

I would use a stringsearcher to extract the numbers

If the numbers are always within brackets you could do

(?<=\()\d+

This will match all numbers that occur after an opening bracket

Thanks a lot it working​;)

Reply