gselliott
Registered User.
- Local time
- Today, 02:49
- Joined
- May 17, 2002
- Messages
- 106
I am setting up a query that will be exported to a text file to be read in by one of our accounting programs.
The query will be exported in a Pipe Delimited format and i have set this up in my code and query. The problem i am having is that the program requires the numeric colums to be a certain length so any blank space in the column needs to be filled in with Zeros.
eg. If the column width is 11 characters wide and the value is 1500 then it needs to be exported as |00000001500|. I know this is possible but just cant remember how!
Any help would be appreciated.
Thanks
The query will be exported in a Pipe Delimited format and i have set this up in my code and query. The problem i am having is that the program requires the numeric colums to be a certain length so any blank space in the column needs to be filled in with Zeros.
eg. If the column width is 11 characters wide and the value is 1500 then it needs to be exported as |00000001500|. I know this is possible but just cant remember how!
Any help would be appreciated.
Thanks
