Tagged: 

Viewing 4 posts - 1 through 4 (of 4 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.

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