Forum Discussion

PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
4 years ago

Is it possible to extract just the numeric part of text field?

I have a field that will contain a number that I need for other activities and know there will be too much push back if the users are asked to go back and modify the data.  The problem is further comp...
Formulas and functions
PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
4 years ago
There was one additional issue I didn't anticipate.  Some of the store numbers had a leading 0.  I just changed the field type to formula - text and an getting the desired results.

------------------------------
Paul Peterson
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Thx for posting the full formula. I was going to use "octothorpe" as a formula variable name but I didn't think anyone else knew that's what a # Is called. :)​

------------------------------
Mark Shnier (YQC)
[email protected]
------------------------------
  • PaulPeterson1's avatar
    PaulPeterson1
    Qrew Assistant Captain
    4 years ago
    I can't tell you what I did yesterday, but give me a bit of silly trivia and that gets stuck in my mind forever...

    ------------------------------
    Paul Peterson
    ------------------------------