Convert PDF path between Windows and Mac in Mendeley

Mendeley uses absolute path to locate the PDF. This makes it difficult to access the same PDF on Mac and Windows. One way is to edit the database following the instruction here, which can be made quite automatic using the following codes described in the blog:

update Files set
localUrl = replace(localUrl, ‚file:///OLD_PATH‘, ‚file:///NEW_PATH‘);

Location of database on Mac: "~/Library/Application Support/Mendeley Desktop"
Location of database on Windows: "~\AppData\Local\Mendeley Ltd\Mendeley Desktop"