Forum Discussion
SunnySchindler
Helper I
Helper IHow to get data from inaccurate OCR (inconsistent line feed and number mistaken as alphabet)?
For scanned text from statement of credit card transactions, how to use BI to get data without pre-processing. Scanner output (text file) has following attibutes: partially accurate OCR same line...
Hi SunnySchindler ,
In Power Query, you can use split column feature to extract your value.
Extract Parts of a Text Value in Power BI using a Delimiter: Power Query Transformation - RADACAD
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.