Reorder all strings in a Column of a Dataframe R

Question

I'm trying to reorder a string in a dataframe for all of the values in a column.

I have values such as:

F123/1K
F234/2Q
F678/8W

and I want it to look like:

K1231
Q2342
W6788

Is there a way to change all the strings at once rather than the crude way of doing each individually in a loop?

Any assistance would be greatly appreciated.

akrun · Accepted Answer · 2018-06-13T14:37:14.357

2

We can use sub to capture patterns as a group and then do the rearrangement of the backreference of the captured groups in the replacement

sub("^.(.{3}).(.)(.)", "\\3\\1\\2", df1$col)
#[1] "K1231" "Q2342" "W6788"

df1 <- structure(list(col = c("F123/1K", "F234/2Q", "F678/8W")), 
   .Names = "col", class = "data.frame", row.names = c(NA, -3L))

edited Jun 13 '18 at 14:37

answered Jun 13 '18 at 14:23

akrun

I think you want to remove the `/` as well – CPak Jun 13 '18 at 14:25
I'm getting the issue that the whole column is going into the first row: [1] "3(\"F123/1K\", \"F234/2Q\", \"F678/8W\") – MaskedMonkey Jun 13 '18 at 14:29
@MaskedMonkey I updated with the data and the output I am getting – akrun Jun 13 '18 at 14:39

1 Answers1