I’m doing some scraping & getting urls results that are the same, but with different query info: “?thing=randomInfo”
How can I alter scraped text or url strings to remove the query portion prior to saving it in Notion?
Hi @comfortsteve, Welcome to the Bardeen Community 
Try adding them to a Google Sheet and use a formula to alter the url strings to your liking and then send it to Notion.
Hi! I just did this tonight.
In google sheets, select the column that contains your data. Then click on ‘Data’ at the top and select ‘split text to columns’ and on the box that pops up that says ‘Separator’ choose the first character of the portion that you want to remove. In your example, you would enter “?” and the cells would split and you would have two columns: one that contains the query and one that contains everything after “?”
*Don’t forget to add a column to the right so you don’t override any data 
1 Like
This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.