Thanks for this very helpful link that I have had a look at. I realise that I cannot expect answers on plate and as I pointed/confirmed I managed to get it to work so am grateful for all that commented. I was possibly tired as when I retried early this morning it worked and I even managed to sort out the clump of text that my OCR scanner produces via my Iphone. In other words I can auto insert the pipe delimiter and then press enter on each greek new word and get it to a single column that is then easy with pipe line to sort.
I had previously spent time endeavouring to find app/ program/software that would recognise the greek letters and preserve the columns in my book of Greek course I am learning but the only 1 find was what I ended up with. I noted that someone commented weird OCR scan but that was what I had to work with.
It takes a photo of neatly arrange page where there are 4 columns of text i.e 2 groups of Gr-En Gr En and produces a lump of text that is OCR’d but needs arrange
You may send a typical one of your photographs to the email account you should find in my user info. I would probably play with it to find a good way in your sense. However, I cannot spend much time on it at the moment.
What I have done is progressed with getting on with my project using what I have learnt thus far. I end up with the pipe line inserted with between greek and english pairs and I can plod through to then produce a singly column in ODTdoc to sort into 2 cell column 1st has greek and 2nd has english that is then imported into Anki flash cards.
I need to look at seeing if I can get around the manual part of pressing enter before each of the start of the greek words to get into a single column then when copied over to “ods” doc I can sort it with the data text to columns function in “calc”
περασμένος - η - ο | last άλλωστε | besides ανδρ κός - ή - o men 's αποφεύγω 1 avoid γνωστός - ή - o well known γυναιχείος - α - ο | women 's δύσκολος - η - ο | difficult , fussy τα ρούχα | clothes
So there must be away once I have got the first pipe insert and to avoid manually getting it initially into a singly column to automate the manual press “return key” before each greek word?
If you can get the lines from your textbook containing one or two Greek lemmas with their one or two English explanations, and import them into Calc there is a much simpler (more direct) way to get all that split correctly into columns with the help of the REGEX() function available in LibO V 6.2 0 and higher.
You find an example attached to my unswer under “EDIT”.
Hi the irony was that just before I stopped for a little lunch I started to relook at that model that was posted on the German site (Trim etc) and the fact that it was the obvious yet missed by me italics part of the question and I pasted in some text both Greek/Latin and italicised the text and of course it worked. I then saw that you had kindly already gone down the route of assisting with a couple of alternatives of I will simply call it the trim model spreadsht.
You offered to allow me to send my issue of how it scans as when I paste in these boxes it formats and I cannot attach photo? Anyway your email is not there but mine is on my profile page so if you are able to send me an email assuming u can see mine then I will attach a photo as with your knowledge I am sure you are only a minute or two from solving my dilemma of spending too much time. Good thing about the profile is that you are x years and I am 68 now so I dont feel too humiliated by all this as you are expert.
Hi note that you are a busy guy and I had a test with your “trim spread sheet model” that you kindly sent to me. Using your latest example I therefore pasted in to 1 of the cells in column a atypical extract of the text that is created. In other words a typical page from the Greek book in one of the chapters explaining the use of vocabulary will have on this varies up to 20-30 words. Therefore using the lower number that makes 20 pairs (a pair comprising the Greek word followed by the English translation).
My scanner puts all that into for example a simple notebook text file as a complete cluster of text. Of course it is very easy but very time-consuming to separate it into primitive columns in all sorts of document applications. I simply put the cursor at the start of the Greek word and pressed enter.
Using your model which I will label “trim” I therefore ended up with nearly 40 words in one of the typical cells (20 pairs) and I could not find a way of separating albeit thatyou have?
Accordingly therefore if you do have time it would be very much appreciated. I believe that with your efforts we are literally on the cusp.
Using your model which I will label “trim” I therefore ended up with nearly 40 words in one of the typical cells (20 pairs) and I could not find a way of separating albeit that you have implied that it should be fairly easy to do that by going directly to spreadsheet rather than via the document file. In other words hopefully avoiding the necessity of putting in delimiters in one document.
I then decided to try and speed things up by utilising the fact that you have kindly put on a couple of pairs per row and therefore I was able to divided up into 10 rows fairly quickly. In column A therefore I ended up with 10 rows of 2 pairs and everything works okay but I’m still convinced as you are! That there must be an easier way and given the level of your expertise it must be fairly easy to do that.
In other words if you do have a few minutes to examine?
I am about to go out. Will respond when I find the time.
Sorry I was waffling away and did not get to the point but your suggestions and examples of the greek language find etc were excellent. As a surveyor now retired I am getting into bad habits, waffling away and I sometimes dont get to the issues in my style of writing and can appreciate the frustration.
One important issue is for me to make damn sure I make a “£” contribution as I have only just started using this suite given the fiasco with subscription only Microsoft products on a pension and reviewing your own website and that of LibreOffice the support and network is superb.
Many Regards Nige
PS I will get on to the Unicode or csv stuff a little later as I got enough trouble learning Greek at moment and coping with retirement when there are sometimes just too many things to address - its taken me a year or so to get used to being retired
Please do not add comments as Answers if it is not an answer to the original question. Use add a comment instead. Or edit your question to modify. Thanks.
After all the help I received above I managed to sort out my “flashcard library development” in Anki and would like to thankeveryone.
Couple of issues I found this guy on youtube https://www.youtube.com/watch?v=7DG3kCDx53c who produces some REALLY EASY to understand REGEX videos that were invaluable. Diving in to the REXEGG.COM was a step too soon for me!
The other aspect is that there is an excellent inbuilt help menu on REGEX on this page
REGEX Function
Trouble is now I started this RegEx I have got a little distracted from my language learning to learning RegEx!
Sorry I was waffling away and did not get to the point but your suggestions and examples of the greek language find etc were excellent. As a surveyor now retired I am getting into bad habits, waffling away and I sometimes dont get to the issues in my style of writing and can appreciate the frustration.
Have no fear of punctuation!
Even if you cannot write with perfect schoolbook punctuation (Secret revealed: nobody is able to do that), too much is usually better than not enough.
The major “punctuation” is the paragraph break. Start a new paragraph when you change subject (like from “The other aspect is …”). Note: Two newlines is required in the editor here to have it displayed with a paragraph break when you post it.
Commas section your clauses, so what belongs together is easier tied together when reading. Read it aloud. When you feel like taking a breath or otherwise pause, a comma may be in order.