Forum Discussion

Las's avatar
Las
Frequent Visitor
4 years ago

Converting Text Column having Text and Scientific Notation

Hi Experts, I'm having a text columns with numbers, text and scientific notation, example as follows   202-203 2320042 AH3021 F21A-001 1.00E+11   In a situation like this how to handle the d...
Need Help
Las's avatar
Las
Frequent Visitor
4 years ago

Thank for all your responses.

 

I might be looking for power query to convert the exponential values and rest of the other values in the column to text. The issue is after converting it will error out all the other values which is not having scientific notation. 

 

When having multiple values ( mix of text, SN and general types ) how to handle this situation?

 

Thank you

Regards,

Las

 

 

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional
    4 years ago

    Please post the output expected for the input given below

    202-203

    2320042

    AH3021

    F21A-001

    1.00E+11

    • Las's avatar
      Las
      Frequent Visitor
      4 years ago

      Hi Vijay,

       

      Require everything in text format ( Yes, even numbers converted to text ). Currently we do it in Excel and upload it to PBI, this process is cumbersome due to large amount of data. 

       

      Thank you.

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional
    4 years ago

    Power Query equivalent is Text.From like below

    = Text.From([Column1])