Removing Letters from String of Letters and Numbers

Hello,

I have 60,000+ rows of values in a table.

I have a serial number row that has 60,000 serial numbers.

Example: "XYZ123456789123".

All serial numbers start with XYZ. How do I create a column next to it with only the last 12 numbers in it for all 60,000 rows?

Thanks!

Answer 1

[Cris LaPierre]

You could use extractAfter

s=["XYZ123456789123";"XYZ123456789126"]

s = 2×1 string array
    "XYZ123456789123"
    "XYZ123456789126"

% use postion
n1=extractAfter(s,3)

n1 = 2×1 string array
    "123456789123"
    "123456789126"

% Use pattern
n2=extractAfter(s,"XYZ")

n2 = 2×1 string array
    "123456789123"
    "123456789126"

[Sarah]

got it to work, thanks!