"Find" functionality for load script

[#1]

Hi

Does anyone know how to find a certain character in a field and return at which position is lies?  This is similar to the functionality of "find" within excel.  I'm pulling a blank at the moment but I'm sure it must exist.

Thanks

Steve

[jonathandienst]

Steve

If you mean find a string on the load script code, then Ctrl-F for find and Ctrl-H for replace.

Perhaps you meant something different?\

Jonathan

[jagan · Accepted solution]

Hi,

Try using Index() in qlikview

Example:

Index( 'abcdefg', 'cd' ) returns 3

Check help file for more details.

Regards,

Jagan.

[nilesh_gangurde]

Yess

You can load the data with the below mentioned code which will give you null values Displyed if they are present.

load *,

if(Isnull(Field_Name),'NULL',Field_Name) as NEW_FIELD

From Source_NAME;

Load this and look at frontend by taking List box.

-Nilesh

[#5]

Hi Stephen,

you can use Index function in QlikView.

it is Similar to find in excel, instring in sql

regards,

Vijay