You need to sign in to do that
Don't have an account?
Joaquin Iudica
how to compare values in soql query when field has a different format
I don't know if there is a way to solve this, I couldn't find it.
I am importing a CSV file where I am to create an sObject for each line. The thing is, I have to do a query using a value present in the csv file, for example let's say
So, the query could be something like
BUT, the problem is , the values on that Custom_Field__c could be like this
or like this
.
How can I query against that field? Is it possible to only compare the numbers and ignore the other characters? (without having to create another string that represents the original value with the other format)
I am importing a CSV file where I am to create an sObject for each line. The thing is, I have to do a query using a value present in the csv file, for example let's say
value = 2554543
So, the query could be something like
[SELECT Id FROM sObject WHERE Custom_Field__c = value]
BUT, the problem is , the values on that Custom_Field__c could be like this
2554543
or like this
2-5545-43
.
How can I query against that field? Is it possible to only compare the numbers and ignore the other characters? (without having to create another string that represents the original value with the other format)