cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ogureisuo Helper III
Helper III

Determine if there's a character in the field

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.

 

TelephoneWith Characters
32472643697026600No
32031653599444No
32352691563148No
32473521808PROYes
32473335277INSYes
324123431702577No
3245674522INSYes
2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User I
Super User I

Re: Determine if there's a character in the field

Hi @ogureisuo 

 

Try this as a calcualted column in the table:

 

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

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
pbeye Resolver II
Resolver II

Re: Determine if there's a character in the field

Hi @ogureisuo ,

 

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")

View solution in original post

3 REPLIES 3
Super User I
Super User I

Re: Determine if there's a character in the field

Hi @ogureisuo 

 

Try this as a calcualted column in the table:

 

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

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
pbeye Resolver II
Resolver II

Re: Determine if there's a character in the field

Hi @ogureisuo ,

 

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")

View solution in original post

Super User I
Super User I

Re: Determine if there's a character in the field

This is cleaner than my suggested approach!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors