![]() |
#3
|
|||
|
|||
![]()
Thank you. This is doing the overall job that I am requesting but it is removing some lines completely and others it is removing too many characters from the start of the line. Here is a deidentified example:
1. ISA*00* *00**AA*123456789*AA*123456789*123456*1111*^*98765*1234567*0*P*: 2. GS*LV*123789456*123987546*20151222*1122*1*X*005010 X221A1 3. ST*835*123456789 There could be thousands of lines like this with 2 or three character segment headers. The end result with the streaming would be this: ISA*00* *00* *AA*123456789 *AA*123456789 *123456*1111*^*98765*1234567*0*P*: GS*LV*123789456*123987546*20151222*1122*1*X*005010 X221A1 ST*835*123456789 Due to text/word limitations the GS looks like it is on a new line but there is no CR. After running your macro this is what I get: SA*00* *00* *AA*123456789 *AA*123456789 *123456*1111*^*98765*1234567*0*P*: S*LV*123789456*123987546*20151222*1122*1*X*005010X 221A1 ST*835*123456789 The beginning of the segment headers is getting removed. Please let me know if you need any additional information. |
Tags |
loop macro, vb, word 2013 lines |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
bracketandquotes | Word VBA | 17 | 02-16-2015 03:51 PM |
Save As Macro using first line of document as document name | redzan | Word VBA | 1 | 01-31-2015 09:24 PM |
![]() |
ilcaa72 | Word VBA | 4 | 02-13-2014 11:48 AM |
![]() |
Yamaha Rider | Word VBA | 2 | 02-07-2012 05:33 PM |
![]() |
Nano07 | Word VBA | 2 | 11-02-2011 05:14 AM |