Ryan,<div><br></div><div>Imports and exports don't accept variables.</div><div><br></div><div>Ken<span></span><br><br>On Thursday, 20 September 2012, Ryan Powers wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I'm trying to do an import of a csv file which may vary in the number of<br>
fields it contains and their order.<br>
<br>
My approach is to use a metadata file which can also be imported. In this<br>
file, each line contains a field number that corresponds to the fields in<br>
the csv. Here is what I am doing:<br>
<br>
1. open the csv<br>
2. grab a free record<br>
3. open the metadata file<br>
4a. loop on the metadata import, and keep a count of the number of loops<br>
4b. read a metadata "record" which is a field number<br>
4c. put the value from csv field n into lookup ct.<br>
Something like this:<br>
<br>
ct(4,.0)="1"<br>
fd = metadata(1)<br>
lkup(fd) = myimport(ct); ct=ct+"1";<br>
<br>
The problem is that myimport(ct) fails the syntax check. Is there a function<br>
that I could use?<br>
<br>
Thanks.<br>
<br>
<br>
<br>
---<br>
Ryan Powers<br>
Bulldog Software, Inc.<br>
<a href="http://www.bulldogsoftware.com" target="_blank">http://www.bulldogsoftware.com</a><br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="javascript:;" onclick="_e(event, 'cvml', 'Filepro-list@lists.celestial.com')">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</blockquote></div>