Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
  • #26924
    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.

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