I am looking at an issue where I would prefer to resolve it from the monarch project angle instead of writing some other code.
As it stands I have a report that is being parsed by Monarch and a pipe delimited extract file is created which is later used in a bulk insert to SQL.
The issue I have is the report contains a field say District #### but in some cases my source report file has only ### with a leading blank:
expected input '0123' actual input ' 123' and my extract file then contains | 123| instead of |0123|
Is there any way in the monarch project to force a leading zero if the number is below 1000 ?
REPORT NUMBER MYREPORT - ## MYCOMPANY
MY REPORT HEADING LINE
FROM 06/01/2014 - 06/07/2014
DISTRICT: 123 - MYDISTRICT ALPHA
SR. PROD MGR: ## - SOMEBODY
PRODUCT MGR: 4 - SOMEONELSE
<- - C O M P L E T E D - -> <- - - - - -
FAC MY VENDOR NAME INVOICES LN-ITMS $AMOUNT INVOICE %
=== ================================ ============================ ============
**** NO EXCEPTIONS
MYREPORT|2014-06-08|06/01/2014 - 06/07/2014| 123|MYDISTRICT APHA||||||||||||||||||SOME FIELDS|