Renaming multiple data table from last word of current table name
Hi, I am trying to rename multiple data table because my data table name are in directory forms. I would want to rename them according to their folder names (will be getting from the last character of the directory) Sample data table name: C:\Users\Desktop\Table1C:\Users\Desktop\Table2C:\Users\Desktop\Table3 I tried using Word function to get the last word from the file name, but doesn't work. Pl...
michael_a_mille