Importing .csv file with European decimal places

Hello #shiny users! I have an app I built here that takes a .csv file with two variables (REF and BGM). I've recently received a request from a European user to have the application accept files with European-style decimal units (i.e. instead of 100,100.61 it would be 100.100,61).

I am assuming read.table() will do this, but I am drawing a total blank on how I could get the function to test for the type of .csv file and import the correct version?

Thank you all in advance for your time!

  • Martin

Would readr::read_csv2() work for you?

Hi @martin.R ! yes--that will work, but I'm trying to figure out how to get the renderTable() to check whether it's European formatted (with sep = ; and dec = ",") and then maybe pass it off to the right readr function? Or should I just make them all options from read.table()?

I'll keep digging--thank you!.

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.