How to concat two strings for a column when I scrape

How to?
#1

Hi everyone,

screenshot-16
screenshot-16.png1104×772 45.3 KB

In the image attached I want to concat "Lancome" and "Click and Glow Highlighting Skin Fluid" and save the ProductName as "Lancome Click and Glow Highlighting Skin Fluid".
Can someone please suggest how to do this?

Thanks in advance

#2

Will have to see the URL

#3

https://www.thebay.com/lancome-click-and-glow-highlighting-skin-fluid/product/0600089212698?FOLDER<>folder_id=2534374302023684&R=3605971242403&P_name=Lanc%26%23244%3Bme&N=302023684&bmUID=mLrmt_T
is the URL

#4

You could only do this if you would choose to us the Grouped selector and then parsing the data.

But, it looks like you can use metadata to achieve the same result. Here are two ways how you can get it, pick the one you like better:

{"_id":"thebay","startUrl":["https://www.thebay.com/lancome-click-and-glow-highlighting-skin-fluid/product/0600089212698?FOLDER%3C%3Efolder_id=2534374302023684&R=3605971242403&P_name=Lanc%26%23244%3Bme&N=302023684&bmUID=mLrmt_T"],"selectors":[{"id":"product-name-keywords","type":"SelectorElementAttribute","parentSelectors":["_root"],"selector":"meta[name=\"keywords\"]","multiple":false,"extractAttribute":"content","delay":0},{"id":"product-name-meta","type":"SelectorElementAttribute","parentSelectors":["_root"],"selector":"meta[property=\"og:title\"]","multiple":false,"extractAttribute":"content","delay":0}]}