AnsweredAssumed Answered

Add Zero if Field Contents are Only One Character

Question asked by Terri on Nov 14, 2012
Latest reply on Nov 15, 2012 by Terri

Title

Add Zero if Field Contents are Only One Character

Post

     Hi,
     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
      
     Thanks!

Outcomes