Convert GigaBytes or Megabytes to number

[dkey]

Hello I am using FMP13 and I have a MEDIASIZE field where all the data is something like this: 64.3 MB or 3.96 GB

How to write a script which will convert to a regular number this information?

As it si I can't sort the various records while converting them as an even number it will be possible

Thanks a lot

 

[Fitch]

Not exactly sure what you're asking. If you just want to trim out the text:

GetAsNumber

[comment]

How about =

MEDIASIZE * If ( PatternCount ( MEDIASIZE ; "GB" ) ; 1024 ; 1 )

 

[dkey]

29 minutes ago, comment said:

How about =

MEDIASIZE * If ( PatternCount ( MEDIASIZE ; "GB" ) ; 1024 ; 1 )

 

Works perfectly thanks

[dkey]

It works perfectly in case the pattern is either KB or GB

Hower it doenst work in case the pattern is MB