Was wondering if any of you guys know if the below is possible and how to go about it.
The scenario is that files (CSV's) are sent (Email) to me from a number of different sources. Source A, B, C, & D. These file names are all formated differently, so for example from source A the file name will always be AB(+variable data), from source B it will always be BGHJ(+variable data) etc. I need then to recognize the fixed data e.g. AB or BGHJ and change the file name to something that I need - so AB(+variable data) could become ABNEW(+variable data) and BGHJ(+variable data) could become BGHJNEW(+variable data) - these are then saved to a specified destination.
Does this make sense? Thanks for reading - any ideas / suggestions / questions gratefully received