Replacing specific strings

[NotQuiteClueless]

Apologies to all if this is a complete beginners question.

I've got a data source where some of the entries are bogus. Instead of the expected data which is the form of ABC1234, some are eight digit numbers. None of the genuine data are more than 7 characters in length and I've tried to construct a filter based on that but I can't seem to get the syntax right.

Any suggestions gratefully received

[KaneG · Accepted solution]

Hey @NotQuiteClueless,

Length([FieldName])<8 should work

The following would also would: Regex_Match([FieldName],'[A-Z]{3}[\d]{4}')

[NotQuiteClueless]

Thank you so much! As with all such things the solution is blindingly obvious once you know it.