if you create a spreadsheet in Excel,
enter a carriage return inside a cell (Alt/option+Enter)
save as TSV, you see CSV-like escape in the resulting file.

e.g.

"A
B"

4D's import dialog or Quick Report doesn't offer this option,
but it is not that difficult to implement.

https://github.com/miyako/4d-component-csv

alternatively you could export XLSX directly from 4D

https://github.com/miyako/4d-plugin-xlsxio
https://github.com/miyako/4d-plugin-opc

there is always the question "what if..."
hanging over a solution that depends on an "unlikely" substitute sequence.

2018/08/04 2:43、Randy Engle via 4D_Tech 
<4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール:

Replace the CR (13), (10), (11) with "///" or somesuch.
Then put the CR back after import.



**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************

Reply via email to