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 example:
AM171081108RP must become 171081105RP
AMS28105832RCP must become by 28105832RCP
If the new values are placed in a new column, this is oke for me.
I have no idea how to do this, so your suggestions are highly appreciated!
John
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
2 Replies
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