CSV file properties

Hi Folks,
I am working in Qlab. I would like to save a cue list in CSV file. It is not problem.
But the output file coding, that is the problem.
The Csv file do not contains the Hungarian characters (öő, üű, etc) on the right way.
Is there a special save command to format the character table to Hungarian?
I mean have to set a property before save the file.
Enclosing a sample code I use to save.

		set targetFile to targetFile as text
		set openFile to open for access file targetFile with write permission
		if apendData is false then set eof of openFile to 0
		write theData to openFile starting at eof as dataType
		close access openFile

Any help? Thanks a lot in advance.
Sincerely
Kalman

A couple of questions:

Can you provide an example line of the improper output and also as it should be?

Also, what is the value of dataType?

Finally, are you hoping to use utf-8 encoding or latin-2 (ie ISO-8859-2)?

I don’t know whether the write command can work directly with latin-2 but it can save with utf-8 encoding. Replace ‘as dataType’ with this:

 as «class utf8»

The old satimage addition can with its writetext command

Well, this is the screenshot I take to present my problem.


Hope you can watch the picture. I marked red the problematic situation.
Well, the “belsoy” word correctly in Hungarian langauge “belső”. But I not sure you can read the Hungarian characters. Hopefully yes. The next word is “LAKcs”, in Hungarian word is “LAKÁS” (flat).
I give you the full vowel list, a-á, i-í, o-ó, ö-ő, u-ú, ü-ű. We call them short and long vowel.
Hopefully that’s clean.
Thank you if you can give me idea to use CSV file correctly in Hungarian language.

Sincerely,
Kalman

Hi Mockman,

I checked your advice.
And IT IS WORKING! YEAH

Thanks
Kalman

1 Like

I’m glad it worked out. In general, when there is an encoding issue, try and see if utf-8 works. It has all of the characters that would be used in any of the latin scripts.