Remove string after certain character

Hello I would like to know the formula i can use in the set a variable module to remove characters after a certain character

e.g. character to remove is /
input: google.com/1234abcd output: google.com

Please can someone help me with this?

1 Like

Hello,

You could probably use the split() and first() functions, like this:
image

4 Likes

Hi @hb

The option provided by @Donald_Mitchell looks great. You can also cut string based on count of characters using below formula:

Regards,
Msquare Automation - Gold Partner of Make

Free Consultation | Live Implementation

Visit us here | Youtube Channel

Thank you both, it will could be a different url to google.com so the first formula where I don’t specify the string length is perfect for my use case!

2 Likes