I've been asked to produce a package that will produce a text file to be imported into a website. This file needs to include a non-standard delimiter, ¬, and has a lot of blank columns. Essentially I need to go from an Excel file with data that looks like this: ORG VALUE AA1 5 AA2 7 AA3 4 AA4 5 AA5 2 To a text file that looks something like this: ¬¬AA1¬5¬¬¬¬¬¬¬ ¬¬AA2¬7¬¬¬¬¬¬¬ etc. My idea was to create a table that added the delimiters in as columns but then export the text file without delimiters to form a single string but I can't get it to do that. To make things more difficult I'm having to do it all using the GUI rather than coding (long story). Any advice on how I can export without delimiters, or another way around the problem, would be much appreciated.
... View more