importusing

[Jay Schille]

You probably already know this, but just in case, 
importcell(0) refers to the first chunk of comma- 
or tab-separated data in a text file, and 
importcell(1) is actually the second chunk. So 
your importusing formula ignores the first chunk 
and every chunk after the 13th when importing.

>>
>>
>>On Feb 4, 2008, at 6:45 20AM, Barry Kahn wrote:
>>
>>>I'm venturing into new territory for me and need help as usual.
>>>
>>>I have a tab-delimited text file which I want 
>>>to bring into an existing pan database. The 
>>>text file has some extra fields which I don't 
>>>need. I've been using the text import wizard 
>>>to do this till now and it works perfectly, 
>>>but now I'd like to automate the process.
>>>
>>>So I've created a .Initialize procedure (my 
>>>first time to try this also, very exciting!) 
>>>which begins with this:
>>>
>>>importusing
>>>importcell(1)+ ¬ +
>>>importcell(2)+ ¬ +
>>>importcell(4)+ ¬ +
>>>importcell(5)+ ¬ +
>>>importcell(6)+ ¬ +
>>>importcell(7)+ ¬ +
>>>importcell(8)+ ¬ +
>>>importcell(9)+ ¬ +
>>>importcell(10)+ ¬ +
>>>importcell(11)+ ¬ +
>>>importcell(12)+ ¬ +
>>>
>>>openfile "&Dell_shared:bin_locs_etc.txt"
>>>
>>>As far as I can tell when I run this, the 
>>>procedure is ignoring the importcell part and 
>>>just bringing in the text file unchanged. Or 
>>>it's doing the importcell part, and then 
>>>overwriting it when it hits openfile etc.
>>>
>>>I noticed in the Pan documentation that the 
>>>example shows comma delimited fields. Does 
>>>this make any difference? Also do I need to do 
>>>anything special about the fields in the text 
>>>file that I don't need, or does importusing 
>>>automatically skip them if they are not listed?
>>>
>>>Thanks!
>>>bk
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>Barry Kahn
>>>Caravan Beads, Inc.
>>>915 Forest Ave
>>>Portland ME 04103
>>>800-230-8941
>>>fax: 207-874-2664
>>><http://www.caravanbeads.net>www.caravanbeads.net
>>><mailto:barryk at caravanbeads.net>barryk at caravanbeads.net
>>>
>>>
>>>
>>>
>>>
>>>_______________________________________________
>>>Qna mailing list
>>><mailto:Qna at provue.com>Qna at provue.com
>>><http://provue.com/mailman/listinfo/qna>http://provue.com/mailman/listinfo/qna
>>>
>>
>>Peter Guerrini
>><mailto:peterg at sonic.net>peterg at sonic.net
>>
>>
>>
>>_______________________________________________
>>Qna mailing list
>><mailto:Qna at provue.com>Qna at provue.com
>>http://provue.com/mailman/listinfo/qna
>>
>
>
>_______________________________________________
>Qna mailing list
>Qna at provue.com
>http://provue.com/mailman/listinfo/qna


-- 
Jay Schille
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://provue.com/pipermail/qna/attachments/20080204/6d5e893d/attachment.html