Using RegEx to clean data, there are two lines scraped, how can I get only the first line?

Follow

Emma

• September 04, 2020 02:59

While trying to scrape the following page, https://www.graff-designs.com/en/catalog/bathroom/dett/4994/mod--lavatory-faucet/

I am not able to get the desired selection for scraping. As can be seen in the attached image, I am trying to scrape the name only of the item, but It is selecting the code too. This problem is being faced on every page of Graff website. I am not a coder. Can you please help me to extract only the desired name ?

0

• 

  Emma

  • September 04, 2020 03:07

  Hi there,

  Thank you for reaching out.

  When we are selecting this area, we can see the XPath of the data field is this:

  

  

   

  0

  Comment actions Permalink
• 

  Emma

  • September 04, 2020 03:07

  

  But it's getting both the title and code, so we need to clean the data with RegEx(Octoparse Regular Expression Tool) 
  
  First, let's click on "Refine extracted data".

  

  0

  Comment actions Permalink
• 

  Emma

  • September 04, 2020 03:09

  Then click on "Add step"

  

  Choose to match with this regular expression: \A.*​     which means getting the first line of data only:

  

  

   

  And here's the final result:

  

  0

  Comment actions Permalink
• 

  vatsee

  • December 09, 2020 17:34

  Similarly, what can be the regex to get only the last line of data?

  In this case, if we want only the code.

  0

  Comment actions Permalink

Please sign in to leave a comment.