Deleting repeating rows in memo field

[dzdncnfsd]

What is the command that searches for a string in a memo field and allows you to delete all but the first instance of the string?
Thanks,
Gladys [sig]<p>Gladys Clemmer<br><a href=mailto:gladys.clemmer@fifsg.com>gladys.clemmer@fifsg.com</a><br><a href= > </a><br> [/sig]

 

[jonscott8]

Hi Gladys,

lcMyNewString=STRTRAN(lcMyOldString,lcFindThisString,'',2) [sig]<p>Jon Hawkins<br><a href=mailto: jonscott8@yahoo.com> jonscott8@yahoo.com</a><br><a href= > </a><br>The World Is Headed For Mutiny.....When All We Want Is Unity. - Creed[/sig]

 

[JDurbin]

I think we need a timer for '&quot;LANd speed record&quot; replies with a correct or accepted response here like they do in another site. I wonder how fast you spit that one out Jon. [sig]<p>John Durbin<br><a href=mailto: john@johndurbin.com> john@johndurbin.com</a><br><a href=

http://www.johndurbin.com>

</a><br>MCP Visual FoxPro<br>
ICQ VFP ActiveList #73897253[/sig]

 

[dzdncnfsd]

Thanks for the help. I have been struggling with this off and on all day. The problem is, the string is not exactly the same in each record. It starts out the same, but ends differently. I want to look in each memo field and delete repeated strings after the first occurrance, but I can't figure out how if I have to be explicit in the statement. Can I trap the first line of each memo field and have that be used as the string to look for on that record?
(I hate MEMO fields!!!!)
Thanks again. I am the only one in my company who uses FoxPro, so if I didn't have you guys to turn to I would go insane(r).
Gladys [sig]<p>Gladys Clemmer<br><a href=mailto:gladys.clemmer@fifsg.com>gladys.clemmer@fifsg.com</a><br><a href= > </a><br> [/sig]

 

[jonscott8]

Alines() places each line of a memo field into a corresponding element of an array.

MemLines() returns the number of lines in a memo field.

MLine() returns the specified line of a memo field. [sig]<p>Jon Hawkins<br><a href=mailto: jonscott8@yahoo.com> jonscott8@yahoo.com</a><br><a href= > </a><br>The World Is Headed For Mutiny.....When All We Want Is Unity. - Creed[/sig]