Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All
i have below field with different types..like MB,GB & TB in string format.. need to calculate in GB only(only numeric no need of type)..
Space
2.0 TB |
79.3 GB |
2.0 TB |
28.2 GB |
2369.8MB |
257.7 GB |
62.9 GB |
114.2 GB |
108.1 GB |
9.0 GB |
62.8 GB |
You can calculate like
If(Right(Space,2) = 'TB', Space / 1024 , Space) as Space
Try like this
if(subfiled(Space,'' ,2))='TB',subfiled(Space,'' ,1))*1024,subfiled(Space,'' ,1))) as Space
Hi Surendra,
Maybe:
Space | GB |
---|---|
2.0 TB | 2048.00 |
9.0 GB | 9.00 |
28.2 GB | 28.20 |
62.8 GB | 62.80 |
62.9 GB | 62.90 |
79.3 GB | 79.30 |
108.1 GB | 108.10 |
114.2 GB | 114.20 |
257.7 GB | 257.70 |
2369.8MB | 2.31 |
GB = PurgeChar(Space,'BMGT')*Pick(Match(Keepchar(Space,'MGT'),'M','G','T'), 1/1024,1,1024)
Kind regards
Andrew