Add Zero if Field Contents are Only One Character
I do an import from a CSV each day and currently there is a field that will have, for example, 1, 10, 11 as field contents for the category number. In order for my scripts to work I would like to have any category that is only one character to automatically add a 0 at the beginning. I was hoping to incorporate this into my script step or perhaps it is validation option (I only see Maximum length). Any help is appreciated.
FMPro 11 Advanced