Sharepoint data format issues

[Anonymous]

All, I have pulled data from a  sharepoint list into Qlikview. However, the format has changed. I am pulling a commentary field and our requirement is to have all bullet points and paragraphs as it appears in the original field. So is it possible to have it in same format in Qlikview as it is in Sharepoint?

Thanks

sam

[avinashelite]

try like this

Text(Field_Name) as Field_Name

[Anonymous]

Actually when I pulled the field, it got the html code along with the data. So applying the text function wouldnt help. I need to remove the html code but at same time maintain the format of the data.

[avinashelite]

Could share the what the data your getting and what you needed so that I could help you out

[Anonymous]

Here is my sample Sharepoint data that I want to export into QV:

ID	Comment
1	Data as of Jan 2016: Under Budget Expenses more than available amount More people hired Summary: Status is Green
2	Data as of Feb 2017: Over Budget Expenses more than available amount Less people hired Available capital more than allowed limit Summary: Status is Red

I want the Comment data to be shown in exact format(bold, underline, bullets,etc) as above in QV.

Thanks so much!