Alphanumeric Values in column

[Anish76]

How can I limit the column to only alphanumeric values?

[Anonymous]

Hi @Anish76 ,

What does limit mean, is it in a bunch of numbers mixed with English strings, only English letters remain?

If possible, please provide us with some sample data and expected results. And take care to protect your privacy.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anish76]

Thank you for your response.
I want to search only alphanumeric values in the column, which contains numeric, alpha, and alphanumeric values.

[Anonymous · Accepted solution]

Hi @Anish76 ,

If you can use Power Query, it will be easy. The idea is to add column to mark whether it contains characters other than numbers and letters.

Here's my sample data.

if [Value] = Text.Select ( [Value],{ "a".."z", "A".."Z", "0".."9" }) then 1 else 0

Then you can add this filter to write formulas in Power BI Desktop. For example,

Count rows which contains numeric, alpha, and alphanumeric values = COUNTROWS(FILTER('Table',[Contain numbers and letters]=1))

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anish76]

Hi Stephan,

The query only checks special characters and returns the value false. I have cells in my table that are only numeric, alphabetic, and alphanumeric with no special characters, and I want to have only alphanumeric values.

[Anish76]

Thank you Stephen, It worked.

[amitchandak]

@Anish76 , refer if old solutions can help

https://community.powerbi.com/t5/Desktop/Checking-a-column-for-alpha-and-alpha-numeric-characters/m-...

https://community.powerbi.com/t5/Power-Query/Data-type-issue-Alpha-numeric-column-is-loaded-data-typ...