Forum Discussion
String cleaning
Hi Reader,
how do we read only usable data from below by eliminating html tags and Font family names . I have used Subsititute and subsititutesting but then there are too many tags.is there any strainght function to this as tis is random ?
Thanks
Anonymous , refer if these can help
https://www.c-sharpcorner.com/article/convert-data-from-html-to-plain-text-in-power-bi/
https://docs.microsoft.com/en-us/answers/questions/527916/deleting-html-tags.html
Also, you can try to read it as HTML table from a web page using web option
Hi Anonymous ,
There are various options to parse out the data in the html tags (depending on the technical means you are familiar with) and then generate a file and connect to this data source via powerbi deskop.
refer to below blog:
How to extract data from an HTML table
Get HTML Tag Values With JavaScript
If the problem is still not resolved, please point it out. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Anonymous , refer if these can help
https://www.c-sharpcorner.com/article/convert-data-from-html-to-plain-text-in-power-bi/
https://docs.microsoft.com/en-us/answers/questions/527916/deleting-html-tags.html
Also, you can try to read it as HTML table from a web page using web option
Hi Anonymous ,
There are various options to parse out the data in the html tags (depending on the technical means you are familiar with) and then generate a file and connect to this data source via powerbi deskop.
refer to below blog:
How to extract data from an HTML table
Get HTML Tag Values With JavaScript
If the problem is still not resolved, please point it out. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.