Determine if there's a character in the field

[Anonymous]

Hello everyone,

Is there a function where it can check if a certain field contains characters?

I checked the CONTAINSSTRING but I don't want to define the text.

Telephone	With Characters
32472643697026600	No
32031653599444	No
32352691563148	No
32473521808PRO	Yes
32473335277INS	Yes
324123431702577	No
3245674522INS	Yes

[MartynRamsden · Accepted solution]

Hi @Anonymous 

Try this as a calcualted column in the table:

With Characters =
IF (
    ISERROR ( VALUE ( 'Table'[Telephone] ) ),
    "Yes",
    "No"
)

[pbeye · Accepted solution]

Hi @Anonymous ,

Would checking if the string is a number work instead? I'm thinking it might work if you do the ISNUMBER formula, so something like this:

With Characters =IF(ISNUMBER(Telephone), "No", "Yes")

[MartynRamsden]

This is cleaner than my suggested approach!

[MartynRamsden · Accepted solution]

Hi @Anonymous 

Try this as a calcualted column in the table:

With Characters =
IF (
    ISERROR ( VALUE ( 'Table'[Telephone] ) ),
    "Yes",
    "No"
)