A simple string alienation problem

x <- read.csv("Fight.csv", stringsAsFactors = F, header = F)
 x$V3 <- sub("\\\"","",x$V1)  # remove the "
iV <- grep("/",x$V3)  # get the indices of the rows that have / in the

x$V4 <- x$V2  # or rep(NA,nrow(x))
x$V4[iV] <- sub(".*/","",x$V3[iV])  # remove up-to-and-including the /
x$V3[iV] <- sub("/.*","",x$V3[iV])  # remove from the / and beyond
x

***Dear Eric,*****
sending from gmail following the way you suggested. Hope now everyone
can see this email. **** I have also attached the first 50 rows of the
FIght.csv.***
***Output - I will try to do Market basket analysis on this to find
out rules that I am learning. so once I have the data in transactional
format - then I can run the algorithm and keep learning. This little
problem has caused a barrier in my path - I can alienate the string in
excel - but wanted to do in R - so researching I tried doing this:
x<- substr(x, 1, nchar(x) - 1)  // but I wasn't successful and I tried
many other things - its not coming in the transactional format. ***
Hence now reached out to the experts.**** Many Thanks.

Hello Dear R Community,

I would ask a little bit of help from you please:I have a dataset,
which is in a CSV file ? I have read it into R as follows:

      V1
tropical fruit"
whole milk"
pip fruit"
other vegetables"
whole milk"
rolls/buns"

The issue is: the data set in csv file also appears with the quotation
marks ?. I can?t get rid of the quotation marks. I want to do it in R.
The Quotes only appear at the end of the string. The dataset has many
rows ? this is just a copy. My intention is to be able to get rid of
the quotes and then want to separate the strings with a ?/?. i.e.
rolls/buns should be rolls in one column and buns in another.

I know this is something very simple I am lacking ? but if you could
please show me how to do this? If someone could throw some light
please. I read the data in with a simple read.csv statement:

x <- read.csv("Fight.csv", stringsAsFactors = F, header = F)
str(x)

Output:

str(calc)

'data.frame':   38765 obs. of  1 variable:
$ V1: chr  "tropical fruit\"" "whole milk\"" "pip fruit\"" "other
vegetables\"" ...

Many Thanks in advance for your help.
Kind Regards,
Sam.

dput(test)

test2 <- sapply(test, function(x) substr(x, 1, as.numeric(apply(test, 2, nchar))-1))

test2

sapply(test2, function(x) strsplit(x, "/"))

-----Original Message-----
From: R-help <r-help-bounces at r-project.org> On Behalf Of Soumyadip
Bhattacharyya
Sent: Tuesday, April 14, 2020 12:55 PM
To: r-help-request at r-project.org; r-help-owner at r-project.org; r-help at r-
project.org; ericjberger at gmail.com
Subject: [R] A simple string alienation problem

***Dear Eric,*****
sending from gmail following the way you suggested. Hope now everyone can
see this email. **** I have also attached the first 50 rows of the
FIght.csv.***
***Output - I will try to do Market basket analysis on this to find out rules
that I am learning. so once I have the data in transactional format - then I can
run the algorithm and keep learning. This little problem has caused a barrier
in my path - I can alienate the string in excel - but wanted to do in R - so
researching I tried doing this:
x<- substr(x, 1, nchar(x) - 1)  // but I wasn't successful and I tried many other
things - its not coming in the transactional format. *** Hence now reached
out to the experts.**** Many Thanks.

Hello Dear R Community,

I would ask a little bit of help from you please:I have a dataset, which is in a
CSV file ? I have read it into R as follows:

      V1
tropical fruit"
whole milk"
pip fruit"
other vegetables"
whole milk"
rolls/buns"

The issue is: the data set in csv file also appears with the quotation marks ?. I
can?t get rid of the quotation marks. I want to do it in R.
The Quotes only appear at the end of the string. The dataset has many rows ?
this is just a copy. My intention is to be able to get rid of the quotes and then
want to separate the strings with a ?/?. i.e.
rolls/buns should be rolls in one column and buns in another.

I know this is something very simple I am lacking ? but if you could please
show me how to do this? If someone could throw some light please. I read
the data in with a simple read.csv statement:

x <- read.csv("Fight.csv", stringsAsFactors = F, header = F)
str(x)

Output:

str(calc)

'data.frame':   38765 obs. of  1 variable:
$ V1: chr  "tropical fruit\"" "whole milk\"" "pip fruit\"" "other vegetables\"" ...

Many Thanks in advance for your help.
Kind Regards,
Sam.