While preparing the CSV to import into 1password, I wonder how to delimit fields like passwords

amrun
amrun
Community Member

Hi All

I stumbled upon this question, while preparing the CSV to import into 1password. Normally, one would delimit strings in a CSV using " oder some such. Passwords on the other hand can contain any number of unholy characters, including but not limited to ".
How would one escape "unescapable" fields?

The import will be done in the Browser.

Thankful for any help
Best regards
Ben, proud owner of a recently-bought 1password family-licence :D


1Password Version: :latest
Extension Version: Not Provided
OS Version: Not Provided
Sync Type: Not Provided
Referrer: forum-search:CSV import

Comments

  • Hi @amrun,

    The proper way to escape in this case would be including the entire value in double quotes (") and then escaping any double quotes within that value with another double quote.

    So if your password was password"123, the CSV should look like this:

    Amazon.com,https://amazon.com/,wendy_appleseed,"password""123"
    

    I hope that helps but please let us know if that doesn't work or you have any other questions.

  • amrun
    amrun
    Community Member

    Hi @Jasper
    Worked like a charm. Thank you sire!
    Cheers

  • Lars
    Lars
    1Password Alumni

    @amrun - on behalf of Jasper, you're quite welcome. Glad he was able to help! :)

This discussion has been closed.