- This topic has 3 replies, 2 voices, and was last updated 15 years, 1 month ago by .
-
Topic
-
We are currently working on a General Ledger interface for Maestro. We will be reading the following file from a directory. 0120090702GL TRANSACTIONSHH_200906PE
05MONTHLY BATCH HH 06/2009 2009063020090630BILLING_AR
1012345678 6168.12
1013456789 24430.37
1014567890 1850.00
:
:
1015678901 11394.66
99
(Colons represent repeating lines, 99 indicates end of file)
We need to convert it to the following format.
FHS|^~&|MM||GL|RMC
BHS|^~|MM||GL|RMC|||||Wed Apr 01 07:15:07
MSH|^~&|MM||GL|RMC|||GLI^G01|1234567800000000|P|2.5
ZJR||MM12345678900000|Issues from MAESTRO|FN|20090331|200903
ZTX||16114600|DR|223.5580
ZTX||11160162|CR|-363733.20
ZTX||16113500|DR|1132.36
ZTX||16113600|DR|1923.16
ZTX||16775250|DR|31476.70
ZTX||16113800|DR|132.2170
ZTX||16513600|DR|2566.310
:
:
ZTX||17376300|DR|7.0000
ZTX||17373500|DR|8.6304
BTS|0|GL Batch Trailer
FTS|1|GL Issues from MAESTRO
(Colons represent repeating segments0
I was just looking for suggestions on how others are handling this type of issue before I start spinning my wheels.
We are on v5.5 Rev1, RedHat es4
Any assistance will be greatly appreciated.
- The forum ‘Cloverleaf’ is closed to new topics and replies.