# CSV file with non-standard delimiters and quote characters

**URL:** <https://forum.cloverdx.com/t/csv-file-with-non-standard-delimiters-and-quote-characters/675>\
**Category:** CloverDX Platform\
**Created:** [March 12, 2010, 12:00am UTC](https://forum.cloverdx.com/t/csv-file-with-non-standard-delimiters-and-quote-characters/675 "2010-03-12T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![andy](https://avatars.discourse-cdn.com/v4/letter/a/aeb1de/32.png) [@andy](https://forum.cloverdx.com/u/andy)\
**Post date:** [March 12, 2010, 12:00am UTC](https://forum.cloverdx.com/t/csv-file-with-non-standard-delimiters-and-quote-characters/675/1 "2010-03-12T00:00:00Z")

</div>

What’s the best way to process a CSV file with non-standard delimiters and quote characters?

In my case the delimiter is \u0014 and the quote character is \u00fe . I’m in the metadata editor now in the designer, and I’m trying to specify \u0014 as the delimiter, and it’s not splitting properly. There also doesn’t seem to be a way to specify a quote character.

Thanks!

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [March 16, 2010, 9:04am UTC](https://forum.cloverdx.com/t/csv-file-with-non-standard-delimiters-and-quote-characters/675/2 "2010-03-16T09:04:25Z")

</div>

Hello Andy,  
you can set such delimiter with ctl: set field delimiter as `‘\u0014’` - all, that is between `` characters is interpreted as ctl code.  
Unfortunately only single and double quote characters are recognized as quotation by Clover.  
But you can use following workaround to parse the data:

- read full record as one string field

- translate \u00fe to " in Reformat:

```auto
function transform() {  
	$0.field1 := translate($0.field1,'\u00fe','"');  
}  

```

- send translated field to Data Reader - use _port:$0.field1:discrete_ in _fileURL_ attribute. Remember to set _eofAsDelimiter=“true”_ on output metadata