Discussion Board for collaboration on QlikView Scripting.
I have a field with values shown below. Is there a way to write a script to only get the ID after the last '_' sign as shown in the ID column?
Go to Solution.
You do need to use index if you have varying number of _. I did not see that the first time. Nicole is right.
I need to stop getting excited because I know the answer and read the full post first
=subfield(Value, '_', 4)
Many ways to do it, as of now I could get - Get the index of last '_', minus it from total length and extract it from right..
Right(Value, LEN(Value) - FindOneOf(Value,'_',SubStringCount(Value, '_'))) as ID
load Value,SubField(Value,'_',SubStringCount(Value,'_')+1) as ID
subfield(FieldName ,'_' ,-1)