キャンセル
次の結果を表示 
次の代わりに検索 
もしかして: 

Extract numbers from string

解決済み
解決策を見る

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? 

----------------------------------------------------------------------------------
I have not lost my mind, it's backed up on a disk somewhere
0 件の賞賛
メッセージ1/6
8,569件の閲覧回数

Hey,

 

either take the scan from string function

 

or split the string at the x to extract the value

 

Regards,

CMW

0 件の賞賛
メッセージ2/6
8,568件の閲覧回数

How will I scan from the first x take the number and scan the second and take that number also?

----------------------------------------------------------------------------------
I have not lost my mind, it's backed up on a disk somewhere
0 件の賞賛
メッセージ3/6
8,557件の閲覧回数
解決策
トピック作成者PauldePaorが受理

How about using "Spreadsheet string to Array" like this?

 

ExtractNumber.png

-----

The best solution is the one you find it by yourself
メッセージ4/6
8,548件の閲覧回数

or this way,

 

scanfromstring.png

 

btw: I wouldn't use special characters and dots in file names.

 

Regards,

CMW

メッセージ5/6
8,540件の閲覧回数

Using regular expression

 

using regex.png

メッセージ6/6
8,501件の閲覧回数