column0 c1 c2 c3 new column
abc|cds|oko abc cds oko oko
avd|afd avd afd
|gs gs gs
asd asd asd
I am trying to split the Column0 by | pipe operator and making column c3 content as new column, suppose if the c3 column is blank than c2 content to be filled in new column, if suppose c2 and c3 column are blank than c1 content to be filled in column ?? how to achieve this in R code
abc
, a second where it'scds
, a third where it'soko
, and so on? Or are you trying to separate column0 into multiple columns? $\endgroup$