Jump to content


Photo

Exporting Hebrew to Mellel


  • Please log in to reply
3 replies to this topic

#1 JonathanS

JonathanS

    Member

  • Members
  • Pip
  • 2 posts
  • Accordance Version:9.x

Posted 14 September 2011 - 07:35 AM

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

#2 jpkang

jpkang

    Platinum

  • Active Members
  • PipPipPipPipPip
  • 577 posts
  • Gender:Male
  • Location:Seattle, WA
  • Interests:Comparative Semitics; ancient Hebrew semantics; Hebrew syntax; history and religion of ancient Israel; history of interpretation.
  • Accordance Version:10.x

Posted 14 September 2011 - 02:17 PM

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

<img src='http://www.accordancebible.com/forums/public/style_emoticons/<#EMO_DIR#>/sad.gif' class='bbc_emoticon' alt=':(' />\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:

Attached File  Picture 2011-09-14 at 12.09.31 PM.png   71.44KB   29 downloads

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?
J. P. Kang, Ph.D. (Bible)

#3 JonathanS

JonathanS

    Member

  • Members
  • Pip
  • 2 posts
  • Accordance Version:9.x

Posted 15 September 2011 - 02:58 AM

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

<img src='http://www.accordancebible.com/forums/public/style_emoticons/<#EMO_DIR#>/sad.gif' class='bbc_emoticon' alt=':(' />\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:

Attached File  Picture 2011-09-14 at 12.09.31 PM.png   71.44KB   29 downloads

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!

#4 Joe Weaks

Joe Weaks

    Platinum

  • Active Members
  • PipPipPipPipPip
  • 1,037 posts
  • Gender:Male
  • Location:Raytown, MO (outside KC)
  • Interests:I like things that are Orange, and possibly Blue.
  • Accordance Version:8.x

Posted 15 September 2011 - 05:31 PM

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...-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.

Edited by Joe Weaks, 15 September 2011 - 08:15 PM.

Joe Weaks
The Macintosh Biblioblog

Sometimes I'm so helpful even I can't stand it.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users