Scripts and Apache Open Office

[g_steinberg]

I was wondering if anyone has tried and been successful with writing and uploading scripts to your 18R2 using open office? No matter what I do, I always end up getting every error code except, 3, 23 and 24.
I'm sure i'll have to end up buying Microsoft office but thought I'd check and see if any of you have a quick solution.
Thanks!!

[cduesman]

OpenOffice is likely putting Quotes around fields where Microsoft does not. Cobra is not expecting these quotes and gives you an error.

For example: OpenOffice will create a .csv like:
"#Trigger Channel","#Trigger Button","#Confirmation Button","#Return Channel"
0,1,,0
"#Event Time","Channel","Cue","Description"
"0:00:00.0s",1,1,
"0:00:15.0s",1,2,
"0:00:30.0s",1,3,
"0:00:45.0s",1,4,
"0:01:00.0s",1,5,
"0:01:15.0s",1,6,

and Microsoft will look like this:

#Trigger Channel,#Trigger Button,#Confirmation Button,#Return Channel
0,1,,0
#Event Time,Channel,Cue,Description
0:00:00.0s,1,1,
0:00:15.0s,1,2,
0:00:30.0s,1,3,
0:00:45.0s,1,4,
0:01:00.0s,1,5,
0:01:15.0s,1,6,


If you have notepad (or gedit if using Linux), you can open the .csv and do a find/replace to get rid of the quotes. Depending on what version of OpenOffice, I'm not sure if there's an easy way to change it's behavior. If you google "OpenOffice csv quotes" you'll see some hits. Some mention a Filter option but they don't seem easy.

Chris

[g_steinberg]

Thank You Chris!! That was very helpful! I'll look into that and see if I can find a way around it.