I have to someone export data to a txt file that is not delimited (ie the first record is some string constants, then some detailed records, then a summary line). Each field also has to be padded. It's for a bank that needs it for imports. I could develop it to export the details, however, I'm not sure how to export the header, then export the details to the next line of the text file etc etc. I also have to have lead zeros for some fields then pad string data up to a certain # of characters. I am not a VS developer. BCP?
This the actual data from the sample txt file with padding. ARSH is the header, 12345 are the details and ARST is the footer. All is in one txt file.
ARSHISSGENERICT1234567890123061004
1234567890123000000000100000010000061002GENERICGENERICGICOMPANY NAME GENERIC INFO 1234 VICTORIA PARK AVENU, NORTH YORK , ON M2M M2M
1234567890123000000000100000010100061002GENERICGENERICGICOMPANY NAME GENERIC 100 KING STREET TORONTO , ON M2M M2M
1234567890123000000000100000010200061002GENERICGENERICGICOMPANY NAME GENERIC INFO ONE MINISTRY OF NOTHING 7800 AIRPORT PARK OTTAWA , ON M2M M2M
ARST0000000030000000030300
This the actual data from the sample txt file with padding. ARSH is the header, 12345 are the details and ARST is the footer. All is in one txt file.
ARSHISSGENERICT1234567890123061004
1234567890123000000000100000010000061002GENERICGENERICGICOMPANY NAME GENERIC INFO 1234 VICTORIA PARK AVENU, NORTH YORK , ON M2M M2M
1234567890123000000000100000010100061002GENERICGENERICGICOMPANY NAME GENERIC 100 KING STREET TORONTO , ON M2M M2M
1234567890123000000000100000010200061002GENERICGENERICGICOMPANY NAME GENERIC INFO ONE MINISTRY OF NOTHING 7800 AIRPORT PARK OTTAWA , ON M2M M2M
ARST0000000030000000030300