Hi Jeff

Thank you for your help, it’s always good to hear from you and your help is always appreciated.

Unfortunately, when I provided a copy of the output to the vendor they indicated that the spec I was provided was out of date and the new spec calls for a fixed length file. However, some of the fields need to be zero filed and other filed with spaces.

Example the second field in each line the file is location, that field length is five characters but left justified, in another example the quantity field is a total of 13 characters the first 9 are the whole number and the last 4 are decimal

10000ISC  00002020040120200305
10000ISC  000145452                    0000000020000EA

To use a complex record map I will need to have the source file format to be modified to something like this, correct?



OBR |<OBR-3>|<OBR-4>|<OBR-7>|<OBR-16>|<OBR-22>|<OBR-25>|

OBX |<OBX-2>|<OBX-3>|<OBX-5>|<OBX-6>|<OBX-7>|<OBX-8>|<OBX-11>|

OBX |<OBX-2>|<OBX-3>|<OBX-5>|<OBX-6>|<OBX-7>|<OBX-8>|<OBX-11>|

OBX |<OBX-2>|<OBX-3>|<OBX-5>|<OBX-6>|<OBX-7>|<OBX-8>|<OBX-11>|