Split string into columns


#1

Hello :slight_smile:

I have a list of urls in a column.

domain.com/cars
domain.com/cars#bestdeal
domain.com/cars#top10

I want to split the url at the β€œ#” and create 1 more column. So the new table would look something like this:

domain.com/cars
domain.com/cars bestdeal
domain.com/cars top10

Is this possible in airtable?

Excell version:

Thanks!


#2

You can use some functions to get those portions, doing some math:

  • LEN to know the length of the string
  • FIND to know in with character the # is (a number)
  • SUBSTITUTE to β€œdelete” the extra parts (substitute with β€˜β€™)

There are some threads in the forum to inspire you: https://community.airtable.com/search?q=split%20string