Reading CSV file

[scunha]

How do we tell R that the data is separated by "|" and "/" , if this is not happening in the first row (Column names)?

Responses = read.csv(file="Liveexitsurvey.csv", header =TRUE, check.names=FALSE)

[M_AcostaCH]

Remember put a reproducible example of data, is a good way for find excellent help for all community.

FAQ: How to do a minimal reproducible example ( reprex ) for beginners

A minimal reproducible example consists of the following items: A minimal dataset, necessary to reproduce the issue The minimal runnable code necessary to reproduce the issue, which can be run on the given dataset, and including the necessary information on the used packages. Let's quickly go over each one of these with examples: Minimal Dataset (Sample Data) You need to provide a data frame that is small enough to be (reasonably) pasted on a post, but big enough to reproduce your issue. Let's say, as an example, that you are working with the iris data frame head(iris) #> Sepal.Length Sepal.Width Petal.Length Petal.Width Species #> 1 5.1 3.5 1.4 0.…

Try with this for separator like | :

Responses <- read.csv('/Users/admin/file.csv', header=TRUE, sep='|' )

[scunha]

Then when I download the file, it won't do it correctly, it won't recognise the columns as being separate, I get 131 observations for 1 single variable when I have around 20 variables.

[M_AcostaCH]

You need other separator .
try

Responses <- read.csv('/Users/admin/file.csv', header=TRUE, sep=',' )

[startz]

Basically, the standard functions only allow for one separator (except for white space which can be various characters) and you need to allow for two different separators. Probably going to have to read in as lines of text and then separate into columns more painfully.

[scunha]

How would I do this? Newbie here!

[FactOREO]

I think it would be rather helpful if you could paste an example of the data in your .csv file into the forum. Then, we could just make up a .csv file our own and provide a solution. It doesn't have to be the real data, just preserve the structure of your raw .csv file (open it in a text editor, copy the structure and provide a desired result, e.g. what columns are actually present in your example and what should be inside them).