Hi guys,
I want to filter for customers, whose address contains any digit.
I tried the standard SQL approach: where street like '%[0-9]%' but it doesnt work.
contains(street, '%[0-9]%', fuzzy(1.0)) doesnt work either.
Any ideas?
Thanks!
Hi guys,
I want to filter for customers, whose address contains any digit.
I tried the standard SQL approach: where street like '%[0-9]%' but it doesnt work.
contains(street, '%[0-9]%', fuzzy(1.0)) doesnt work either.
Any ideas?
Thanks!
Thanks for sharing, very useful.
I am getting an error message:
search table error: [2018] Option 'similarCalculationMode' value 'substringsearch' only allowed for string types: column ....
Its weird because I only get it for one column, which act...
Hello,we also had the problem, that we could not call a procedure anymore which had been working fine until that point. Error message was 430 (invalidated procedure). We then dropped the procedure and tried to re-create it with the same query, but it...
Hi guys,I am creating csv files, but some of the columns in the source tables contain line breaks, which causes issues in the final file. Is there a way to escape those line breaks?
Awesome, this one works. One last question: If I want to filter for streetnames which contain any digit at any position, is there some wildcard character I could use left and right of the [0-9]?Thanks!
