Hi folks,

I struggle with a simple task... As a I quite newbie with Word Macro, perhasp one of you got the answer.

I'm trying to transform the following text:

DP 43:29:02 N 003:50:39 E
DP 43:34:12 N 003:43:04 E
VD=+
VX=43:34:49 N 003:58:16 E
DP 43:45:45 N 003:59:56 E
DP 43:40:01 N 004:06:40 E
VD=-
VX=43:34:49 N 003:58:16 E
DP 43:29:02 N 003:50:39 E

I need to add one line after each "VX" line


This line should be build from:
"DB" + "whole 2 lines up without DP" + "," + "whole 1 line down without DP"

my aim is to get that:

DP 43:29:02 N 003:50:39 E
DP 43:34:12 N 003:43:04 E
VD=+
VX=43:34:49 N 003:58:16 E
DB 43:34:12 N 003:43:04 E,43:45:45 N 003:59:56 E
DP 43:45:45 N 003:59:56 E
DP 43:40:01 N 004:06:40 E
VD=-
VX=43:34:49 N 003:58:16 E
DB 43:40:01 N 004:06:40 E,43:29:02 N 003:50:39 E
DP 43:29:02 N 003:50:39 E

Many thanks !!!!

a picture is worth a thousand words