How to reset path.expand on tilde

Question

On Windows, in my RProfile.site, I used to set:

Sys.setenv(R_USER="/my/desired/path/to/tilde")

However, this does not create the same effect on Ubuntu. Any ideas on how I can achieve the same effect? Such that when I type ~ in a path it expands to R_USER?

Here's an example. On Windows, after setting R_USER, in my scripts I would use the following:

read.csv("~/Project") 

Where "~" expanded to /some/path/to/projects/

Answer 1

Define HOME="/my/projects/folder", preferably for R only, in .Renviron

Functionality for changing the method of ~ path expansion on windows does not exist in the same fashion as Windows as it does in Ubuntu/Linux*