Exporting database as comma delimited file

Home Forums Error reporting Exporting database as comma delimited file

This forum is for reporting errors, bugs and malfunctions in the system.
  • Creator
    Topic
  • #5243
    Renate Morgenstern
    Participant
    Helpful
    Up
    0
    Down
    Not Helpful
    ::

    Good day.

    I need to export a database as a comma delimited file.

    I know I can write a format for it, but I tested the utility available on ABCD as it makes it easier.

    But I have problems with the output of repeatable subfields.

    I do not want the subfield delimiter in the output. When I add the extraction format with a separator, it will just cut is to the first subfield.

    Does Cisis have a utility to generate a comma delimited file from a whole database?

    Please advise. Thanks

    Renate

Viewing 1 replies (of 1 total)
  • Author
    Replies
  • #5244
    Helpful
    Up
    0
    Down
    Not Helpful
    ::

    Hi, Renate.

    It took me a while to answer because I needed to test on a base what you reported.

    I don’t know if I went in the same place as you, but using Export by Text and putting “R” in the “Repeat separator” field worked for me.

    In my test I put 2 values in a field:
    Example:
    ^a123456789
    ^a987654312

    On export it came out:
    ^a123456789; ^a987654312

    The semicolon can easily be replaced, but ABCD managed to export the repetition.

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.