Export Table to CSV or Similar

This topic has 3 replies, 3 voices, and was last updated 2 years, 1 month ago by Michael Gainey.

Creator

Topic
November 2, 2022 at 5:16 pm #120045
Michael Gainey
Participant
Would anyone have a tcl script or other method for exporting tables from Cloverleaf, or for updating the table files outside the UI to format for input to Excel/equivalent. A clean CSV as a result would be great.

I have been using a series of regular expressions in Notepad++ to find/replace but would love a cleaner process. Or even a single regular expression that would do the whole thing.

Thanks!
Creator

Topic

Viewing 2 reply threads

Author

Replies
- November 3, 2022 at 4:33 am #120046
  Dirk Engels
  Participant
  Hi Michael,
  
  the attached zip archive has two tcl scripts for converting a Cloverleaf table into a csv file and a csv file into a cloverleaf table. The csv file should have/will be created with 2 columns.
  
  Just start it with hcitcl and give it the file as an argument:
  
  hcitcl create_tbl.tcl wardcodes.csv
  
  hcitcl create_CSV_from_tbl.tcl wardcodes.tbl
  
  Both scripts create the resulting file in the same directory where the original file is.
  
  Attachments:
  You must be logged in to view attached files.
- November 3, 2022 at 6:33 am #120049
  James Cobane
  Participant
  I have also attached a couple of scripts to import & export a Cloverleaf table from/to a text file. The scripts prompt you for your input/output file/table names.
  
  Regards,
  
  Jim Cobane – Henry Ford Health
  
  Attachments:
  You must be logged in to view attached files.
- November 3, 2022 at 8:24 am #120051
  Michael Gainey
  Participant
  Excellent. Thank you both for the quick return! I’ll give these a try.
Author

Replies

Viewing 2 reply threads

You must be logged in to reply to this topic.