Copying long memo field to multiple text fields??

[pjwraith]

I have in the past had need to copy memo fields to text fields for easy export purposes.

I have a memo field now which exceeds 256 characters which I need to copy to (presumably) multiple text fields for export and manipulation.

Can anyone give me details of how to achieve this?

Many thanks in advance.

 

[danceman]

STRTOFILE( ) Function

Attitude is Everything

 

[pjwraith]

Thx for the hint, I have read the function thru but see no way to split the memo into chunks to fall into multiple fields as the length exceeds the 256 character limit for one field...

My apologies for sounding stupid, I am not a programmer!!

Thanks again.

 

[JackTheC]

Make XX fields named TXT1 til TXTXX to contain the lines:


set memowidth to 250

scan
for tt=1 to min(XX,memlines(MEMONAME))
line=mline(MEMONAME,tt)
fld='TXT'+alltrim(str(tt))
repl &fld with line
endfor
endscan

 

[danceman]

if you are trying to copy the memo contents to an external file, look at COPY MEMO MemoFieldName TO FileName

if you want to display the memo field to a form then use the edit box control.
Attitude is Everything

 

[DSummZZZ]

Why not use an edit box control instead of multiple text box controls?
Dave S.