elton.andrew wrote:
> Hi, I wrote a code to format a triple (subject predicate object) text
> file in a way that is importable by MySql. The problem is that, in
> some of the triples, the object portion consists of words separated by
> spaces; therefore, instead of my the entire words to be inputed as a
> single string, only the first word is inputed and the remaining words
> gets converted into series of SPO's (subject, object, predicate).
> Kindly help with what I could do to store the object portion as a
> single string in as much as they are on the same line.
>
> The codes and data sample is pasted below
>
>
> Code
>
> // rdef.cpp : Defines the entry point for the console application.
> //
>
> #include "stdafx.h"
> #include <iostream>
> #include <fstream>
> #include <string>
> using namespace std;
>
> int _tmain(int argc, _TCHAR* argv[])
> {
> string s, p, o;
> char inLine[500];
>
> //opening input and output files
> ifstream inFile("c:\\rdfp\\tst.txt");
> ofstream outFile("c:\\rdfp\\out.txt");
>
> if(!inFile.fail()) {
>
> while(!inFile.eof()) {
> //reads subject, predicate and object
> inFile >> s ;
> inFile >> p ;
> inFile >> o ;
>
> //outputs subject predicate and object in mysql
> importable format
> //into the output file
>
> outFile << "insert into rdf_triple values (";
> outFile << "\"" << s << "\"" << ",";
> outFile << "\"" << p << "\"" << ",";
> outFile << "\"" << o << "\"";
> outFile << ");" << endl;
>
> }
>
> cout << "Output written to file successfully \n\n";
>
> inFile.close();
> outFile.close();
> } else
> cout << "Error Opening File.";
>
> system("PAUSE");
> return 0;
> }
>
>
> Data sample
>
> <#sd> <http://www.w3.org/2000/01/rdf-schema#comment> ResearchCyc
> Ontology OpenCyc License Information\n The contents
> of this file constitute portions of The OpenCyc\n Knowledge
> Base. The OpenCyc Knowledge Base is protected\n under the following
> license and copyrights. This license and\n copyright information
> must be included with any copies.
>
>
> Note: Here <#sd> will be stored as SUBJECT,
> <http://www.w3.org/2000/01/rdf-schema#comment> will be stored as
> PREDICATE, while I want "ResearchCyc
> Ontology OpenCyc License Information\n The contents
> of this file constitute portions of The OpenCyc\n Knowledge
> Base. The OpenCyc Knowledge Base is protected\n under the following
> license and copyrights. This license and\n copyright information
> must be included with any copies" stored as OBJECT
Read everything in as a line and then process it.
Various scripting languages are better suited for writing quickie
programs that parse data and load a database.
Be careful. If any 'Object's contain unescaped quotes then your SQL
statements will be broken.
--
Thomas Hruska
CubicleSoft President
Ph: 517-803-4197
*NEW* MyTaskFocus 1.1
Get on task. Stay on task.
http://www.CubicleSoft.com/MyTaskFocus/
