Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try using Index() in qlikview
Example:
Index( 'abcdefg', 'cd' ) returns 3
Check help file for more details.
Regards,
Jagan.
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
Hi,
Try using Index() in qlikview
Example:
Index( 'abcdefg', 'cd' ) returns 3
Check help file for more details.
Regards,
Jagan.
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
Hi Stephen,
you can use Index function in QlikView.
it is Similar to find in excel, instring in sql
regards,
Vijay