Substring

[suvechha_b]

How can I use substring function in edit script in qlikview??

Can anyone give a simple example where substring is used and save it as a new variable in edit script of qlikview model???

[suvechha_b]

sorry, need to be added :

use two diifernt field with substring finction and concatenate it to a single variable and den load script...??

please show this type of example...

[jolivares]

Examples:

Text1 = QlikView

Mid(Text1,1,4) = Qlik

Mid(Text1,5,4) = View

Mid(Text1,1,4)&Mid(Text1,5,4) = QlikView

Load Mid(Text1,1,4)&Mid(Text1,5,4) as AppQV,

...