06-18-2014 03:55 AM
I have image files and I want to extract the nuumbers in the image file name. All my image files look like this:
{1D5A0279-41E9} 29.05.2014 17-22-58.59 x1566x1375x2768x2577.png
I want to just extract the number after the first x and the second x. I have tried using Match Pattern and then converting them with Fract/Exp String to Number but the output is not always constant of the position I need. How would I go about this?
Solved! Go to Solution.
06-18-2014 03:58 AM
Hey,
either take the scan from string function
or split the string at the x to extract the value
Regards,
CMW
06-18-2014 04:06 AM
How will I scan from the first x take the number and scan the second and take that number also?
06-18-2014 04:14 AM
How about using "Spreadsheet string to Array" like this?
06-18-2014 04:18 AM
or this way,
btw: I wouldn't use special characters and dots in file names.
Regards,
CMW
06-18-2014 07:49 AM