Hi I hope someone can help me. I have a txt file (copy of a small portion of it below) that I need to be able to output into a database. I'm reading it via cffile but am unsure how to get it into a useable format ie delimiters etc The letters before the pipe are column headings (that's prob obvious)
If anyone could help I would be grateful. UR|BC51 AA| AI| TI|MARG - A MAGAZINE OF THE ARTS. Appreciation of the Creative TI|Arts under Maharaja Ranjit Singh. PU|Oxford University Press PP|Sydney DP|n.d. NT|Colour and b/w plates, including some folding, 93pp, 4to, NT|light soiling boards, a good copy. NT|Articles on the arts during the reign of Maharaja Ranjit NT|Singh. ED| BD| PR|35.00 KE|Art KE|India KE|Periodical KE|South Asia XA|4 XB|1 XC|BO XD|S UR|BC117 AA|`ABD AL-LATIF AL-BAGHDADI. AI| TI|The Eastern Key. Kitab Al-Ifadah Wa'l-I`Tibar. PU|Allen and Unwin. PP| DP|1965. NT|Trans. 293pp, index, biblio., Arabic and English text, covers NT|trifle flecked and worn. NT| ED| BD| PR|35.00 KE|Biography KE|Middle East KE|Philosophy KE|Science XA|4 XB|1 XC|BO XD|S UR|BC1147 AA|BARTLETT, ANDERSON G. ET. AL. AI| TI|Pertamina. Indonesian National Oil. PU|Amerasian. PP|Djakarta. DP|n.d. (c.1972). NT|Endpaper maps, ill, xi + 420pp, appendices, selected NT|biographies, biblio, index, d/j little worn, nice copy. NT|History of Pertamina, including chapters on 1965 coup, the NT|New Order, and negotiations with multinational companies. ED| BD| PR|40.00 KE|Economics KE|History KE|Politics KE|South East Asia XA|4 XB|1 XC|BO XD|S ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists