Extract number

[capriconuser]

I have a data like this 

Mail_Box

56.35 GB (358,3546 bytes)
466. MB (356,32 bytes)

Now i want to extract number till 'B' ... i tried this in script but this is not working 

load

---
Replace(left(Mail_Box,index(Mail_Box,' ')),chr(8206),'') as Mail_Box_Size
from 
----

how i do this ?

[rubenmarin]

Hi, you can try with:

=KeepChar(TextBetween(Mail_Box, '(', ')'), '0123456789')

[capriconuser]

hi this is not give correct output .. i want output like this 

56.35 GB 
466. MB 

@rubenmarin  

[rubenmarin]

Sorry, I read it too fast, you can try with:

=left(Mail_Box, Index(Mail_Box, 'B'))