# LEFT Formula

**URL:** <https://community.glideapps.com/t/left-formula/68500>\
**Category:** Ask for Help\
**Created:** [December 8, 2023, 9:55am UTC](https://community.glideapps.com/t/left-formula/68500 "2023-12-08T09:55:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Si\_Gal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/si_gal/32/79433_2.png) [@Si\_Gal](https://community.glideapps.com/u/Si_Gal)\
**Post date:** [December 8, 2023, 9:55am UTC](https://community.glideapps.com/t/left-formula/68500/1 "2023-12-08T09:55:35Z")

</div>

Hi, I am trying to write a formula like this  
=LEFT(A1, FIND(“.”, A1, FIND(“.”, A1) + 1) + FIND(“/”, A1) - 1)

Or

=JOIN(“/”, ARRAYFORMULA(SPLIT(A1, “/”)[1], SPLIT(A1, “/”)[2]))

Are these the only function supported in Glide Tables: LOG, ABS, MIN, MAX, FLOOR, CEILING, ROUND, TRUNC, ASIN, COS, ACOS, ATAN, MOD, SECOND, MINUTE, HOUR, DAY, WEEKDAY, MONTH, YEAR

I am trying to take this URL [Fabric Sofas | Bespoke Sofas - Made to Measure | Sofa.com](https://www.sofa.com/gb/sofas) and remove everying after the “/” the comes after the second “.” to leave the homepage URL of any website [https://www.sofa.com](https://www.sofa.com)

Thanks

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 8, 2023, 10:32am UTC](https://community.glideapps.com/t/left-formula/68500/2 "2023-12-08T10:32:08Z")

</div>

Use the Get Part of URL column to extract the host. That will give you `www.sofa.com`.  
You can then use a template to prepend the `https://` if necessary.

You could also use the Extract Matching Text column with an appropriate regular expression, but personally I wouldn’t bother with that in this case.

> [@Si\_Gal](#):
>
> Are these the only function supported in Glide Tables: LOG, ABS, MIN, MAX, FLOOR, CEILING, ROUND, TRUNC, ASIN, COS, ACOS, ATAN, MOD, SECOND, MINUTE, HOUR, DAY, WEEKDAY, MONTH, YEAR

That’s what’s supported in the Math column, but there are a whole plethora of other computed column types that allow you to do almost anything that you can dream up 🙂

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [December 15, 2023, 10:32am UTC](https://community.glideapps.com/t/left-formula/68500/3 "2023-12-15T10:32:58Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.