例如，我希望洗掉字串后面的空格，而不是 SO MILWAUKEE .xlsx我希望它是SO MILWAUKEE.xlsx. 我對 dplyr 或 base r 中的解決方案持開放態度
[1] "INTERLINE BRANDS.xlsx" "POLY-AMERICA, LP.xlsx" "SO TTI POWER EQUIPMENT .xlsx"
[4] "GENERAC SO.xlsx" "SO TOTER LLC .xlsx" "SO IMPERIAL INDUSTRIAL .xlsx"
[7] "SO MTDARNOLD PRODUCTS .xlsx" "SO KOHLER GENS.xlsx" "RUBBERMAID CONSUMER .xlsx"
[10] "SO MILWAUKEE .xlsx" "SO CINDERELLA INC .xlsx" "MAKITA .xlsx"
[13] "SO THE TORO COMPANY .xlsx" "SO RUBBERMAID SPECIALTY.xlsx" "SO AMES TRUE TEMPER , I.xlsx"
[16] "SO POLYWOOD .xlsx" "ZEPENFORCER.xlsx" "TIGER SUPPLIES .xlsx"
[19] "INTERLINE BRANDS, INC..xlsx" "SO MWE INVESTMENTS, LLC.xlsx" "SO DIMPLEX NORTH AMERIC.xlsx"
uj5u.com熱心網友回復：
假設您的資料在dat. 您可以執行以下操作：
dat <- gsub("\\s \\.xlsx", ".xlsx", dat)
uj5u.com熱心網友回復：
library(tidyverse)
data <-
c("INTERLINE BRANDS.xlsx", "POLY-AMERICA, LP.xlsx", "SO TTI POWER EQUIPMENT .xlsx",
"GENERAC SO.xlsx", "SO TOTER LLC .xlsx", "SO IMPERIAL INDUSTRIAL .xlsx",
"SO MTDARNOLD PRODUCTS .xlsx", "SO KOHLER GENS.xlsx", "RUBBERMAID CONSUMER .xlsx",
"SO MILWAUKEE .xlsx", "SO CINDERELLA INC .xlsx", "MAKITA .xlsx",
"SO THE TORO COMPANY .xlsx" , "SO RUBBERMAID SPECIALTY.xlsx", "SO AMES TRUE TEMPER , I.xlsx" ,
"SO POLYWOOD .xlsx", "ZEPENFORCER.xlsx", "TIGER SUPPLIES .xlsx",
"INTERLINE BRANDS, INC..xlsx", "SO MWE INVESTMENTS, LLC.xlsx", "SO DIMPLEX NORTH AMERIC.xlsx")
str_replace(data, '\\s \\.xlsx', '.xlsx')
#> [1] "INTERLINE BRANDS.xlsx" "POLY-AMERICA, LP.xlsx"
#> [3] "SO TTI POWER EQUIPMENT.xlsx" "GENERAC SO.xlsx"
#> [5] "SO TOTER LLC.xlsx" "SO IMPERIAL INDUSTRIAL.xlsx"
#> [7] "SO MTDARNOLD PRODUCTS.xlsx" "SO KOHLER GENS.xlsx"
#> [9] "RUBBERMAID CONSUMER.xlsx" "SO MILWAUKEE.xlsx"
#> [11] "SO CINDERELLA INC.xlsx" "MAKITA.xlsx"
#> [13] "SO THE TORO COMPANY.xlsx" "SO RUBBERMAID SPECIALTY.xlsx"
#> [15] "SO AMES TRUE TEMPER , I.xlsx" "SO POLYWOOD.xlsx"
#> [17] "ZEPENFORCER.xlsx" "TIGER SUPPLIES.xlsx"
#> [19] "INTERLINE BRANDS, INC..xlsx" "SO MWE INVESTMENTS, LLC.xlsx"
#> [21] "SO DIMPLEX NORTH AMERIC.xlsx"
由reprex 包(v2.0.1)于 2021 年 12 月 6 日創建
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/375152.html