Custom TSV
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.
Apologies - That should be custom DSV
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
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.
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.
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.
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
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
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
9 posts in this topic