Author Topic: Is there an easy way to make dat files from a spreadsheet?  (Read 2775 times)

0 Members and 1 Guest are viewing this topic.

Offline ӔO

  • Devotee
  • *
  • Posts: 2345
  • Total likes: 2
  • Helpful: 66
  • Hopefully helpful
  • Languages: en, jp
Is there an easy way to make dat files from a spreadsheet?
« on: June 04, 2012, 07:44:51 AM »
per the title.

I am using OO calc.

I have columns for each value and rows for each object.
My Sketchup open project sources
various projects rolled up: http://dl.dropbox.com/u/17111233/Roll_up.rar

Colour safe chart:

Offline prissi

  • Developer
  • Administrator
  • *
  • Posts: 8865
  • Total likes: 337
  • Helpful: 230
  • Languages: De,EN,JP
Re: Is there an easy way to make dat files from a spreadsheet?
« Reply #1 on: June 04, 2012, 10:17:21 AM »
sed on a csv file can certainly do the trick.

Offline ӔO

  • Devotee
  • *
  • Posts: 2345
  • Total likes: 2
  • Helpful: 66
  • Hopefully helpful
  • Languages: en, jp
Re: Is there an easy way to make dat files from a spreadsheet?
« Reply #2 on: June 04, 2012, 07:30:04 PM »
thanks prissi, will definitely try it out.
My Sketchup open project sources
various projects rolled up: http://dl.dropbox.com/u/17111233/Roll_up.rar

Colour safe chart:

Offline Fabio

  • Devotee
  • Administrator
  • *
  • Posts: 2898
  • Total likes: 7
  • Helpful: 91
  • The Pak128 Guy
    • Visit me on Facebook
  • Languages: EN, IT, RO, FR
Re: Is there an easy way to make dat files from a spreadsheet?
« Reply #3 on: June 04, 2012, 09:03:43 PM »
What is sed? A typo or a program? Sorry for my being ignorant...

Offline DirrrtyDirk

  • Devotee
  • *
  • Posts: 1253
  • Total likes: 1
  • Helpful: 11
  • JR 700 Series Shinkansen
  • Languages: EN,DE
  
***** PAK128 Dev Team - semi-retired*****

Offline Fabio

  • Devotee
  • Administrator
  • *
  • Posts: 2898
  • Total likes: 7
  • Helpful: 91
  • The Pak128 Guy
    • Visit me on Facebook
  • Languages: EN, IT, RO, FR
Re: Is there an easy way to make dat files from a spreadsheet?
« Reply #5 on: June 04, 2012, 09:29:34 PM »
Thanks a lot, never heard of it before.

Is there any Windows equivalent? It could also be done programmatically, but it would mean creating a new tool from scratch...

Offline ӔO

  • Devotee
  • *
  • Posts: 2345
  • Total likes: 2
  • Helpful: 66
  • Hopefully helpful
  • Languages: en, jp
Re: Is there an easy way to make dat files from a spreadsheet?
« Reply #6 on: June 04, 2012, 09:46:37 PM »
My Sketchup open project sources
various projects rolled up: http://dl.dropbox.com/u/17111233/Roll_up.rar

Colour safe chart: