Can someone tell if it's possible to return a Text string between two points? To elaborate, the column I want to apply this to has a different number of characters that I want to return so it isn't as simple as a MID(Text, StartPosition,NumberOfCharacters) job.
Some examples of what it will apply to are below, the common factor in them all is that they all start with a '.', have the number, a space and then 'GB'. What I would like to return is just the number.
.1.098 GB (1,178,599,424 bytes)
.2 GB (2,147,483,648 bytes)
.1.488 GB (1,598,029,824 bytes)
.1.952 GB (2,096,103,424 bytes)
.6 GB (6,442,450,944 bytes)
So it would look like...
1.098
2
1.488
1.952
6
Is it possible to return text from two text conditions? I.e. '.' & 'GB' or is there another way to do this?