Thread: [Solved] convert text to tables
View Single Post
 
Old 03-17-2015, 04:49 AM
BruceM BruceM is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
 
Join Date: Feb 2015
Posts: 41
BruceM is on a distinguished road
Default

I looked at the attachment, although on my screen it still indicates 0 views.

My general approach would be to replace crlf with the pipe character (|) before the import (it rarely appears in text, so it is my go-to delimiter, but another character could be used). After the import that character could be replaced with crlf.
The thing I find myself wondering is how you would distinguish between crlf in the text you supplied, and crlf that would start the next row.
BTW, a trick for getting a quick block of text if Word: in any Word document type =rand() and press Enter. Put a number in the parentheses for a longer chunk of text.
Reply With Quote