How can I customize the list of available text qualifiers

[Anonymous]

I work with some unusual text qualifiers that are not in the list. How can I customize the list of available text qualifiers? Is there a config file somewhere?

Thanks,
Russ

[Bruce Martin]

You can specify other values for the field separator in the field to the right of the Field separator Combo box (either a single character or a hex character).

At the moment you can not update the default list and I am unwilling to rush this into the next version.
I will add it in after that (probably as an upgrade version i.e. updated jar files but no installer). I would suggest 4 to 6 week time line.

Bruce

[Anonymous]

Thanks, I was asking about the Quote Character. The list shows only the following:
<None>
<Defualt>
"
'
`

I need a way to use other chars - unlike the separator option, I see no place to enter other chars

Thanks

[Bruce Martin]

The latest version 0.95d (https://sourceforge.net/projects/recsveditor/files/reCsvEditor/Version_0.95d/) has a Quote-Text field like the Field-Seperator or you could wait till next week when I have a version 0.96E ready (with installers) available.

See attached screen print

[Anonymous]

Got it - thanks - I look forward to .96E

Thanks again!

[Bruce Martin]

Version 0.96e which also has the Quote Text Field is now available:

• https://sourceforge.net/projects/recsveditor/files/reCsvEditor/Version_0.96e/

[Anonymous]

Hi Bruce,
The Export (csv) window doesn't have the same alternative Delimiter or Quote Text field as the Open file window. Is it possible to add that? Just like the OP, we used a special character as Delimiter (ASCII 20) and Quote (ASCII 254) and they are not available in the drop down list.

And if possible, having "Uncheck All Fields" and "Check All Fields" buttons in the Export CSV windows will be great, as we often need to export a couple fields out of 200 fields, so unchecking all the other 190 fields are just painful :).

Thank you!!!

[Bruce Martin]

Ok, I will look at adding this in

[Sean]

Thanks Bruce!!! SO GLAD I FOUND YOUR SOFTWARE..

It will be great if I can add the Delimiter (ASCII 20) and Quote (ASCII 254) to the dropdown list so I don't need to enter them every time, as they are non-printable characters and hard to enter on keyboard. Even better if I can make them the default delimiter and quote characters to use!

Thanks again!

[Bruce Martin]

I will look at doing this

[Bruce Martin]

Version 0.98.1 is out:

• https://sourceforge.net/projects/recsveditor/files/reCsvEditor/Version_0.98.1/

Changes implemented:

• You can update the lists for Delimiters and quotes:
  • Select Edit >>> Edit Properties drop down menu
  • Select Csv tab on the left
  • Select the appropriate tab at the top.
• Added the options to select / deselect all fields in CSV / Fixed export
• You can now enter Delimiter's/Qotes is unicode form (i.e. \u00FE)

[Anonymous]

Thanks Burce for the update!
However I couldn't seem to be able to get it to recognize Ascii 254 as quote character (I was able to get Ascii 20 as delimiter, THANK YOU!).
I could add it to the Csv Quote list in the Edit Option --> CSV --> Edit Csv Quote, but it doesn't do anything when I used it to parse file.
Attached is a sample file with delimiter (020) and quote characters (254) that I used every day.

[Bruce Martin]

For Quotes you can not specify in hex format.

What you can do choose a java font that includes a value for x'254' and enter the character (or enter it in unicode format (e.g. \u00fe'

[Anonymous]

Thanks Bruce. I still couldn't get that quote char to work properly in the drop down list, and worse yet, now it wouldn't work even when I copy past it in the alterative Quote input box.
The previous version allows me copy and paste and would work nicely.

Thanks again!

[Bruce Martin]

I forgot t mention you should not use x'..' format for field seperators when using quote.

I will try and have a look at it in the next week

[Bruce Martin]

I have finally had some time to play around. This is what works for me:

[Bruce Martin]

This also works (using cp437)

[Bruce Martin]

An alternative method would be to use a "Schema". With 0.98.1 there is a Schema option where you can enter a File schema.
Attached are 2 schema's specific to this files

They have field names coded in them.

To make them generic (will work with any column headers). One problem with the schema's is they do not remove the quotes from the column headers

[Bruce Martin]

This a generic CSV Schema definition (no fields defined). The preview does not work properly

[Anonymous]

Thanks Bruce!

I couldn't get the quote to work wih ISO-8859-1, and I don't see cp437 on my list of font. Maybe has to be with the fact that I am on Window 10?

Anyway, the only way I can get it to work is to copy paste the delimiter & quote in the alternative input box, just like it used to be.

[Bruce Martin]

One thing you could try is:

• Edit the file as above
• Select Edit >>> Save File Description as Xml
• Check the Generated Xml file. The DELIMITER might be rubish (it occurs twice). if it is replace it with DELIMITER="\u0014" (both occurences).
• Try using the Schema option to edit the file.

When I wrote the schema option I was concertrating on Fixed Width files. There seem to be some issues with CSV files, but it should be worth trying.

---