topic Re: String Format in QlikView

String Format

Anonymous — Wed, 16 Sep 2015 17:29:28 GMT

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!

Re: String Format

nagaiank — Wed, 16 Sep 2015 17:35:09 GMT

You may use

Replace(Replace(SubField(YourFieldName,',',2),'[',''),']','')

Re: String Format

Anonymous — Wed, 16 Sep 2015 17:51:30 GMT

Thanks for replying. However, the expression is not working.

Re: String Format

marcus_sommer — Wed, 16 Sep 2015 17:53:03 GMT

For this you could use:

textbetween(YourFieldName, '[', ']', 2)

- Marcus

Re: String Format

Wed, 16 Sep 2015 18:01:58 GMT

what about rmid(fieldname, 13,10)

If I counted correctly, it would start on the 13th position for the next 10

mid(s, n1[, n2 ])

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.

Re: String Format

maxgro — Wed, 16 Sep 2015 18:13:54 GMT

could you post some data?

Re: String Format

Anonymous — Wed, 16 Sep 2015 19:06:20 GMT

Thank you!