Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #441

Re: Import File.....

Path csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail
From cortical <cb@corticaldata.com.au>
Newsgroups comp.databases.filemaker
Subject Re: Import File.....
Date Thu, 20 Oct 2011 22:17:30 +1030
Organization Aioe.org NNTP Server
Lines 34
Message-ID <j7p1oi$54q$1@speranza.aioe.org> (permalink)
References <3257baec-294c-48fb-909e-4545faaa7a2a@v7g2000yqf.googlegroups.com> <j7nsp3$gkc$1@speranza.aioe.org> <yourname-2010111610170001@203-118-185-53.dsl.dyn.ihug.co.nz>
NNTP-Posting-Host lbqHkD4xQK0e6CF8nY31PQ.user.speranza.aioe.org
Mime-Version 1.0
Content-Type text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding 7bit
X-Complaints-To abuse@aioe.org
User-Agent Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1
X-Notice Filtered by postfilter v. 0.8.2
Xref x330-a1.tempe.blueboxinc.net comp.databases.filemaker:441

Show key headers only | View raw

On 20/10/11 1:40 PM, Your Name wrote:
> In article<j7nsp3$gkc$1@speranza.aioe.org>, cortical
> <cb@corticaldata.com.au>  wrote:
>>
> <snip>
>>
>> Do not expect the column that holds the cost price in the initial spread
>> sheet rows, to hold the same data all the way down... If ever there was
>> a market niche that really needed database, it is those who assemble
>> price lists.
>
> Even when price lists are done on a database, they have to be exported to
> something compatible with other systems, which usually means either a TXT
> or CSV file ... and often the CSV file defaults to opening with Excel so
> is seen as a spreadsheet when it really isn't.
>
> Helpful Haryy  :o)

Missing the point Harry. It is common form some sources, that in the 
same price list spreadsheet, some product rows are 5 column, some 6 
column, some 7 column

They merge different fields... the 6th column in one row may be the cost 
price, in another category of product, it might be the 5th becuse 3 and 
4 have been merged,  so as imports use the standard delimiter of tab for 
field, pilcrow for record, a compression occurs, the merged fields are 
seen as single fields


c1 c2 c3 c4 c5  >> f1 f2 f3 f4 f5
c1 (c2 c3) c4 c5  >> c2 in f2, c4 in f3, c5 in f4

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Import File..... JayBee <Jennifer_Beecroft@hotmail.com> - 2011-10-19 15:12 -0700
  Re: Import File..... yourname@yourisp.com (Your Name) - 2011-10-20 13:21 +1300
  Re: Import File..... cortical <cb@corticaldata.com.au> - 2011-10-20 11:46 +1030
    Re: Import File..... yourname@yourisp.com (Your Name) - 2011-10-20 16:10 +1300
      Re: Import File..... cortical <cb@corticaldata.com.au> - 2011-10-20 22:17 +1030
        Re: Import File..... yourname@yourisp.com (Your Name) - 2011-10-21 09:14 +1300
          Re: Import File..... JayBee <Jennifer_Beecroft@hotmail.com> - 2011-10-24 15:07 -0700
  Re: Import File..... Martin Ī¤rautmann <t-usenet@gmx.net> - 2011-10-20 04:41 +0000

csiph-web