Dear Community
I'm trying hard to understand how to do this. As my input file name is too long, I want the output file name to have some strings from the original file name. "FileName" is available.
Should I use RegEx tool or Regex in Formula?
Input file name will be: VK-29698-AA36718 PT-210120-21687 -E L1-DB1131693-PLG_Result-DB-DeepDiveScanX_2021-02-15_070319.xlsx
Output file name should look like: PT-210120-21687 DeepDiveScanX_2021-02-15_070319.xlsx
Conditions here are
- there will be always "PT" followed by "-", following by date (always 6 numbers) followed by "-", followed by any length of numbers. e.g.PT-YYMMDD-n*
- the text DeepDiveScanX will be also there and the rest should be until the file type extension. So basically DeepDiveScanX until the dot
Thanks a lot
Solved! Go to Solution.
yep that worked! Thanks for quick reply!