[Solved] Convert 3-line entries to 4-line format

[TmTm]

I would like to run a macro a specific number of times, but have not found an answer.
My file consists of 17k entries formatted as follows:
\lx abc [lexical entry]
\mr xyx [morphology]
\ge pqr [gloss]
...
My macro copies the \lx line, inserts it under the \lx line and replaces \lx with \ph, so that the wanted output is:

\lx abc [lexical entry]
\ph abc [phonology]
\mr xyz [morphology]
\ge pqr [gloss]
...
I want to either run the macro until \lx is not found, or more modestly, to run it as many times as I know there are \lx lines--about 17 thousand.
I appreciate your help.

Edit: Changed subject, was Run a macro a specific number of times  Make your post understandable by others  -- MrProgrammer, forum moderator

[FJCC]

If I understand you correctly, this can be done with formulas instead of a macro. See the attached file. The formulas make a new column and you can keep the two columns or use paste special to replace the old column with the new values.

[FJCC]

I just noticed this is in the Writer forum. I should be able to save your file as a plain text document and import it to Calc to use my solution.

[Zizi64]

______________________________
OpenOffice.org 3.3
Windows 7

Please update your signature in this forum. I can not believe that you use the archaic old 3.3. version of the OpenOffice. Nobody will fix the bugs of that version, and nobody will remember how its features worked...

And I suggest you to change to the LibreOffice - if you not changed yet.