Page 1 of 1
to delete alternatively
Posted: Fri Oct 06, 2006 4:02 pm
by look4kannan
hi iam new to wildedit
whats the easiest way to delete all lines(everything) untill special word comes(delete including that)
example
12 12 12 12 12 12
12 12 12 12 12 12
12 12 12 12 12 12 22 xx a1 a2 a3 a4 a5 a6 yy c1 c2 xx zz
12 12 12 12 12 12
12 12 12 21 12 12
12 12 12 12 12 12 xx b7 b8 b9 b0 b1 b2 yy zz c3 c4 yy
final result should be
123456
789012
task is to delete everything untill 'xx' comes(including xx),(xx should be first xx in the line)
and then to delete one space and one character or numeric
untill 'yy' comes (including yy)
this should be edited for 1000's of lines
please help me
Posted: Fri Oct 06, 2006 5:55 pm
by Bob Hansen
Playing back what you need in other words:
Keep everything between xx and yy, drop the xx and yy, and remove first letter of each word, and the spaces that remain on what remains.
Is that correct?
I suspect that this may need to be done in multiple passes, will that be OK?
hi
Posted: Fri Oct 06, 2006 6:15 pm
by look4kannan
i need need the commands for that please
hi
Posted: Fri Oct 06, 2006 6:18 pm
by look4kannan
u know iam new to wild edit!!!!!!!!
i need step by step procedure to edit that file
Posted: Sat Oct 07, 2006 12:18 am
by Bob Hansen
There is probably an easier method, but this worked on the sample you provided. Using TextPad tools, not WildEdit.
Multiple passes, Check box in Regular Expressions, Editor using POSIX
Ignore quote symbols ("), use values inside the quotes.
All Replace settings use Active Document.
May want to make a copy of document after each step in case of errors.
================================
Start here
1. Find Mark All with "^.*xx(.*)"
2. Search/Invert All Bookmarks
3. Edit/Delete/Bookmarked Lines
Now only have the lines to be processed
4. Search/Replace "^.*xx(.*)yy.*" with \1
5. Search/Replace "yy.*\n" with \n
6. Search/Replace "[a-z]" with nothing
7. Search/Replace "[[:space:]]" with nothing
=====================
Result is:
123456
789012
hi
Posted: Sat Oct 07, 2006 11:35 am
by look4kannan
sorry to distrub u again.
ur information is very helpful for me
thankyou verymuch for ur help
i forgot to ask u b4
example
12 32 13 45 aa 65 98 65
54 21 54 32 21 87 98
65 54 21 65 aa 54 87 01 02
result
2235a585
5415a4712
(i.e line which dont have 'aa' should be deleted entierly
then first character or number of all should be deleted
lastly i need to align all lines with 1 line spacing)
hi
Posted: Sat Oct 07, 2006 11:58 am
by look4kannan
now iam able to delete lines without aa
i just want help to delete two spacing after the first one
example
12 12 12 12 32 32 54
54 65 65 65 65 65 65
result
2222224
4555555
Posted: Sat Oct 07, 2006 5:43 pm
by Bob Hansen
Starting with this:
12 12 12 12 32 32 54
54 65 65 65 65 65 65
Make two passes, ignoring the quotes ("):
1. Replace "^.{1}" with nothing
2. Replace " .{1}" with nothing (note the space at beginning)
Results with this:
2222224
4555555
hi
Posted: Sat Oct 07, 2006 6:47 pm
by look4kannan
thank u so much 4 ur help
lastly how to make 1 line spacing after each line
thanks for ur help again
Posted: Sat Oct 07, 2006 8:30 pm
by Bob Hansen
Replace "\n\n" with "\n"
Ignore quotes