Is there an equivalnet to Oracle Substr in Qlikview

[#1]

Is there something that is close to an Oracle substr in Qlikview

Oracle Substring:

substr('This is a test', 6)

would return 'is a test'

I have see the Subfield and SubStringCount however they do not meet my requirment.

Thanks,

Divya

[jonathandienst · Accepted solution]

p406 of the manual:

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.

Examples:
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

[#3]

Hi, you could use the function Mid('This is a text',1,6); this return 'This i'

Regards

[#4]

Thank you very much ..Some time its easy to be LOST IN FUNCTION !!!! 🙂

[#5]

there are three functions that u can use:

left(<string>,n)

right(<string>,n)

mid(<string>,n,n)