[Yury LaFontaine]

I usually deal with large standardize delimiters similar to a “xxxx”,”xxxxx” (comma separated with quotes). Instead of those characters we use the following

Text Character ASCII Character
———————————————————————–
Comma —–> 20
Quote ——-> 254
NewLine ———> 174
Multi Value ————-> 059
Nested Value ————> 082

Currently i use a macro with RegEx to converted to Tab Format by replacing \\x{00FE}\\x{14}\\x{00FE} wiht \t

Is there a method of creating a TSV definition in EE? so i can quickly switch from format to format?

I have already tried but did not seem to work,

thank you in advnace.

[Yury LaFontaine]

Apologies – That should be custom DSV

[Patrick C]

View → Toolbars → CSV Toolbar
you’ll notice that there are four default CSV profiles to choose from

it might help to think of CSV, TSV,… as *SV i.e. each of them can be configured freely

to configure:
Tools → Customise → CSV

[Yutaka Emura]

Please enter \xfe\x14\xfe in the Delimiter text box in the CSV page of the Customize dialog box.
P.S. Please don’t double post the same question to StackOverflow.

[Yury LaFontaine]

Thank you for the replay Patrick,

That was the firs thin i tried, however there is no option to set the default character to replace the quote.

I replaced the delimete with both

\\x{14} or \\x{00FE}\\x{14}\\x{00FE} and did not ge the desired affect.

[Yury LaFontaine]

Thank you for reply Patrick,

That was the one of the first things i attempted, I tried both \\x{14} and \\x{00FE}\\x{14}\\x{00FE} in the Delimiter option without success..

I did not see a place where the quote delimiter could be modified.

[Yury LaFontaine]

Patrick,
Thank you for responding, this was one fo the first items i attempted without success. I did not see a method of replacing the quote character

I tried replacing the delimiter in two was \\x{14} and \\x{00FE}\\x{14}\\x{00FE}

Apologies if this appears more than once. my reply did not show up

[Yury LaFontaine]

Patrick,
Thank you for responding, this was one fo the first items i attempted without success. I did not see a method of replacing the qoute character

I tried replacing the delimiter in two was \\x{14} and \\x{00FE}\\x{14}\\x{00FE}

Apologies if this appears more than once. my reply did not show up

[Yury LaFontaine]

Patrick,
Thank you for responding, this was one fo the first items i attempted without success. I did not see a method of replacing the qoute character

I tried replacing the delimiter in two was \\x{14} and \\x{00FE}\\x{14}\\x{00FE}

Apologies if this appears more than once. my replies are not displaying

[Author]

Posts