Anyone got any neat way of exporting/importing a CSV format into/out of a memo field?
I've done it, but not very elegant. The problem is that memo fields may contain CR/LF (<13,10>) combinations that. The only way I can figure is to parse through the memo field converting the CR/LF Combo to a comma. Then reverse the process by converting the comma back into a '<13,10>' again. Messy. (The reason is that the user needs to import/export into an excel spreadsheet at times. Each 'line' of the memo field needs to go into the next cell on the spreadsheet). As I say, have done it, but involves lots of 'IF THEN' and loops. As I said, messy and not elegant!
I've done it, but not very elegant. The problem is that memo fields may contain CR/LF (<13,10>) combinations that. The only way I can figure is to parse through the memo field converting the CR/LF Combo to a comma. Then reverse the process by converting the comma back into a '<13,10>' again. Messy. (The reason is that the user needs to import/export into an excel spreadsheet at times. Each 'line' of the memo field needs to go into the next cell on the spreadsheet). As I say, have done it, but involves lots of 'IF THEN' and loops. As I said, messy and not elegant!