filenameSample.xaml (8.5 KB)
You can use Regex to extract only integers out of any string (filename in this case).
System.Text.RegularExpressions.Regex.Match(fileName, “\d+”).Value will give you the result in a string.
Please note that d+ is the Regular expression for an integer number.
PFA the xaml for your reference.filenameSample (1).xaml (8.8 KB)
Thank you.Btw if i have a filename like “RTIM8372847284_Lokesh Raju” how can i get the “Lokesh Raju” alone??
Well it depends whether or not your string follows a pattern. E.g. if the name of your excel always going to contain “_” (underscore) before the name, you can use something like -