Forum Discussion
Split string from left, based on letters
Hi, I want to split values in a colum. If the string starts with a letter of letters, I want to remove them. But I only want to remove the letters on the left side of the string. For exampl...
You should be able to use the split column function in the query editor:
If you happen to have values that goes non-digit to digit multiple times you will need to piece those columns back together, like this:
Original column
Split
Custom column
result
Br,
Johannes
You should be able to use the split column function in the query editor:
If you happen to have values that goes non-digit to digit multiple times you will need to piece those columns back together, like this:
Original column
Split
Custom column
result
Br,
Johannes
Hi Johannes,
This works for me, thanks!
John