none
How do i rename numerous files RRS feed

  • Question

  • Hi guys,

    At work I receive arround 3000 pictures per quarter, these files are named with an supplier articel number. I need to change that name to an article number of my choosing.

    I have an excelfile which contains both numbers so i would like to have something similar to a =Vlookup function in Excel. Is this possible and what would be the fasted way to get this done?

    (current method: hire a trainee and have him (me) do it manually, i cannot imagen there is not a smarter and faster way to do this...)

    THANKS A LOT for your imput!

    Example:

    the photo's i have are named:

    B34859
    B34862
    B35098
    103121-04

    The excelfile i have contains the colums:

    Supplier aricle nr USG article number etc etc
    B34859 1.05A.574    
    B34862 1.05A.575    
    B35098 1.05A.579    
    103121-04
    1.05A.542
     

     

    Tuesday, January 13, 2015 2:41 PM