Have a code that creates a list of file names with a directory.
dataframe1 =list.files(path = "C:/Users/xxxxxxx/OneDrive/Documents/test")
thats fine. it has 10 files with different file formats.
I have an excel spread sheet that has the names of those files but not their file extension. I want to write a code that will use the names in the excel spread sheet, compare with the dataframe 1, then write a hyperlink column in the excel spread.
Can anyone help me out on this? Been kicking my butt. I'm sure its simple but my mind isn't working well of late.
example.
name column in excel = 100
file name could be 100.txt or 100.pfd
final result must be a new column in the excel sheet that writes a hyper link to C:/Users/xxxxxxx/OneDrive/Documents/test/100.(filetype)
Then saves the excel spreadsheet.