Split string from left, based on letters

[jwi1]

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

[tex628 · Accepted solution]

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

[jwi1]

Hi Johannes,

This works for me, thanks!

John