Line Breaks in Extracted Field

Questions and answers about anything related to Helium Scraper
Post Reply
murthyvs
Posts: 1
Joined: Wed Dec 07, 2011 5:04 am

Line Breaks in Extracted Field

Post by murthyvs » Wed Dec 07, 2011 5:14 am

Hi all,

I have just started using this tool and my scrape works fine. I see the data in the columns and in intended format but when I try to export to Access/CSV only a part of the field is exported. I have manually copy-pasted one cell into excel and I found that there are line breaks.

For ex: the cell looks like: Pampers Sensitive Baby Wipes384ct. Refill in Helium Scraper but when export the table only Pampers Sensitive is exported.

The following is the copy-paste of the description directly from Helium Scraper:

Pampers Sensitive
Baby Wipes
384ct. Refill



Is there a way to go around this problem? Thanks!

webmaster
Site Admin
Posts: 501
Joined: Mon Dec 06, 2010 8:39 am
Contact:

Re: Line Breaks in Extracted Field

Post by webmaster » Wed Dec 07, 2011 4:08 pm

Hi,

The other lines are probably just hidden below the first one. Try coping the cell with missing text from spreadsheet editor and pasting it into Notepad to see if you get the whole text.

If you still want to extract it as a single line you can use the SingleLineInnerText property instead of InnerText.
Juan Soldi
The Helium Scraper Team

Post Reply