Scenario is Idoc to File scenario using BPM, needs to drop the file using FCC and BPM collect messages is used
All the fields are populating successfully but facing issues with serial number and date fields,
1. With respect to Serial Number:
from the source i will be getting 18 digit serial number padded with zeros
Source : 000000001234506789 -- Need the ouput as 01234506789 for this i have writen UDF using substring.
but when i check this in message mapping i could see 01234506789 but at the output file i see as 1234506789
i need o to be prefixed
2. the second issue is also as similar;
i have used the data transformation,
YYYYMMDD -- using date transformation i have changed to MMDDYYYY
here when the month is below 10, i mean 1 to 9 the dates are populating at output as 9102010 --> 9th Month date 10 and the year 2010, here also when i check in Message mapping i could see 0 prefixing as 09102010.
i have the fcc parameters as:
recordheader.fieldSeperator -- ,
recordheader.endSeparator -- "nl"
Need ;your valuable inputs ASAP..