2 Replies Latest reply: May 29, 2012 6:32 AM by Cosman
Cosman Level 1 (10 points)

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?



MacBook Pro, Mac OS X (10.7.3), I7, 8GB, 750GB, Lion
  • red_menace Level 6 (15,120 points)

    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 (10 points)

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