first letter in a field

[khap]

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 

[jdunkerley79 · Accepted solution]

IIF(REGEX_Match([Field1],"^[A-Za-z].*"),NULL(),[Field1])

should do what you want

[khap]

Thank you very much.