Forum Discussion

tempranello's avatar
tempranello
Advocate I
10 years ago
Solved

Test for a number

Hi there   I must be losing it...this seems such a simple thing to do, but I'm blowed if I can sort this out myself.   I've a column of type text in a query that may or may not contain text or a ...
  • chrisu's avatar
    chrisu
    10 years ago

    I think you want to use Value.Is.  To check if a value is text, it would look something like this:

     

    Value.Is([Column],type text)

     

    To check for a number, it would be:

     

    Value.Is([Column], Int64.Type)

     

    Value.Is returns a boolean true/false, so you can wrap it in an IF.  

  • Anonymous's avatar
    Anonymous
    8 years ago

    Worked for me. Thank you!

     

    if Value.Is(AlphaNumeric, type text) then AlphaNumeric else Number.ToText(AlphaNumeric))
chrisu's avatar
chrisu
Responsive Resident
10 years ago

I think you want to use Value.Is.  To check if a value is text, it would look something like this:

 

Value.Is([Column],type text)

 

To check for a number, it would be:

 

Value.Is([Column], Int64.Type)

 

Value.Is returns a boolean true/false, so you can wrap it in an IF.  

  • wonga's avatar
    wonga
    Continued Contributor
    10 years ago

    Along with chrisu suggestion, you could also do a try, otherwise statement:

     

    try Number.FromText([TEST_COL]) otherwise "FALSE"

     

    This will either return a number converted from text or the value of FALSE is TEST_COL is not a number at that particular row.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Worked for me. Thank you!

     

    if Value.Is(AlphaNumeric, type text) then AlphaNumeric else Number.ToText(AlphaNumeric))
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Worked for me. Thank you!

     

    if Value.Is(AlphaNumeric, type text) then AlphaNumeric else Number.ToText(AlphaNumeric))