importusing

[Barry Kahn]

I did eventually spot that in the docs, but given my programming  
skills—which barely touch the beginner level when I really  
concentrate and get lucky, too—it is always safer to tell me things  
that seem obvious. More often than not I won't know it.

thanks,
bk


On Feb 4, 2008, at 12:51 PM, Jay Schille wrote:

> 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
>>>> www.caravanbeads.net
>>>> barryk at caravanbeads.net
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Qna mailing list
>>>> Qna at provue.com
>>>> http://provue.com/mailman/listinfo/qna
>>>
>>> Peter Guerrini
>>> peterg at sonic.net
>>>
>>>
>>>
>>> _______________________________________________
>>> Qna mailing list
>>> 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
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna

Barry Kahn
Caravan Beads, Inc.
915 Forest Ave
Portland ME 04103
800-230-8941
fax: 207-874-2664
www.caravanbeads.net
barryk at caravanbeads.net





-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://provue.com/pipermail/qna/attachments/20080204/9fb02869/attachment.html