I would like to know if I created a list of numbers from WinBatch or AS400 is there some way I can have text pad read the file and delete the matching lines from another file that I open with TextPad for editing. What I have, a list of policy numbers that have to be deleted from another file I use for a 3rd party application. I use text pad to edit the file used for a application.
Thanks
delete multiple lines
Moderators: AmigoJack, bbadmin, helios, MudGuard
-
Bob Hansen
- Posts: 1516
- Joined: Sun Mar 02, 2003 8:15 pm
- Location: Salem, NH
- Contact:
Have both files open in TextPad
Then create a macro to read a line from the list, copy the value to the clipboard, switch to the other open file, and paste it into the Find box of Find Window. Then tag the found line, then delete the tagged line. Go back to the first file, go down one line to the next value on the list.
Have the macro run as many times as you have lines in the list to be removed.
Then create a macro to read a line from the list, copy the value to the clipboard, switch to the other open file, and paste it into the Find box of Find Window. Then tag the found line, then delete the tagged line. Go back to the first file, go down one line to the next value on the list.
Have the macro run as many times as you have lines in the list to be removed.
Hope this was helpful.............good luck,
Bob
Bob
-
LEER
- Posts: 3
- Joined: Thu Sep 06, 2007 7:09 pm
MULTIPLE LINES
I tried using the macro idea, copy the value from the first file and pasting it in the find for the other file. I am having a problem with carriage returns also copying along with the data. I tried using block mode still not working. The only way I could eliminate the line feed or carriage return was to highlight the line. I guess I am not sure that is considered a key stroke,(using shift key and right arrow key).
Thanks
Thanks