String Splitting for file path (for entire data set) with one column not a single path given by the user

[mara]

@Nidha

From the folder inside folder - files
i want to access all the file and display the versions for the filename
i.e: v1 ,v2 ,v4 ,v5, v6...............
if v 3 is missing i want output as
version v3 missing

It's not clear to me what you're working with yet. I can see what you're trying to do, but not what you're getting back.

For splitting a character variable into an unknown number of columns, see the approaches mentioned in the thread below:

Split character column into unknown number of columns

I have a character column (not list, it's from a sql dataset) that has the structure of "List((query, count))" with differing amounts of entires. I'd like to transform this into a dataframe: library(tibble) #> Warning: package 'tibble' was built under R version 3.4.3 original_df <- tribble( ~query, ~id, "List((slime, 2))", 1L, "List((gift, 3), (bear, 1))", 2L, "List((sugar, 10))", 3L, "List((fluff, 2), (pie, 5), (plum, 8), (dark, 10), (long, 2))", 4L ) desired_df <- tribble( ~query, ~count, ~id, "slime", 2L, 1L, "gift", 3L, 2L, "bear", 1L, 2L, "sugar", 10L, 3L, "fluff", 2L, 4L, "pie", 5L, 4L, "plum", 8L, 4L, "dark", 10L, 4L, "long", 2L, 4L ) I'm struggling …