Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #441

Re: Import File.....

Show all headers | 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