Skip to main content
2 of 2
added 12 characters in body
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("Nutzung", regexp_match("Nutzung", '\\d') - 1)

enter image description here

Babel
  • 74.9k
  • 15
  • 87
  • 227