• Compiling Form data

    • This topic has 2 replies, 3 voices, and was last updated 15 years ago.
    Author
    Topic
    #469286

    I’ve created a form template and sent it out and copies of the completed forms are rolling in. Now I have to compile all the information.

    1) Can the “Save form data as delimited text file” be made persistent?

    2) Is there a way to compile all the information into a spreadsheet without doing so individually?

    3) I can write VBA code to do just that. Excel can import tab delimited files into columns correctly but commas in Word’s version is a problem since commas can also appear in the data. How can you export a saved Word form delimited text file into Excel?

    Viewing 1 reply thread
    Author
    Replies
    • #1227317

      Hi ForEachLoop,

      1. AFAIK, once set, it should remain so. If not, you could use a macro to set it each time Word starts.
      2. That depends on both the data and the document’s layout. For example, you may be able to create an output file just by saving the document as a delimited text file.
      3. When converting to CSV, the simplest approach is to ensure the fields that could contain commas have double-quotes around them (but not within them). Excel will then handle them correctly.

      Cheers,
      Paul Edstein
      [Fmr MS MVP - Word]

    • #1227336

      Another option is to use tab delimited data, or pick another delimiter. You can specify the delimiter in Excel when parsing (converting text to columns in X2007/10).

      Pam

    Viewing 1 reply thread
    Reply To: Compiling Form data

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: