hellsreach
New Member
- Joined
- Dec 22, 2015
- Messages
- 19
I am looking for a way to export data in a delimited format to text.
To be clear, I have data in cells, and I need to export that to a text document to be uploaded into SAP. I can, easily enough, code a macro convert everything to text format, and add the appropriate number of spaces to the string to "fit" the upload format. Theoretically, I could simply add one fewer space that I need and export as space delimited (I think -- haven't got that to work quite right, yet in the hour or two I've worked I have been figuring things out), but for one problem. I have three cells would are loaded into one field in the database and don't have spaces, so I cannot subtract one and export as space delimited text. Obviously, I cannot use VBA to manipulated the text in notepad (that I know of -- correct me if I am wrong).
Any ideas?
To be clear, I have data in cells, and I need to export that to a text document to be uploaded into SAP. I can, easily enough, code a macro convert everything to text format, and add the appropriate number of spaces to the string to "fit" the upload format. Theoretically, I could simply add one fewer space that I need and export as space delimited (I think -- haven't got that to work quite right, yet in the hour or two I've worked I have been figuring things out), but for one problem. I have three cells would are loaded into one field in the database and don't have spaces, so I cannot subtract one and export as space delimited text. Obviously, I cannot use VBA to manipulated the text in notepad (that I know of -- correct me if I am wrong).
Any ideas?
