Hi
Seem to be going round in circles at the mo with what I thought was relatively straightforward.
I've extracted some accounts data and need to create a fixed width file so I can update it into some other software.
For example I have columns SYSTEM CODE(2), ACCNR(8),DEPT(4),POSTDATE(6),NARR(20),POSTVAL(12),PERIOD(4),SPARE(200) and these are populated with this data as below. Numbers in brackets are the lengths of each field
I've used the LEFT formula like LEFT(A1&" ",2) but can't seem to save just that via a PRN file so my old brain is struggling. I get the impression this is probably not the best way of doing this
Ideally I would like to use a macro to output the file from within my raw data automatically
Any ideas/assistance would be appreciated
Cheesey
Seem to be going round in circles at the mo with what I thought was relatively straightforward.
I've extracted some accounts data and need to create a fixed width file so I can update it into some other software.
For example I have columns SYSTEM CODE(2), ACCNR(8),DEPT(4),POSTDATE(6),NARR(20),POSTVAL(12),PERIOD(4),SPARE(200) and these are populated with this data as below. Numbers in brackets are the lengths of each field
NL | B301 | 130220 | TEST | 120.00 | 0619 |
NL | G121 | 130220 | TEST | 120.00 | 0619 |
I've used the LEFT formula like LEFT(A1&" ",2) but can't seem to save just that via a PRN file so my old brain is struggling. I get the impression this is probably not the best way of doing this
Ideally I would like to use a macro to output the file from within my raw data automatically
Any ideas/assistance would be appreciated
Cheesey