acantor Posted September 10, 2013 Report Share Posted September 10, 2013 I have a text file that consists of almost 10,000 lines of text like this: A AB BA CDA DRQ I need to transform the file into this format: A\A AB\A B BA\B A CDA\C D A DRQ\D R Q The approach I took was to use the MEP ASCII File Process command. To begin, I transformed the file into a tab deliminated file by adding a tab to the end of each line. (Easy to do with search and replace.) After trial and error experimentation, the macro worked. It copies each line to a variable, appends a backslash, and adds a space after each letter. I am curious to know how other people might add a space after each letter. My code is more convoluted than I expected. Although it was a fun exercise, I now want to learn more elegant ways to accomplish the same thing. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.