File - File Scenario

[former_member650236]

Hi Experts ,

I am new to BCM integration,requirement is getting tag file as source and need to make it Tab delimiter.

source file MT 100 Payroll payment sample file                                                           

RequestType#mt100-payroll

Housebank#USDDXXXX

TransactionCounter#00001

USDD0XXX

100

USDD0XXX

MOL#74603-01

:20:1857000810

:32A:151006USD1,00

:50:STREAM COMP

:52A:USDD0XXX

:53B:/3231649009940

:57A:USDD

:SAL:0.00

:HRA:0.00

:OTH:1.00

:DED:0.00

:ID:2353361070

:59:/SA6320000001010171949940

ALEXANDER JOSEPH MARTINA

SA -  TEXAS

:70:No.53000/

Target File is Tabdelimiter

Header Info

First Row 2 items we have to hardcode it(AAL  0247 Values).

AAAL 0247 032401361054 USD 20150528 100,00(this value is increasing if there are 2 cusotmers then 200,00)   02470012015148 1-123310

Footer

Netamnt  Employee account Emp Name    Bankcode Typ paymnt Basic HRA OTH Deduct Emp ID Txn Refrnumb Txnstats TxnDate

100,00 SA5655000000025931400134 ALEXANDER JOSPEH DSFR Salary 50,00 50,00 0,00 0,00 2212746529 SRE1515110700001 Success 20150601

Please let me know how to achieve this in mapping. I have to increment the number with simple UDF when ever the values changes?

Netamnt i can concatenate it with salary,HRA ....

Regard,

Shaik

[bhavesh_kantilal]

Considering you have raised this question in another thread as well here : 

Can you please close / delete this thread to avoid duplications?