Mart_Kolyshkina - profile

Mart_Kolyshkina · Oct 12, 2022

Hey guys, Can you please suggest to me a formula that will remove a text after multiple characters ( ‘’,‘’ ‘’/‘’ ‘’ - ‘’ ‘‘and’’ ‘’&‘’ ‘’;‘’ ‘’(‘’. I already found on this Forum the formula that removes a text after one single character, LEFT( {Colum...

Mart_Kolyshkina · Oct 13, 2022

I have one more question, do you know how can I add to this formula one more formula that will make all words begin with capital letters, and other letters will be small? I used before for other columns this formula for lowercase and uppercase letter...

Mart_Kolyshkina · Oct 13, 2022

Nathaniel_Granor: REGEX_REPLACE({Job title},"([\\,\\-\\&\\;\\(\\/]|AND|and).*","") Woow, thank you very much, it works :pray:

Mart_Kolyshkina · Oct 13, 2022

@Nathaniel_Granor thank you very much for your advice, but I don’t need just to extract those characters I also need to extract the text after those characters: COO and Director - COO COO/Director - COO COO - Director - COO COO, Director - COO

User Statistics

User Activity

Formula that will remove a text after multiple characters

Re: Formula that will remove a text after multiple characters

Re: Formula that will remove a text after multiple characters

Re: Formula that will remove a text after multiple characters