Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 12-22-2015, 02:49 PM
NDeane NDeane is offline VB for Word - Need macro to loop each line in a document Windows 7 64bit VB for Word - Need macro to loop each line in a document Office 2013
Novice
VB for Word - Need macro to loop each line in a document
 
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
 

Tags
loop macro, vb, word 2013 lines



Similar Threads
Thread Thread Starter Forum Replies Last Post
VB for Word - Need macro to loop each line in a document macro to add brackets to each line and add single quotes to each word in the line 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
VB for Word - Need macro to loop each line in a document Loop through each Line in Word ilcaa72 Word VBA 4 02-13-2014 11:48 AM
VB for Word - Need macro to loop each line in a document Macro to loop in Word Yamaha Rider Word VBA 2 02-07-2012 05:33 PM
VB for Word - Need macro to loop each line in a document WORD Macro - import picture - resize - position - page break - loop Nano07 Word VBA 2 11-02-2011 05:14 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft