How to remove footnote indicators from exported search results? (Or is this a BUG)
I frequently export Bible search results to a csv file to analysis. However, I just exported a search out of L10 and I have all these extra characters that are the footnote indicators from the biblical text. This means I have to manually clean up nearly every verse in the export because it has random numbers and letters in the text. I never had this issue in L9. Does anyone know how to fix this? Or is this a bug?
Comments
-
Hi Samuel--Thanks for the note and sorry for the trouble. We'll look into this, but it would be helpful to have a few more details. Are you on mac or windows? What bible(s) are you searching? What view are you exporting (e.g. analysis? grid?). Can you provide an example of a search where you have this issue?
Thanks,
-Ronny
0 -
Hi Samuel--Thanks for the note and sorry for the trouble. We'll look into this, but it would be helpful to have a few more details. Are you on mac or windows? What bible(s) are you searching? What view are you exporting (e.g. analysis? grid?). Can you provide an example of a search where you have this issue?
Thanks,
-Ronny
I'm on a Mac. In this case I ran the search "command:type:*Command* INTERSECTS speaker:Jesus" as a Bible search on the ESV. First I tried to export from the normal passages view and got the message "This panel does not support printing or exporting yet." I don't remember that in the past, but maybe it was always like that. So then I tried to export from the Grid view of the search and the results looked like this:
You can see, for example, on the second result that the footnote indicators are there and they are in the exported file (in this case a csv) so you cannot use any of the search results without cleaning up nearly every verse. In version 9 these footnote indicators were not there and I never had to do this before.
0 -
Great thanks Samuel. Just compared this to L9 and I actually don't believe the footnote indicators are new. What's happening is that if a footnote is part of a hit, we show it in the search results (and also include it in the export). So, just as proof of concept, if you search for "to the test" in the ESV I believe you'll note that the export does not include the footnote indicator on Mt 4:7 (not that this helps you right now). Something that might help...instead of using print/export from the "kebab" menu, maybe you could save as a passage list, and then export from there. CSV is not an option at that point, so this also may not be helpful depending on your use case. But hoping some of the other passage list export options are helpful for you?
I'll also go ahead and make sure the product team has visibility to this. While the footnote indicators inside of search hits is nothing new, I'm actually not certain whether or not they're desired, so perhaps there is more to come on this front.
Thanks,
-Ronny
0 -
Great thanks Samuel. Just compared this to L9 and I actually don't believe the footnote indicators are new. What's happening is that if a footnote is part of a hit, we show it in the search results (and also include it in the export). So, just as proof of concept, if you search for "to the test" in the ESV I believe you'll note that the export does not include the footnote indicator on Mt 4:7 (not that this helps you right now). Something that might help...instead of using print/export from the "kebab" menu, maybe you could save as a passage list, and then export from there. CSV is not an option at that point, so this also may not be helpful depending on your use case. But hoping some of the other passage list export options are helpful for you?
I'll also go ahead and make sure the product team has visibility to this. While the footnote indicators inside of search hits is nothing new, I'm actually not certain whether or not they're desired, so perhaps there is more to come on this front.
Thanks,
-Ronny
I export to csv all the time so unfortunately that workaround won't work. I see what you mean that only some searches include footnotes in the hit. Any reason why meta data searches against Bible text are also searching against footnotes? If searches are going to run against footnotes I would think this should be an option to include footnote text. I've even tried setting the search to "surface text" but it seems certain kind of searches still include footnotes.
0 -
It isn't that it's searching and finding a hit in the footnote, it's just that when a single hit in the surface text encompasses a footnote indicator, we are showing (and exporting) the footnote indicator in the search result. Have elevated this and it may be something that we address at some point, but I don't yet have all the context for why it works the way it currently does (which it's at least been doing since L9; perhaps before then).
Here's a (rather annoying) work-around you might consider (others may have better ideas, but this is the best I can come up with so far) for now if your search has a bunch of unwanted footnote indicators in the results:
- Save the results as a passage list
- Come back to bible search in the search panel, and in the reference picker select the passage list you just created
- Now just search for wildcard (i.e. search "*" without the quotes)
- Select grid view, and export to csv
This works because when you search wildcard, each word is a separate hit, so no single hit overlaps a footnote indicator.
Not ideal I know, but hope it helps, at least in the short-term.
0 -
It isn't that it's searching and finding a hit in the footnote, it's just that when a single hit in the surface text encompasses a footnote indicator, we are showing (and exporting) the footnote indicator in the search result. Have elevated this and it may be something that we address at some point, but I don't yet have all the context for why it works the way it currently does (which it's at least been doing since L9; perhaps before then).
Here's a (rather annoying) work-around you might consider (others may have better ideas, but this is the best I can come up with so far) for now if your search has a bunch of unwanted footnote indicators in the results:
- Save the results as a passage list
- Come back to bible search in the search panel, and in the reference picker select the passage list you just created
- Now just search for wildcard (i.e. search "*" without the quotes)
- Select grid view, and export to csv
This works because when you search wildcard, each word is a separate hit, so no single hit overlaps a footnote indicator.
Not ideal I know, but hope it helps, at least in the short-term.
Thank you for elevating it. I'm not sure why I haven't run into this before because I export a lot of searches to csv for analysis. And, obviously, in an export the footnote indicators are meaningless and just clutter the results.
0