Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Hi, you can try with:
=KeepChar(TextBetween(Mail_Box, '(', ')'), '0123456789')
Sorry, I read it too fast, you can try with:
=left(Mail_Box, Index(Mail_Box, 'B'))