topic Extract number in Integration, Extension & APIs

Extract number

capriconuser — Wed, 04 Aug 2021 05:29:20 GMT

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 — Wed, 04 Aug 2021 06:07:03 GMT

Hi, you can try with:

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

capriconuser — Wed, 04 Aug 2021 06:30:57 GMT

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

56.35 GB 466. MB

rubenmarin — Wed, 04 Aug 2021 06:33:23 GMT

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

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