Split column content into multiple columns

[andresrcs]

@ariminum

you can see it in the image attached to my first post.

Screenshots are considered a bad practice here since we cant select and copy code from them, post formated code instead. Here is how to do it

FAQ: How to format your code

Formatting Code: the Basics All code or console output you include in your posts should be formatted properly. Luckily, this is very easy to do! Just use the code formatting button at the top of the post editing box: [image] Select some code Click the </> button! The code formatting button automatically adds special Markdown formatting symbols to whatever you selected. If you check the preview pane to the right of your post, you'll see that the forum software now outputs nicely formatted code . [04] The code formatting button is pretty smart! It can tell the difference between snippets of code that are part of a sentence and blocks of code that stand alone. …

I can't be sure this code is going to work for you since you are not providing a reproducible example and I'm not willing to download a file from that source.

library(tidyverse)

dat %>% 
    group_by(`Reaction List PT`) %>% 
    summarise(n = n()) %>% 
    mutate(`Reaction List PT` = str_replace(`Reaction List PT`, "\\(", "- "),
           `Reaction List PT` = str_remove(`Reaction List PT`, "\\),")) %>% 
    separate(`Reaction List PT`,
             into = c("Reaction_List_PT", "Duration",
                      "Outcome", "Seriousness_criteria"),
             sep = " - ")

@ariminum

I am sorry, but I am a newbie.

Since you are a newbie I strongly encourage you to learn how to ask your questions providing a proper REPRoducible EXample (reprex) illustrating your issue. This is not only the most effective way to ask for help it is also the most polite.