Skip to main content
added 12 characters in body
Source Link
Taras
  • 34k
  • 4
  • 73
  • 148

Use regular expressions to find the first digit, then return the input string from the first character until the character before the first digit using this expression:

left (INPUT,regexp_match( INPUT,'\\d')-1)

left("Nutzung", regexp_match("Nutzung", '\\d') - 1)

enter image description here

Use regular expressions to find the first digit, then return the input string from the first character until the character before the first digit using this expression:

left (INPUT,regexp_match( INPUT,'\\d')-1)

enter image description here

Use regular expressions to find the first digit, then return the input string from the first character until the character before the first digit using this expression:

left("Nutzung", regexp_match("Nutzung", '\\d') - 1)

enter image description here

Source Link
Babel
  • 74.9k
  • 15
  • 87
  • 227

Use regular expressions to find the first digit, then return the input string from the first character until the character before the first digit using this expression:

left (INPUT,regexp_match( INPUT,'\\d')-1)

enter image description here