Skip to main content
Question

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


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

ebygomm
Influencer
Forum|alt.badge.img+39
  • Influencer
  • May 24, 2023

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


  • Author
  • May 24, 2023
ebygomm wrote:

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​;)


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings