Share
ReportHi all. I have a .CSV file format created in EFT for Payables. This works fine. The problem is that GP only allows fixed field lengths.
So for example...I can set the Beneficiary Account Name field to be 20 characters long. If the actual name is 'MICROSOFT'...this is 9 characters long...so GP creates then adds 11 trailing blank spaces. (or leading depending on how you set up the field)
The bank that the EFT file is being sent to however requires that there are no trailing spaces. So, a snippet of the EFT file from GP would look like:
123456,12345678,MICROSOFT ,REFERENCE,
But what the bank wants is:
123456,12345678,MICROSOFT,REFERENCE,
I can of course pad out the fields with a pad character of say '#', then when the file is created by GP I can open it in a text editor and do a find and replace...find all #'s and replace them with nothing. Thi works fine, except that it is an extra manual step for the user.
I have 2 questions:
Has anyone found a way in standard GP EFT for Paybles to make the fields dynamic? i.e. they change in size according to the text from the GP field they are linked to - up to the maximum field length?
If not, does anyone know of a way that I could automate the Find and Replace action? VBA maybe - that runs a process automatically as the file is being created, or after it has been created?
All and any ideas welcomed!!
Ian.
*This post is locked for comments
All responses (
Answers (
3,930
