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
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.