3 replies to this topic

[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

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

 Picture 2011-09-14 at 12.09.31 PM.png   71.44K   27 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?

[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

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

 Picture 2011-09-14 at 12.09.31 PM.png   71.44K   27 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!

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