Hi,
I 'd like get records for a field that starts with a letter, A to Z. For example, if a value in a field starts with a letter, A through Z, update it to null, else keep whatever a value in that field.
can anyone help with a formula?
Thanks
Solved! Go to Solution.
IIF(REGEX_Match([Field1],"^[A-Za-z].*"),NULL(),[Field1])
should do what you want
Thank you very much.