Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • J 351 posts 606 karma points
    Jul 31, 2013 @ 17:14
    J
    0

    Export options question

    I have a contour form which has a multi checkbox, a customer could select multiple free product(s) they would like. When the data is exported to Excel the data comes as below ( - separates each field in this example)

    Name - Address - Free product

    Bob - Some Address - Handwash, soap, toothpast, aftershave
    Tom - Another Address - Handwash

    I think the answer is no but when exporting could the multiple products be exported as

    Bob - Some Address - Handwash - soap - toothpast - aftershave

    Hope that makes sense.

    Copy Link
  • Tim Geyssens 6562 posts 15373 karma points MVP 2x c-trib
    Jul 31, 2013 @ 17:20
    Tim Geyssens
    0

    Hey,

    Easiest would be to just handle this in excel, think you can use this function http://www.techonthenet.com/excel/formulas/substitute.php

    Copy Link
  • Tim Geyssens 6562 posts 15373 karma points MVP 2x c-trib
    Jul 31, 2013 @ 17:21
    Tim Geyssens
    0

    Ah if you want to split to field you can use the text to columns function in excel http://www.youtube.com/watch?v=neDUOYk8hyU

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies