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

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

  • JasperJasper

    Team Member

    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.

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

  • LarsLars Junior Member

    Team Member

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file