Converting memo field to text field?

[pjwraith]

I find myself in need of converting a memo field to a text field!! I am a lite user of foxpro and not a programmer so please bear with me.

To make it simple I am in a position where I have the following fields to a foxpro 6 table called NOTES.

Coderef (index field)
Memo1 (memo field)
Text1 (Text field I would like the comment in!)
Memo2 (memo field)
Text2 (you get the idea)
Memo3 etc

I know from scouring the threads last week that it is apparently easy to copy the memo data to the text field but I was not quite able to achieve the result I wanted.I wish to copy all the satat in the table ie all 2000 records.

Can someone give me some clear code lines to achieve my ends?

Thanks in advance for your help.

 

[baltman]

Try making new text columns for each memo field and then use the "replace all" command. e.g. "repl all newtextcol with memotxt".

Brian

 

[pjwraith]

Thankyou, this has done exactly as I needed.