Oh. My apologies. LibreOffice or Excel can split text based on a character. In this case, I would bring your text into excel, split to columns on | and copy it into a defined table within Lyx. Lyx accepts Excel "copy and paste" as long as you have the table already defined. You would want Excel to create your columns for you. This shouldn't take more than a few minutes.
Thanks, ~Ben On Tue, Oct 30, 2018 at 2:28 PM Baris Erkus <bariser...@hotmail.com> wrote: > 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 >
