Trim 1st 2 digits in data set?

Question

I have a column of data where I need to remove the 1st 2 digits & keep the rest. The whole string contains both letters and numbers. For example, in my column I have 07M123456789 & 780001234RB, etc... and I need to return M123456789 & 0001234RB.

I've tried trim, trimright, & trimleft but these are not working because the length of my data varies. Any suggestions or help would be greatly

MarqueeCrew · Accepted Answer

From my iPhone, please try:

Substring([field],2,)

Cheers,

Mark

Kenda · Accepted Answer

Hi @kvoelker

I bet you were so close when you were using those formulas. Here is what I would suggest:

right([Field1],Length([Field1])-2)

This says keep the right portion of your string with a length of your original string minus two characters.

Hope this helps!