Extract all string after special character

[agni_gold]

Hi All , 

Input : 

A|B|C|D
A|B|C|D|E

Output : 

D

D|E

Thanks

[Anil_Babu_Samineni]

Why D & E for second row? If only E try this? 

SubField(Field, '|', -1)

[agni_gold]

But i required , 

D

D|E

like this , otherwise it is so simple.

Thanks

[Anil_Babu_Samineni]

That is fine, Can you explain your business? Or at least 5 Rows and expected result?

[sunny_talwar]

There is a special character before B and C too... why only extract D and E?

[arjun2b]

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

[cwolf]

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
];