MobileRead Forums - View Single Post

revjoe · 02-05-2014, 06:32 PM

Yeah, I have a separate library for periodicals as well. As for it being one author, what I gave was just an example. For some stats:

Total record: 3096
Total Authors: 312
Affected Authors * : 31
Affected Books *: 441

Affected books have either "and" or "&" in the Author field, thus being split into separate authors. Compounding matters, many share words, so I have an author "Muscle" that can reflect back to several different periodicals.

So I have about 10% of my authors being affected, and about 14% of my total records. Hence the question.

I was hoping I could do something like prepend a " ' " the way excel does in order to make the column as text, or add a " \ " to the " & " character to have it avoid being split upon. I will have to go back and examine whether changing the split fields will end up doing more hard than good.

Thanks for the input everyone.

02-05-2014, 06:32 PM	#6
revjoe Junior Member Posts: 5 Karma: 10 Join Date: Jul 2011 Device: none	Yeah, I have a separate library for periodicals as well. As for it being one author, what I gave was just an example. For some stats: Total record: 3096 Total Authors: 312 Affected Authors * : 31 Affected Books *: 441 Affected books have either "and" or "&" in the Author field, thus being split into separate authors. Compounding matters, many share words, so I have an author "Muscle" that can reflect back to several different periodicals. So I have about 10% of my authors being affected, and about 14% of my total records. Hence the question. I was hoping I could do something like prepend a " ' " the way excel does in order to make the column as text, or add a " \ " to the " & " character to have it avoid being split upon. I will have to go back and examine whether changing the split fields will end up doing more hard than good. Thanks for the input everyone.