i have a string
14/04/2020|A3|ABC149251|text i really need
can i run something which will trim this string from the end till it get 1st | (pipe symbol)?
i tried rex for this but some error is coming which i am not able to resolve, so thought of taking it the above way.
regular expression i am trying is
(?^\d{2}\/\d{2}\/\d{2,4}|A\d|\ABC\d*|)(?[\w*\s-]+).
getting below error
Error in 'rex' command: Encountered the following error while compiling the regex '(?^\d{2}\/\d{2}\/\d{2,4}|A\d|\INC\d*|)(?[\w*\s-]+)': Regex: unrecognized character follows .
please either correct my regex or let me know how to trim
Hi
You can try this also
| makeresults
| eval str="14/04/2020|A3|ABC149251|text"
| rex field=str "(?P<output>[^|]+)$"
your search
| eval result=mvindex(split(_raw,"|"),-1)
no need rex
lovely
it's working
thanks 🙂
you're welcome and please accept the answer.
Hi
What is your expected output?
output i am expecting : text i really need