<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt">David, <br><br>To understand your input request, someone wanted<br><br>A. to display each row of text from 2 separate files, alternating. <br><br>Or <br><br><div>B. To display an actual interlinear, matching 'related words'</div><div><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">For A, I would have:</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"> 1. loaded each file into excel, created a new Collumn 1 (named order) and autonumbered each row of C1 <br></div>2. Merged the 2 resulting tables into a single worksheet in excel<div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new
roman,new york,times,serif; background-color: transparent; font-style: normal;">3. Sorted them on collumn 1 in ascending order<br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">4. selected collumn 2 and output that to a file. <br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span>B. Is a little more tricky and would require (and i'm only working through the logical steps... you'll have to fill in the greps and specifics.</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color:
transparent; font-style: normal;"><span>1. creating an order for each word (if paragraphs matter, then give the EOL a word like {{EOL}}</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span></span><span>2. doing a dictionary lookup (Excel function LOOKUP). (Assuming you can turn both files into something similar to strongs numbers)</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span>3. Save each file which is now by collumn 1-word order, 2-word, 3-dictionary number as a flat file (remove the LOOKUP function)</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span></span><span>4. reopen each
file<br></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span>3. Sort File 2 on the definition numbers</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span></span><span>4. Create a 4th collumn in File 1 and LOOKUP the definition number in file 2 returning the word from file 2</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span>5. Create a Html Table based on these results</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span><br></span></div><br><div style="font-family: times
new roman, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> David Haslam <dfhmch@googlemail.com><br> <b><span style="font-weight: bold;">To:</span></b> sword-devel@crosswire.org <br> <b><span style="font-weight: bold;">Sent:</span></b> Friday, September 7, 2012 2:34 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> [sword-devel] The poor man's interlinear<br> </font> </div> <br>
/One my friends recently asked:/<br><br>Do you know of any program that will load two text files (plain text or Word<br>files) and display them interlinearly?<br><br>/Here's my reply:/<br><br>Not off hand, but here's an easy workaround using Excel.<br><br>First create a double-space copy of each text file. i.e. Replace all EOLs by<br>two EOLs.<br>e.g. Using Notepad++ replace \r\n by \r\n\r\n for a Windows styled text<br>file.<br><br>For the second file, insert an extra blank line at the top of the second<br>file, so this file has its text on even numbered lines.<br><br>Paste the contents for each double-spaced text file into a separate Excel<br>worksheet.<br><br>In another worksheet, use a formula in cell A1 to select accordingly. The<br>formula is<br><br>=IF(ISODD(ROW()),Sheet1!A1,Sheet2!A1)<br><br>where I've not renamed the worksheets.<br><br>Copy cell A1 to as many rows as you need.<br><br>Simples!<br><br>The whole operation could be achieved by a
more complex formula without the<br>prior need to convert the files to double-space.<br>I considered this at first, but came to the conclusion that simplicity is<br>preferable.<br><br>The method I described could be extended to cope with three (or more) files,<br>using the MOD function instead of the ISODD function. <br>i.e. By first making a triple-spaced copy of each file.<br><br>David<br><br>PS. I'd resist doing it for Word files, unless they are first converted to<br>Unicode text files.<br><br><br><br>--<br>View this message in context: http://sword-dev.350566.n4.nabble.com/The-poor-man-s-interlinear-tp4650950.html<br>Sent from the SWORD Dev mailing list archive at <a target="_blank" href="http://nabble.com/">Nabble.com</a>.<br><br>_______________________________________________<br>sword-devel mailing list: <a ymailto="mailto:sword-devel@crosswire.org"
href="mailto:sword-devel@crosswire.org">sword-devel@crosswire.org</a><br>http://www.crosswire.org/mailman/listinfo/sword-devel<br>Instructions to unsubscribe/change your settings at above page<br><br><br> </div> </div> </div></body></html>