Skip to main content
Unix & Linux

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

3
  • any idea on how to do this using the AWK command to return the AP - after further testing i found out that there are also numbers with different starting two letters. So was thinking for this to work in all environments best to just use awk and return the column with the numbers rather then narrowing it down to AP as there are many others such as PR AD Commented May 14, 2020 at 9:40
  • @Nikhil You shouldn't really accept an answer if it doesn't solve your issue. Also, we can only see the data that you include in your actual question, so if the data there is not representative of what you have, then we can't really do much about it. Please update your question. Also, I will never use awk to parse XML, it is definitely not the correct tool for that job. Commented May 14, 2020 at 9:43
  • Apologies, i am new to stack exchange. I accepted the answers as at the time they were the right outcome for me. However after further testing found out that the AP part was not static, it could be any letters hence why i was asking regarding the awk command, i have made changes to my question in the meantime, ta Commented May 14, 2020 at 9:55