Split string into columns

[Mateias_Andrei]

Hello :slightly_smiling_face:

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:

support.office.com

Merge or split cells in a table

You can merge two or more cells in the same row or column of a table. You can merge several cells to create a heading that spans several columns.

Thanks!

[Elias_Gomez_Sai]

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