<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head profile="http://internetalchemy.org/2003/02/profile">
<link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" />
<link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" />
<meta name="dc.title" content="Function: get_csv_row - Virtuoso Functions Guide" />
<meta name="dc.subject" content="Function: get_csv_row - Virtuoso Functions Guide" />
<meta name="dc.creator" content="OpenLink Software Documentation Team ; " />
<meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" />
<link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" />
<link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" />
<link rel="parent" href="functions.html" title="Chapter Contents" />
<link rel="prev" href="appendixa.html" title="Appendix" />
<link rel="next" href="functions.html#.html" title="" />
<link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" />
<link rel="stylesheet" type="text/css" href="doc.css" />
<link rel="stylesheet" type="text/css" href="/doc/translation.css" />
<title>Function: get_csv_row - Virtuoso Functions Guide</title>
<meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" />
<meta name="author" content="OpenLink Software Documentation Team ; " />
<meta name="copyright" content="OpenLink Software, 1999 - 2009" />
<meta name="keywords" content="" />
<meta name="GENERATOR" content="OpenLink XSLT Team" />
</head>
<body>
<div id="header">
<a name="fn_get_csv_row" />
<img src="../images/misc/logo.jpg" alt="" />
<h1>22. Virtuoso Functions Guide - get_csv_row</h1>
</div>
<div id="navbartop">
<div>
<a class="link" href="functions.html">Chapter Contents</a> | <a class="link" href="fn_gz_file_open.html" title="gz_file_open">Prev</a> | <a class="link" href="fn_csv_load_file.html" title="csv_load_file">Next</a>
</div>
</div>
<div id="currenttoc">
<form method="post" action="/doc/adv_search.vspx">
<div class="search">Keyword Search: <br />
<input type="text" name="q" /> <input type="submit" name="go" value="Go" />
</div>
</form>
<div>
<a href="http://www.openlinksw.com/">www.openlinksw.com</a>
</div>
<div>
<a href="http://docs.openlinksw.com/">docs.openlinksw.com</a>
</div>
<br />
<div>
<a href="index.html">Book Home</a>
</div>
<br />
<div>
<a href="contents.html">Contents</a>
</div>
<div>
<a href="preface.html">Preface</a>
</div>
<br />
<div>
<a class="selected" href="functions.html">Virtuoso Functions Guide</a>
</div>
<br />
<div>
<a href="functions.html#admin">Administration</a>
</div>
<div>
<a href="functions.html#aggr">Aggregate Functions</a>
</div>
<div>
<a href="functions.html#array">Array Manipulation</a>
</div>
<div>
<a href="functions.html#bpel">BPEL APIs</a>
</div>
<div>
<a href="functions.html#backup">Backup</a>
</div>
<div>
<a href="functions.html#compression">Compression</a>
</div>
<div>
<a href="functions.html#cursors">Cursor</a>
</div>
<div>
<a href="functions.html#time">Date & Time Manipulation</a>
</div>
<div>
<a href="functions.html#debug">Debug</a>
</div>
<div>
<a href="functions.html#dict">Dictionary Manipulation</a>
</div>
<div>
<a href="functions.html#encoding">Encoding & Decoding</a>
</div>
<div>
<a class="selected" href="functions.html#file">File Manipulation</a>
</div>
<div class="selected">
<div>
<a href="fn_csv_cols_def.html">csv_cols_def</a>
</div>
<div>
<a href="fn_csv_load.html">csv_load</a>
</div>
<div>
<a href="fn_csv_load_file.html">csv_load_file</a>
</div>
<div>
<a href="fn_csv_parse.html">csv_parse</a>
</div>
<div>
<a href="fn_csv_table_def.html">csv_table_def</a>
</div>
<div>
<a href="fn_file_delete.html">file_delete</a>
</div>
<div>
<a href="fn_file_dirlist.html">file_dirlist</a>
</div>
<div>
<a href="fn_file_mkdir.html">file_mkdir</a>
</div>
<div>
<a href="fn_file_mkpath.html">file_mkpath</a>
</div>
<div>
<a href="fn_file_open.html">file_open</a>
</div>
<div>
<a href="fn_file_stat.html">file_stat</a>
</div>
<div>
<a href="fn_file_to_string.html">file_to_string</a>
</div>
<div>
<a href="fn_file_to_string_output.html">file_to_string_outpu...</a>
</div>
<div>
<a href="fn_file_unlink.html">file_unlink</a>
</div>
<div>
<a class="selected" href="fn_get_csv_row.html">get_csv_row</a>
</div>
<div>
<a href="fn_gz_file_open.html">gz_file_open</a>
</div>
<div>
<a href="fn_os_chmod.html">os_chmod</a>
</div>
<div>
<a href="fn_os_chown.html">os_chown</a>
</div>
</div>
<div>
<a href="functions.html#ft">Free Text</a>
</div>
<div>
<a href="functions.html#hash">Hashing / Cryptographic</a>
</div>
<div>
<a href="functions.html#ldap">LDAP</a>
</div>
<div>
<a href="functions.html#localization">Locale</a>
</div>
<div>
<a href="functions.html#mail">Mail</a>
</div>
<div>
<a href="functions.html#misc">Miscellaneous</a>
</div>
<div>
<a href="functions.html#number">Number</a>
</div>
<div>
<a href="functions.html#phrz">Phrases</a>
</div>
<div>
<a href="functions.html#rdf">RDF data</a>
</div>
<div>
<a href="functions.html#rmt">Remote SQL Data Source</a>
</div>
<div>
<a href="functions.html#repl">Replication</a>
</div>
<div>
<a href="functions.html#soap">SOAP</a>
</div>
<div>
<a href="functions.html#sql">SQL</a>
</div>
<div>
<a href="functions.html#string">String</a>
</div>
<div>
<a href="functions.html#txn">Transaction</a>
</div>
<div>
<a href="functions.html#type">Type Mapping</a>
</div>
<div>
<a href="functions.html#uddi">UDDI</a>
</div>
<div>
<a href="functions.html#udt">User Defined Types & The CLR</a>
</div>
<div>
<a href="functions.html#vad">VAD</a>
</div>
<div>
<a href="functions.html#jvmpl">Virtuoso Java PL API</a>
</div>
<div>
<a href="functions.html#bif">Virtuoso Server Extension Interface (VSEI)</a>
</div>
<div>
<a href="functions.html#ws">Web & Internet</a>
</div>
<div>
<a href="functions.html#xml">XML</a>
</div>
<div>
<a href="functions.html#XPATH">XPATH & XQUERY</a>
</div>
<br />
<div>
<a href="functionidx.html">Functions Index</a>
</div>
<br />
</div>
<div id="text">
<h2>get_csv_row</h2>
<div class="refpurpose">This function takes a string_session containing CSV data, parses a row
and returns a vector with field values.
</div>
<div class="funcsynopsis">
<span class="funcdef">
<span class="function">get_csv_row</span>
</span>
(<span class="paramdef">in <span class="parameter">ses</span> any</span>,
<span class="paramdef">in <span class="parameter">delim</span> char</span>,
<span class="paramdef">in <span class="parameter">quote</span> char</span>);
</div>
<div class="refsect1">
<div class="refsect1title">Description</div>
<p>This function takes a string_session containing CSV data, parses a row
and returns a vector with field values.</p>
<p>Calling the function in a loop with same input will parse file line by line.</p>
<p>The function is also making a basic prediction of field types for varchar,
integer and float values, so the result data may have one of these. If come other datatype is need to be produced the caller can convert
the string using the BIF like cast sprintf_inverse and so on.</p>
</div>
<div class="refsect1">
<div class="refsect1title">Parameters</div>
<div class="refsect2">
<span class="refsect2title">ses – </span>
string_session containing CSV data
</div>
<div class="refsect2">
<span class="refsect2title">delim – </span>
Optional argument to handle tab, space delimited etc. formats.
</div>
<div class="refsect2">
<span class="refsect2title">quote – </span>
Optional argument to handle tab, space delimited etc. formats.
</div>
</div>
<div class="refsect1">
<div class="refsect1title">Return Types</div>
<p>Returns a vector with field values.</p>
</div>
<div class="refsect1">
<div class="refsect1title">Examples</div>
<a name="ex_get_csv_row" />
<div class="example">
<div class="exampletitle" />
<p>The following example prints on the Virtuoso Server console the CSV columns names:</p>
<div>
<pre class="programlisting">
SQL>create procedure my_csv (in file_name varchar)
{
dbg_obj_print(get_csv_row(file_open('tmp/MyContacts.csv')));
}
;
Done. -- 10 msec.
SQL>select my_csv('tmp/MyContacts.csv');
callret
VARCHAR
______________________
0
1 Rows. -- 10 msec.
-- and on the Virtuoso Server console will be shown:
('First Name;Last Name;Middle Name;Name;Nickname;E-mail Address;Home Street;Home City;Home Postal Code;Home State;Home Country/Region;Home Phone;Home
Fax;Mobile Phone;Personal Web Page;Business Street;Business City;Business Postal Code;Business State;Business Country/Region;Business Web Page;Busines
s Phone;Business Fax;Pager;Company;Job Title;Department;Office Location;Notes' )
</pre>
</div>
</div>
</div>
<div class="refsect1">
<div class="refsect1title">See Also</div>
<p>
<a href="fn_csv_load_file.html">csv_load_file</a>
</p>
<p>
<a href="fn_csv_load.html">csv_load</a>
</p>
<p>
<a href="fn_csv_parse.html">csv_parse</a>
</p>
<p>
<a href="fn_csv_cols_def.html">csv_cols_def</a>
</p>
<p>
<a href="fn_csv_table_def.html">csv_table_def</a>
</p>
</div>
</div>
<div id="footer">
<div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div>
<div id="validation">
<a href="http://validator.w3.org/check/referer">
<img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" />
</a>
<a href="http://jigsaw.w3.org/css-validator/">
<img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" />
</a>
</div>
</div>
</body>
</html>
distrib
>
Fedora
>
14
>
x86_64
>
media
>
updates
>
by-pkgid
>
71d40963b505df4524269198e237b3e3
>
files
>
293
