Solved Remove text Prefix from a number

[Number11]

Hi

So i need to remove the prefixed number from "ACC/0014471211" to "0014471211"

whats the best way to do this with a query?

 

[ebs17]

Mid(XExpression, 5)
'------
RegExReplace(XExpression, ".*(\d+)", "$1")

 

[XPS35]

That depends on whether the prefix is always the same number of positions long. And if that is not the case, then it always ends with a /?

 

[Number11]

That depends on whether the prefix is always the same number of positions long. And if that is not the case, then it always ends with a /?

Its always the same and position

 

[XPS35]

Eberhards solution (MID) will do.

 

[Number11]

Mid(XExpression, 5)
'------
RegExReplace(XExpression, ".*(\d+)", "$1")

Thanks how would i use this in the query?

 

[Number11]

ok thanks got it working now using

AccountRef: Mid([Account_No],5)

 

[Gasman]

Its always the same and position

And if it wasn't, then look for the / and start from the next character position.

 

[gemma-the-husky]

Hi

So i need to remove the prefixed number from "ACC/0014471211" to "0014471211"

whats the best way to do this with a query?

I take it you realise that your "number" is a text string, not a number. You may have to be careful that "0014471211" doesn't get treated as just 14471211 in some cases.

Also that the value doesn't exceed the max value of a longint (approx 2 billion) which might produce a different type of error.