I have created a Master File against a SharePoint list and I am struggling to consume the multi-line fields that are Rich Text.

If I set the usage and actual to Alphanumeric I get the right text to pull over but it creates merged cells in Excel.

If I leave it as a TX I get one cell for the text but it includes all the stylizing mark ups.

Suggestions?

This message has been edited. Last edited by: <Kathryn Henning>,

Hi Peechy23,

While we wait for other members to reply can you review the following links from the IBI Hottrack site / Focal Point and see if any provide you with assistance.


SharePoint: Run query against GETLISTITEMS: No response
https://techsupport.informatio...om/sps/93652507.html

Reading Sharepoint Question
http://forums.informationbuild...1057331/m/3447098526

Procedure to retrieve the data from sharepoint to WebFocus.
http://forums.informationbuild...1057331/m/2917044316

Error retrieving data from SharePoint data using Web Services
http://forums.informationbuild...71057331/m/715104631


Let us know if these help or if you continue to have questions.

Kindest regards,
Tamra Colangelo
Focal Point Forum Moderator

Thank you for providing these resources. It appears that most of these are related to issues in getting the data.

My issue is that I am not getting the data in the proper format. I think it is because the field is rich text in SharePoint.

I am hoping to find a way to either strip out the Rich Text coding(i.e.