On 10/30/2018 6:50 PM, Rich Shepard wrote:
> I have an 82-line text file which has 5 columns separated by pipes. '|',
> and a wide column with location names. Text file format examples:
>
>  10775    | Santiam R. at Jefferson 
> Bridge                                  | 1979-11-06 | 2011-01-06 |    67
>  10386    | Middle Fork Willamette R. at asper 
> Bridge                       | 1979-11-06 | 2011-01-05 |    66
>  29043    | Willamette R. at Willamette Park boat 
> ramp/Corvallis            | 2002-10-02 | 2011-01-06 |    60
>  26339    | Willamette R. upstream of Newberg Bridge at Rogers 
> Landing      | 2002-10-01 | 2011-01-13 |    59
>  10344    | Willamette R. at Wheatland 
> Ferry                                | 1980-02-07 | 2011-01-10 |    58
>  29044    | Willamette R. at Greenway bike 
> bridge/Eugene                    | 2002-10-02 | 2011-01-04 |    52
>  10379    | Coast Fork Willamette R. at Hwy 
> 58                              | 1979-11-06 | 2011-01-05 |    50
>  10821    | Willamette R. at St. Johns 
> Bridge                               | 2004-08-04 | 2011-01-11 |    48
>  10355    | Willamette R. at Hwy 99E 
> (Harrisburg)                           | 1980-02-06 | 2011-01-04 |    46
>  31731    | Willamette R. at Wallace Marine Park boat 
> ramp                  | 2005-05-31 | 2011-01-10 |    44
>  27986    | Middle Fork Willamette R above Hills Crk at USGS Gage 
> 14144800  | 2002-10-03 | 2011-01-05 |    44
>
> (N.B. Line length is 110 characters so it likely will be wrapped at
> different lengths, depending on which MUA you use.)
>
>   In LyX this will be a long table in landscape orientation among 
> pages in
> portrait orientation.
>
>   What is the most efficient procedure to import this to a 5-column, 
> 83-row
> table? And, can I define the table size without dragging the table 
> icon off
> the bottom of the monitor?
>
> TIA,
>
> Rich

I have done this, seems to work:

1. Replace all the "|" with the tab character with a text editor.
2. Select the portion you want to paste.
3. Go to the first cell in Lyx.
4. Edit > Paste Special > Plain Text.
5. Table row and columns numbers should be compatible with the text file 
contents...

However, if you want a more automated process, maybe you can generate a 
LyX file using some Matlab or Python code. Then insert this LyX file 
into your main LyX document.

LyX has the following format for table cells:

<cell alignment="center" valignment="top" topline="true" 
bottomline="true" leftline="true" usebox="none">
\begin_inset Text

\begin_layout Plain Layout
**** CELL CONTENT ****
\end_layout

\end_inset
</cell>

Baris

Reply via email to