Identifying the First Five Characters if All are Alpha Characters

Question

Hello,

I have a column of filenames and am looking for something (hopefully an if statement) that can identify the files where the first five characters are alpha characters.  These can be marked as "true" and those that are not with "false".  Please see the example below.

Thableaus · Accepted Answer

Hi @djodts

A good REGEX might fit your case.

Use Formula Tool. Create a field, change its type to Bool.

REGEX_Match([Field1], "^[A-Z]{5}.*$")

Cheers,

JShankman · Accepted Answer

Use a RegEx tool, where the output Method is "Match", and the Regular Expression = ^[[:alpha:]]{5}.*

JosephSerpis · Accepted Answer

Hi @djodts  there a number of ways you could do this using a regex tool using a parse or match function or within a formula tool. Provided a workflow with all three options.