我需要在不同的列中分离以下字符串。
string = "H:Half-yearly/"A:Outstanding - notional amounts"/"A:Total (all instruments)"/"B:Foreign exchange"/"5J:All countries (total)"/"A:Total (all counterparties)"/"5J:All countries (total)"/"A:Total (all sectors)"/"TO1:Total (all currencies)"/"USD:US dollar"/"A:Total (all maturities)"/"A:Total (all ratings)"/"3:Total (all methods)"/"C:Net - net"/H:A:A:B:5J:A:5J:A:TO1:USD:A:A:3:C/19168639.500/19152273.382/16570931.333/16504473.647/17872834.161/18034192.743/18340526.000/18976252.550/20062793.085/21044051.427/24842918.967/27753186.875/28401867.500/30250361.915/32530354.232/31530866.590/38308896.039/41071533.056/47782829.500/55333816.999/61778797.231/51013377.932/49245196.366/49565196.793/53615697.500/57490500.198/64325378.832/63517357.370/66711084.080/66852981.078/71298569.378/67974223.786/71903681.455/73329825.600/69380854.616/66121018.427/75421500.092/70549837.635/77043460.796/74755778.576/84448087.669/80187033.245/87298666.811"
我需要做的是：每次有/时创建一个新列。
例如：CCD_ 2变成具有CCD_ 3内部的所有这些信息的4列对象。
我尝试过以下代码，但它不起作用，因为它说："对象string不是字符"，但对象string是字符。
string = "H:Half-yearly/"A:Outstanding - notional amounts"/"A:Total (all instruments)"/"B:Foreign exchange"/"5J:All countries (total)"/"A:Total (all counterparties)"/"5J:All countries (total)"/"A:Total (all sectors)"/"TO1:Total (all currencies)"/"USD:US dollar"/"A:Total (all maturities)"/"A:Total (all ratings)"/"3:Total (all methods)"/"C:Net - net"/H:A:A:B:5J:A:5J:A:TO1:USD:A:A:3:C/19168639.500/19152273.382/16570931.333/16504473.647/17872834.161/18034192.743/18340526.000/18976252.550/20062793.085/21044051.427/24842918.967/27753186.875/28401867.500/30250361.915/32530354.232/31530866.590/38308896.039/41071533.056/47782829.500/55333816.999/61778797.231/51013377.932/49245196.366/49565196.793/53615697.500/57490500.198/64325378.832/63517357.370/66711084.080/66852981.078/71298569.378/67974223.786/71903681.455/73329825.600/69380854.616/66121018.427/75421500.092/70549837.635/77043460.796/74755778.576/84448087.669/80187033.245/87298666.811"
library(tidyr)
chr2cols = separate(string, sep = "/")
str(string)
- 如何将此字符串分隔成更多列？谢谢
不确定是否要拆分为数组而不是列：
x <- strsplit(string, "/")
删除"的反斜杠(转义符(
gsub(""", "", x[[1]])