Discussion Board for collaboration on QlikView Scripting.
After a lot of trial, error and searching the forums i cannot seem to come with a conclusion to my issue. If anyone can help that would be greatly appreciated.
I'm trying to drop all characters (numeric or non-numeric) after a word in a field is detected:
I want to be able to drop EVERYTHING after "router" is found in the field resource and keep everything before it
Thanks in advance!
Go to Solution.
subfield([resource],'router',1) & 'router'
Testing if 'router' is present
Thank you Gysbert! That was a quick, easy solution.