[SOLVED] AS_NUMBER to Integer

PointsWell

If you take a large number in a text field and then use AS_NUMBER to convert it to a number, the number that is output is floating point not an integer. Is there a way to convert that floating point number to an integer? Or better convert the text to an integer from the outset?

What is actually being attempted here is the stripping of any leading zeros from a telephone number in order to parse it ready for a REST API but there may not always be a leading zero

Jaymer

a regular expression can also search for 0 or more 0's only at the beginning of a line.

PointsWell

Jaymer wrote
a regular expression can also search for 0 or more 0's only at the beginning of a line.

Doh Good ol' uncle Regex to the rescue again.

I used the following:

REPLACE_PATTERN(PhoneRecords.Number, '\A[0]', '')