The “Contains” search module in google sheets has to find an exact match? When the system searches for 4415 and I have a cell with 44-15 shouldn’t it return that row? right now it is not returning anything thanx
Hello @Mitch_Silverman,
In this case, yea, it needs to be an exact match. Not sure any type of fuzzy searches are supported here.
Out of curiosity, does Google Sheets find “44-15” when you search for “4415”?
no it does not. I think ill try to just split the string and use “or” filter
May I ask what is your use case here? How do you end up searching “4415” when only “44-15” exists?
If possible, add another field to the Google sheet that uses a Replace() function to filter out hyphens from the address so you can search on that field.
If that’s not possible, there is possibly a way to do it in Make…
- Use a Google Sheets Search Rows module and Filter on the address field where it “Exists”
- The result will be a bunch of bundles each containing a row of data where there was an address
- Use an Array Aggregator to save off these results into an array
- Iterate on the Array and use JSON Aggregator to aggregate into a custom JSON where you store all the contents of the row including row number. In a copy of the address field, you’ll need to use replace() function to replace instances of hyphen with {{emptystring}} or {{null}} so you’ll have two versions of the address, one with hyphens and one without.
- Parse the JSON which will create bundles again, similar to the Google Sheets Search Rows, only this time there will be an extra Address field without hyphens in them that you can search on.
Hey Donald, thanks again for taking the time.
my use case is very simple – I collect the address and the unit (Apartment) Of a tenant
From a form, and I feed it into the search module.
Now, with regard to the address, usually people write the address one digit after the next, such as 123 But sometimes they may type it with a dash.
My main issue actually is with regard to the unit, As people tend to describe, which apartment they live in anywhere from one to four words For example “I live in apartment 3N “ In this situation, I need to just extract the apartment
I was thinking that maybe I just need to split the whole string by the presence of a space and then run a “or “ Condition in the filter module.
In summary: Variable one = 12-35 elm street Need to convert that to 1235
Variable two = unit 3L
Need to Extract just “3L”
Hello,
I’ve already pointed this out to you in the discord server a week ago.
To resolve this, you can either add the hyphen in your filter, or
Try using the Google Sheets “Search Rows (Advanced)” module:
Returns results matching the given criteria. This module doesn’t return a row number."
This allows you to use a “Query Language Reference” regular expression pattern in your query.
For more information, see https://www.make.com/en/integrations/google-sheets, and https://www.make.com/en/help/app/google-sheets in the help centre.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.