Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
Input :
A|B|C|D
A|B|C|D|E
Output :
D
D|E
Thanks
Why D & E for second row? If only E try this?
SubField(Field, '|', -1)
But i required ,
D
D|E
like this , otherwise it is so simple.
Thanks
That is fine, Can you explain your business? Or at least 5 Rows and expected result?
Hi All,
Even I need help on the same scenario, need all the characters after the 3rd occurrences, 4th occurrence should not be considered.
3rd occurrence of the '|' is before 'D' need all the characters after it. D|E|F or so on need all the string after it.
Thanks in advance..
Regards,
Arjun
Test:
LOAD
F1,
Right(F1,Len(F1)-Index(F1,'|',3)) as F2
INLINE [
F1
A|B|C|D|E|F
A|B|C|D|E
A|B|C
A|B|C|D
A|B
];