Exporting Hebrew to Mellel

[JonathanS]

Hi

 

Newbie question: after conducting a search on BHS I want to export the results from Acc 9.4.2, including the English reference, into Mellel (2.9) and include it in a table. Cutting and pasting simply lists the results. Ideally I would want to insert a tab between the English reference and the Hebrew verse content and then convert to a table in Mellel. Is there an intermediate step I am missing?

 

Thanks!

 

Jonathan

[jpkang]

You'll need to use a good text editor as an intermediate step. I recommend the very capable TextWrangler, whose use I am illustrating here:

 

Copy and paste the Unicode Hebrew into the text editor's window and then do a GREP search, looking for

 

\d+)\x{200F}

(this regular expression looks for a colon followed by a sequence of digits and then a right-to-left mark)

 

and replacing it with

 

:\1\t

(this regular expression replaces it with the colon, the matched digits in the find expression, and a tab character)

 

Make sure GREP is checked as in my screenshot:

 

 

Pasting the result into Mellel, selecting it, and choosing Edit > Convert Text to Table should give you the desired result. I suppose this could be automated... Joe?

[JonathanS]

You'll need to use a good text editor as an intermediate step. I recommend the very capable TextWrangler, whose use I am illustrating here:

 

Copy and paste the Unicode Hebrew into the text editor's window and then do a GREP search, looking for

 

\d+)\x{200F}

(this regular expression looks for a colon followed by a sequence of digits and then a right-to-left mark)

 

and replacing it with

 

:\1\t

(this regular expression replaces it with the colon, the matched digits in the find expression, and a tab character)

 

Make sure GREP is checked as in my screenshot:

 

 

Pasting the result into Mellel, selecting it, and choosing Edit > Convert Text to Table should give you the desired result. I suppose this could be automated... Joe?

 

Thanks so much - that works brilliantly!

[Joe Weaks]

I suppose this could be automated... Joe?

Are we talking about converting the results in an Analysis window into a tab delimited format?

This is exactly what the FlashCord File Converter does.

http://macbiblioblog.blogspot.com/2009/05/flashcord-file-converter.html

 

No, I see now that we're not talking about that.

I think it'd be easy to make a Service (or script or Quicksilver Action) that put tabs in place after the scripture reference.