Hello
I currently have a column with the following file name in one of my tables.
C:\Users\John\OneDrive - Sales Solutions\Desktop\TimeXtender\TMX-DataSamples\RLZ\BESTERS - BESTERS POINT - BESTERS IND_DEC 22_101602_0.txt
Is there a way to remove the path name in the column to only have the file name?
I have a file for each month and have merged the files so all the data is in one table.
For example, remove this piece:
C:\Users\John\OneDrive - Sales Solutions\Desktop\TimeXtender\TMX-DataSamples\RLZ\
and only show this piece:
BESTERS - BESTERS POINT - BESTERS IND_DEC 22 as the file name.
I also need to have the Month Year (DEC 22) of each file copied into a new column called “Date”.
Is this at all possible?
Thank you
Best answer by Christian Hauggaard
View original