Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Replace value containing alphabets to blank values

Hi,

 

How can I replace all the rows in a column containing a combination of alphabets and numbers with Blank values?

 

Goal is to -

old        new

111  -    111

222  -     222

333   -   333

a44  - blank

555 - 555

r777 - blank

 

Then convert the column to an integer column

 

I want to add a new column to an existing table in the power query

 

Background

"Old" column is a text column

 

Thank you

  • Hi,

    you can:

    - duplicate column

    - change type to whole number

    - then in transform replace errors to null

     

    If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !

1 Reply

  • Hi,

    you can:

    - duplicate column

    - change type to whole number

    - then in transform replace errors to null

     

    If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !