Loading ...
Sorry, an error occurred while loading the content.

6748CSV to STK

Expand Messages
  • westerman@chanuteks.com
    Jul 1, 2001
      I have a cabinet design software that outputs the following CSV file
      for the parts needed to build the cabinet. This represent 7 of the
      parts. There are actually many more.


      "APS Fleet","APS FLEET","1-12","1","28","29","28","29","BACK","1/2
      MELAMINE-2
      SIDES","","","","","","","","","","","","","","","","","","","Length",
      "071T05Y0","","","","","",""
      "APS Fleet","APS FLEET","1-9","1","28","26","28","26","BACK","1/2
      MELAMINE-2
      SIDES","","","","","","","","","","","","","","","","","","","Length",
      "071T0410","","","","","",""
      "APS Fleet","APS FLEET","1-10","1","28","26","28","26","BACK","1/2
      MELAMINE-2
      SIDES","","","","","","","","","","","","","","","","","","","Length",
      "071T04Z0","","","","","",""
      "APS Fleet","APS FLEET","1-
      12","1","4","27.5","4","27.5","NAILERS","1/2 MELAMINE-2
      SIDES","","","","","","","","","","","","","","","","","","","Length",
      "071P05X0","","","","","",""
      "APS Fleet","APS FLEET","1-
      12","1","4","27.5","4","27.5","NAILERS","1/2 MELAMINE-2
      SIDES","","","","","","","","","","","","","","","","","","","Length",
      "071P0600","","","","","",""
      "APS Fleet","APS FLEET","1-
      7","1","23","46.5","22.97","46.5","FLOOR","3/4 MELAMINE-2
      SIDES","1L","Front","1 mm 15/16 PVC Edg
      Bnd","0.03","","","","","","","","","","","","","","","Length","072H03
      10","","","","","",""
      "APS Fleet","APS FLEET","1-
      7","1","23","46.5","22.97","46.5","FLOOR","3/4 MELAMINE-2
      SIDES","1L","Front","1 mm 15/16 PVC Edg
      Bnd","0.03","","","","","","","","","","","","","","","Length","072N03
      20","","","","","",""

      I need a clip that will create two or more new files from a sorting
      of the data in cell 10. In this case cell 10 is 1/2 MELAMINE-2 SIDES
      for some parts and 3/4 MELAMINE-2 SIDES for other parts. There may be
      as many as 6 different materials listed in cell 10.

      After the clip sorts this into two or more new files, the files need
      to be named from the first 6 characters of the data in cell 1 and two
      numbers starting with 01. Thus, file one would be APSFLE01.STK, file
      two would be APSFLE02.STK, etc. STK files go directly into another
      software that optimizes the parts layout on a sheet of material to
      get the best yield.

      Then each of these two or more files would need to be reformated into
      the following STK format. Only data from cell 4,7,8 and 9 to be used.
      The rest is discarded.


      first file


      [ISTK-1]
      L=28.00 ;7th piece of data
      B=29.00 ;8th piece of data
      A=1 ;4th piece of data
      REF=BACK ;9th piece of data
      [ISTK-1]

      [ISTK-2]
      L=28.00
      B=26.00
      A=1
      REF=BACK
      [ISTK-2]

      [ISTK-3]
      L=28.00
      B=26.00
      A=1
      REF=BACK
      [ISTK-3]

      [ISTK-4]
      L=4.00
      B=27.5
      A=1
      REF=NAILERS
      [ISTK-4]

      [ISTK-5]
      L=4.00
      B=27.5
      A=1
      REF=NAILERS
      [ISTK-5]


      second file


      [ISTK-1]
      L=22.97
      B=46.5
      A=1
      REF=FLOOR
      [ISTK-1]

      [ISTK-2]
      L=23.25
      B=46.5
      A=1
      REF=FLOOR
      [ISTK-2]


      Then each to be saved.

      Is this something within the abilities of a NoteTab clip? Or should I
      seek other software to do this? I spend several hours retyping data
      from one software into another each week.

      Thanks

      Craig ><>
      westerman@...
    • Show all 2 messages in this topic