Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • 2020-01-13 at 8:35 pm #11892
    Greg2
    Member

    Hi,

    I’m using some data that includes several records with commas in the text, which necessitate double-quotes when my CSV is exported from Google Sheets.

    I’ve selected “Sanitize” in the mydatamerge flow, but the double-quotes still appear in the resulting file.

    A typical line of this type looks like this

    21324,22446,,Joe,Smith,she,Big Store,South Bend,IN,First Timer,,,Joe,Smith,7,96,55,,Yes,Bookseller,”Please sit with your mentor, Bob Jones, at table 2.”,blue,”Mentor/Mentee Meet and Greet & First-timer Orientation, and Wednesday’s & Thursday’s breakfasts:”,Registered

    Example of output:

    https://ibb.co/dk1PKN6

    What am I doing wrong?

    Thanks,
    Greg

     

    2020-01-13 at 10:21 pm #11893
    Pat
    Staff

    Hi Greg,

    I just tested this with the actual version and it worked as expected.

    • Did you select the correct encoding in import > csv > settings (gear icon on top of the CSV symbol)? Try different ones! UTF-8 should work for the most.
    • Did you select “Sanitize” option in the same panel OR in the datasource element settings in the editor? (First would be correct) – Please note: Changing this options requires a REFRESH if data is already imported (circle arrow icon).
    • What does the preview in the editor show? Are the quotes included in the preview or not? If they are included it is most likely an encoding thing from google’s export. Open the CSV file with Textedit on Mac, copy one of the quotes, press CMD+F (Find) and paste the quote. Click the “Replace” checkbox, then enter a standard double quote by keyboard (not paste). If the file has different opening and closing quotes repeat that step for the other part. Then try again. If the preview doesn’t show the quotes the export should work fine also.

    If this doesn’t work at all we would need some sample data with original quotes and e.g. 1 line of data – you may anonymize it before (+ data titles, so 2 lines in total).

    Best, John

    Official MyDataMerge Team

    2020-01-15 at 5:54 pm #11918
    Greg2
    Member

    Thank you for your help. Everything looks good now.

    Frankly, we’re not sure which of your suggestions fixed our problem, but it is fixed!

    Thanks again!

    2020-01-16 at 1:50 pm #11923
    Pat
    Staff

    Glad we could help. Just let us know if there’s anything else you need to know.

    Official MyDataMerge Team

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)
  • The topic ‘Sanitize doesn’t clean double quotes’ is closed to new replies.