Tagged: 

Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • #26924
    Yury LaFontaine
    Participant

    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.

    #26925
    Yury LaFontaine
    Participant

    Apologies – That should be custom DSV

    #26926
    Patrick C
    Participant

    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

    #26933
    Yutaka Emura
    Keymaster

    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.

    #26927
    Yury LaFontaine
    Participant

    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.

    TSV Options

    I replaced the delimete with both

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

    #26928
    Yury LaFontaine
    Participant

    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..

    Delimeter option

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

    #26929
    Yury LaFontaine
    Participant

    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

    #26930
    Yury LaFontaine
    Participant

    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

    #26931
    Yury LaFontaine
    Participant

    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

Viewing 9 posts - 1 through 9 (of 9 total)
  • You must be logged in to reply to this topic.