At 10:06 AM -0400 2006/10/26, Jd Lyall wrote:
Google Kreme wrote:
My text file looks like this:
*****
abound / gen anpil, abonde
about / apropo, a
about to (do something) / fè sa pou
above / anlè, soutèt
*****
Well, you almost have one column for the words
and one for the defs already. Why not simply
find ' / ' and repalce with a tab, then import
the file into Excel/OOo?
Wi, se vre. That worked. I was thinking too
complicated. And, I haven't used a spreadsheet
in almost 20 years. Something that came with
Paradox or WP. And a lotus clone for Amiga.
Got that working. Beiks made one for me and I
saw the errors that came up. Fixed those,
sending it in to them again.
Now I realize that this in an English-Kreyol
lexicon and I should have a kreyol-english one
as well.
[I did use dropbook to create an ereader
dictionary but now my ereader says it needs to
be pro to work with a created dictionary.]
So now I need to get the first word(phrase) up
to the tab, cut it and put it at the end of the
line. With a new tab separating them.
In Excel, this is trivial; the person
who's generating lexicons from Excel files can do
it for you.
Click on the B column heading to select the whole column.
Cut.
Click on the A column heading.
Insert:Cut Cells (there's also a contextual menu item for this).
Assuming you're editing the tabbed
version in BBEdit and want to flip it, just do
this GREP:
Search for: ^([^\t\r]+)\t([^\t\r]+)$
Replace with: \2\t\1
Chris
--
Chris Pepper: <http://www.reppep.com/~pepper/>
<http://www.reppep.com/weblog/pepper/>
Rockefeller University: <http://www.rockefeller.edu/>
--
------------------------------------------------------------------
Have a feature request? Not sure the software's working correctly?
If so, please send mail to <[EMAIL PROTECTED]>, not to the list.
List FAQ: <http://www.barebones.com/support/lists/bbedit_talk.shtml>
List archives: <http://www.listsearch.com/BBEditTalk.lasso>
To unsubscribe, send mail to: <[EMAIL PROTECTED]>
