How can I force format with Monarch. Meaning if I have a text field with 545623, but want 00545623, force 8 characters formatting. Is this possible? The alternative would be to bring it into Excel and do a custom formatting, but I rather do within Monarch if possible.
Thank you in advance for your help.
I think [url="http://mails.datawatch.com/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=1;t=000361;p=1#000005"]this is the solution you need[/url]. Just change it a bit for 8 characters.
Let us know if this does the trick for you.