How to search needed values by first letters using Google Sheets?

(Александр Мамонтов) #1

Hi, Flow XO)
I’m making a bot-phonebook. There is a Google table, it has columns with names and they return me the phone numbers from the corresponding row when you enter the name.
I use magic repeat * to get all phones with all matching names.

But I want to make sure that when you enter the message bot found all matches starting with the first 4 matching letters.
I think I should use javascript expressions but don’t know how.

Thanks for the help!

(Daniel Beckett) #2

Hi @Alexandr_Mamontov

Google Sheets unfortunately doesn’t have a way to find partial matches so you are right in that JavaScript would be required through the Code service.

Alternatively, you may be able to use the Text service to find matches using Regex. Sites like regexr.com can help with testing for working expressions to use in your flow.

If you’re not sure on what code or regex is required then development communities like Stack Overflow may be able to help you out. :slight_smile:

(Александр Мамонтов) #3

Thank you Daniel!
I will put it here when i’ll finde the way :slight_smile:

1 Like