We have research-publications/Article data from Thomson Reuters, in raw "Tagged Format", where the data is in two columns the first column (2-characters) is the TAG, then and then the data.
TI The Religious Identity of the Arabic Language and the Affair of the Lead Books of the Sacromonte of Granada
AB This article deals, in the first place, with the religious identity of the Arabic language as defined by the ongoing debate, in 16th-17th century Spain, about its identification with Islam. Many new Christians of Muslim origin (Moriscos) tried to break this identification in an effort to salvage part of their culture, and specially the language, by separating it from Islam. I will argue that the Morisco forgery known as the Lead Books of the Sacromonte in Granada-an Arabic Evangile dictated by the Virgin Mary to Arabic disciples who came to Spain with the Apostle Saint James-was part of this effort. When the Lead Books were taken to the Vatican to be informed, they were studied by Maronite scholars who decided that they were written in "Muslim Arabic" and therefore could not be authentic Christian texts. The Maronites were engaged in creating and consolidating their own version of Christian Arabic to define and legitimise their own position inside the Roman world. The second part of the essay adresses the theological considerations and the defence of different cultural identities which are implied in these different versions of Arabic.
AU Garcia-Arenal, M
RO Author, Reprint Author
UT: is the Article-ID-Number
TI: Article Title
AU: is the Article Author.
RO: Role of the person in AU.
LN: Author Last name
AF: first Name
and so on....
What is the best way to convert this TAGGED data into two tables:
Table#1: with Article/Publication data with UT, TI, AB ..etc as column headers
Table#2: with AU, RO, LN, AF, ...ect as column headers and a foreign key to table#1
Thank you so much,