Hmmm....I'm having more 'Keys' problems.
I'm wanting to export a multiline LC field (created by carriage returns) and import it into Excel maintaining the CRs that were in the field.
I'm doing the overall export successfully as a CSV file as per LC lesson: https://lessons.livecode.com/m/4071/l/1 ... a-csv-file
Excel is of course then transcribing the carriage returns that were in the LC field as new rows instead of keeping the multiline field as a multline Excel cell!
However, I don't think this will happen in Excel if I can 'replace' the CR in the field with 'Alt + CR' - faced with Alt+CR separating lines, Excel will create a multiline cell (if this is done manually)
I've tried to do this by code with various permutations of
Code: Select all
...
replace CR with AltKey & CR in field"fExportAnswer"
...
Just wanted to check if there was a way of achieving this??
Thanks,
Glenn