Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a column where the values are like the ones below.
I only want the number part, ex. 0000161677. What function or expression should I use to achieve this?
Thanks!
For this you could use:
textbetween(YourFieldName, '[', ']', 2)
- Marcus
You may use
Replace(Replace(SubField(YourFieldName,',',2),'[',''),']','')
Hi
Thanks for replying. However, the expression is not working.
For this you could use:
textbetween(YourFieldName, '[', ']', 2)
- Marcus
what about rmid(fieldname, 13,10)
If I counted correctly, it would start on the 13th position for the next 10
Substring of the string s. The result is the string starting at character n1 with the length of n2 characters. If n2 is omitted, the function returns the rightmost part of the string starting at character n1. The positions in the string are numbered from 1 and up.
Example:
mid('abcdef',3 ) returns 'cdef'.
mid('abcdef',3, 2 ) returns 'cd'.
mid( Date,3 ) where Date = 970714 returns 0714.
mid( Date,3,2 ) where Date = 970714 returns 07.
For a more complicated example, see the index function below.
could you post some data?
Thank you!