October 2, 20178 yr 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
October 2, 20178 yr Not exactly sure what you're asking. If you just want to trim out the text: GetAsNumber
October 2, 20178 yr Author 29 minutes ago, comment said: How about = MEDIASIZE * If ( PatternCount ( MEDIASIZE ; "GB" ) ; 1024 ; 1 ) Works perfectly thanks
November 17, 20178 yr Author It works perfectly in case the pattern is either KB or GB Hower it doenst work in case the pattern is MB
Create an account or sign in to comment