Forum Discussion

chavanr's avatar
chavanr
Icon for Resolver I rankResolver I
5 years ago
Solved

Convert a text column to number

Hi there,   Can someone help with converting string to value. string type is something like "AD1700000000000BC0081460"   I need it to convert it to number in order to get the count of each row. ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    chavanr 

    try to add a custom column in PQ

    =Text.Select([Column1],{"0".."9"})

chavanr's avatar
chavanr
Icon for Resolver I rankResolver I
5 years ago

Thanks It works well !!

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

you are welcome