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

amrun

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

Jasper

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

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

Lars

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