Im importing some data and a url comes in with additional chars that I need to remove
Ex:
Need to convert that to just www.mywebsite.com
Any ideas how to accomplish this?
Is it in Google Sheets?
If so hereās an arrayformula.
={"Shortener";ARRAYFORMULA(IF(A2:A<>"",LEFT(A2:A,FIND(".com/",A2:A)+3),""))}
@ThinhDinh I was thinking how to do everything in Glide but I just donāt seem to find a way. If only we had a kind of āsingle value columnā that does not act on the rows, but on the index of an array, they could solve many cases similar to this.
We can definitely do more with some text manipulation ability.
This looks to do what I want, thanks! Guessing there isnt a way to sort of import data from a Google sheet into a Glide Table, right?
Currently using a zap to import new rss feed posts into a google sheet. No way to import into a Glide Table, correct?
Yes, correct, for now.
Maybe I can do like a Google Sheet with āPending Postsā that users can review and when they hit a āPublishā button, it adds a row to my Glide Tableā¦
Hypothetically, canāt you use a Split Text column, using the ā/ā, and then just grab the first value from the cell of the two items?
You donāt have a way to grab that first value, I believe.
If only there was a kind of fuzzy search with template columns or relationsā¦ like in this case, each of the first strings will start with āwwwā, and you want to ignore everything after the ā/ā.
I think what I will do is this:
Zapier RSS to Google Sheets (New posts)
Google Sheets Array as Thinh wrote above to find the actual website
Link to Screen ā Google Sheet (New Posts)
Button ā Add Row to Glide Sheet + Delete Row
That particular formula only works if the TLD is ā.comā, hence why Iām trying to use other methods to trim / break up the full URL into pieces, and then grab the piece I want. In the URL shortening services, I wonder if there is this ability, so rather than try to make a bit.ly/a7sg9adasdf , just trim it to the root domain.
Do you know if its possible to shorten to both .com and a .co?
What types of URL do you have? Are they all .com, .co or follow any specific patterns?
Actually I fixed the issue. I need a separate worksheet per User to import their content via IMPORTFEED so I can just customize the Array based on their website TLD.