On Feb 17, 5:54*pm, AND wrote:
hello,
I have these data:
LVSNR * AKNUS * AKAVZ * LVCOD * LVARR
CJ03304442 * * *872620080 * * * 16 * * *VI * * *SV
CJ03304442 * * *872620080 * * * 41 * * *VI * * *SV
CJ03304442 * * *872620080 * * * 41 * * *VI * * *SV
IU00789017 * * *873050400 * * * 16 * * *BZ * * *MI11
IU00789017 * * *873050400 * * * 16 * * *BZ * * *CO
MT21880207 * * *872465980 * * * 07 * * *MEL * * CZ
MT21880207 * * *872465980 * * * 05 * * *MEL * * MO
MT21880239 * * *872466300 * * * 16 * * *MEL * * CZ
MT21880239 * * *872466300 * * * 16 * * *MEL * * CZ

they are thousands rows, so I don't need of *filter on, becouse they are too
much to be check one to one.

I need know
1.what's the line next a value. * AND
2.what's the line before a value.
for example:
If I know this line:
IU00789017 * * *873050400 * * * 16 * * *BZ * * *CO
1. * * * * * * * * * * * I need to know the next line, tha's:
MT21880207 * * *872465980 * * * 07 * * *MEL * * CZ

and if I know this line:
MT21880239 * * *872466300 * * * 16 * * *MEL * * CZ
2. * * * * * * * * * * * if I need to know the previous line, what's the way?:
MT21880207 * * *872465980 * * * 07 * * *MEL * * CZ

I know it is not easy, but I hope u can help me, becouse it's really
important for my job!.
thanks a lot to everyone wants help me.
--
Andrew

Why do you need to do this? What are you trying to do?