>>>
>>>Done that yesterday <g> BTW, another little catch here - CHR(13)+CHR(10) in Memo fields should be replaced with CHR(10) to be properly shown in Excel.
>>>
>>
>>I applied your suggestion of changing CHR(13)+CHR(10) to CHR(10) as following:
>>
>>
>>replace MYMEMO with STRTRAN(MYMEMO,CHR(13)+CHR(10),CHR(10))
>>
>>
>>but I still see the square brackets when looking at the data in the spreadsheet. Do you see anything wrong in my use above?
>>
>>Thank you.
>
>Here we use a special function, which is supposed to do the same:
>
>
>LPARAMETERS tmMemo
>local laLines[1], lnLines, i, lcString
>
>lnLines = ALINES(laLines, m.tmMemo, .t.)
>DO CASE
> CASE lnLines = 0
> lcString = ''
> CASE lnLines = 1
> lcString = laLines[1]
> OTHERWISE
> lcString = ''
> for i = 1 TO lnLines - 1
> IF NOT EMPTY(laLines[i])
> lcString = lcString + laLines[i] + CHR(10)
> endif
> ENDFOR
> * Add the last line with no line feed.
> lcString = lcString + laLines[lnLines]
>ENDCASE
>
>return lcString
>
>Are you sure you're using Memo fields and not char fields?
Yes, definitely Memo field. I also noticed that if I don't run the memo field through STRTRAN() I see 2 square brackets. After running memo field with STRTRAN() I see only 1 square bracket in the same places. So I presume that the second one is there for some other reason. I think I will let the customer look at it to see if I find this to be a problem.
Thank you again for your help.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham