topic Re: "Find" functionality for load script in QlikView

"Find" functionality for load script

Tue, 03 Dec 2013 09:11:57 GMT

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

Re: "Find" functionality for load script

jonathandienst — Tue, 03 Dec 2013 09:18:39 GMT

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

Re: "Find" functionality for load script

jagan — Tue, 03 Dec 2013 09:18:53 GMT

Hi,

Try using Index() in qlikview

Example:

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

Check help file for more details.

Regards,

Jagan.

Re: "Find" functionality for load script

nilesh_gangurde — Tue, 03 Dec 2013 09:22:17 GMT

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

Re: "Find" functionality for load script

Tue, 03 Dec 2013 09:32:05 GMT

Hi Stephen,

you can use Index function in QlikView.

it is Similar to find in excel, instring in sql

regards,

Vijay