Community

Hello ak47wong,

Thanks again! I wanted to type 'now I must...' instead of 'no I must...'

I tried to 'manipulate' your first answer at my first question

Find what: ^(65.*_)!.*!(.*) [replace the underscore with a space]
Replace with: \1\2
[X] Regular expression
Click Replace All

But without ...

Hello ak47/wong,

No I must remove all text after the last note of exclamation, in all lines,
Is it possible to make an regular expression to do this ?

old record...

4701 mc
3011 Theresa W.@Devasahayam!337826528!Theresa W. Devasahayam
4900 01-06-11 18:57:48.000
6501 !333331370!Jamaica
6502 ...

no, only numbers
two rows with 4 positions

0002 0045
0132 1234
etc

Hello,
I cannot find the right answer/solution for the following
I have two list with numbers>list A:1500 and listB: 1300
and I want een output of the lacking numbers of differing numbers..
Compare does not generate the missing numbers in a lst..
Anyone a idea?
Thanks in advance..
nico

Thanks for your reactions.
I was not specific enough.
The records are not always exact with 5 lines,
sometimes there is a line with 904 p
I was looking for a solution that, when I let the cursor move to 500, a search starts for the next line 500 and
then everything between those '500s' blocks and ...

Hello I have a lot of records like this...

500 a
700 b
900 c
901 f
902 e

500 a
700 b
900 c
901 d
902 e


I want to make a macro that searches for records with
an 'f' on 901, and then deletes the record beginning with 500 til 902

It is difficult for me to let the cursor go up to 500 (from ...