2 Replies Latest reply: May 29, 2012 6:32 AM by Cosman
Cosman Level 1 Level 1
expertise.macosx
Mac OS X

I get datalogger files every night that come in the .dat format.  I need to process them in OpenOffice.calc to show the results.  OO.calc will not read a .dat file, but if I manually change the .dat to .csv it works fine.

 

I don't know enough about Automator to write the script.  Doing it by record doesn't work.

 

Can anyone point me in the right direction?

 

Thanks


MacBook Pro, Mac OS X (10.7.3), I7, 8GB, 750GB, Lion
Solved by red_menace on May 28, 2012 10:18 PM Solved

You can use the Rename Finder Items action to rename the input items, using either Name Single Item or Replace Text for the extension (note that the extenson does not include the period) - for example:

 

  1. Ask for Finder Items { Type: files } Allow Multiple Selection
  2. Rename Finder Items - Replace Text { Find: dat in extension only  Replace: csv }
  • red_menace Level 6 Level 6
    expertise.desktops
    Desktops

    You can use the Rename Finder Items action to rename the input items, using either Name Single Item or Replace Text for the extension (note that the extenson does not include the period) - for example:

     

    1. Ask for Finder Items { Type: files } Allow Multiple Selection
    2. Rename Finder Items - Replace Text { Find: dat in extension only  Replace: csv }
  • Cosman Level 1 Level 1
    expertise.macosx
    Mac OS X

    OK, I got it to work. Thank you very much.