I am trying to match string "RAV" on every line on 15th word. Each word is delimited by "|" (pipe). I need to compare if line has this string or not. If yes, I will proceed with my next step.
I was trying this
((((?:[^|]*\|){17}(.*?)\|)+\|[^|]*$)|[^|]+(?=(\,\H\,))|(^([0-9]){4})|(([RAV]){3}))
But this one matches even if I have "RAV" first, second or any other fields.
I need to match exactly on 15th field.