Vivek Sam wrote:Hi,
The date part is 20110801 .
Now if I had to tell somebody who had no idea what a date was , I would want to keep the first text part of the filename till I encounter the first number , and then skip the numbers which follow the the format YYYY-MM-DD , and then pick up the rest of the characters after that to give me the final name as TitanP96584.
You could many Regex tools available online. See if this works for you.
\d{8}
I assumed the date format will always be of 8 numbers (YYYYMMDD) and the characters of the file-name [at beginning] (Titan) don't end with a number.