View Single Post
 
Old 12-22-2015, 02:49 PM
NDeane NDeane is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Dec 2015
Posts: 2
NDeane is on a distinguished road
Default

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.
Reply With Quote