Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

first letter in a field

khap
7 - Meteor

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 

 

 

2 REPLIES 2
jdunkerley79
ACE Emeritus
ACE Emeritus
IIF(REGEX_Match([Field1],"^[A-Za-z].*"),NULL(),[Field1])

should do what you want

khap
7 - Meteor

Thank you very much. 

Labels
Top Solution Authors