I know this has been asked before, but i can't find a good answer. I did open a ticket, but think this should be easier. I am passing an alert to a pagerduty api. When i post to the api and the variable has crlf in it, it bombs. That does not surprise me. I am looking for a work around or if there is something similar i can use to perls chomp. The variable in question is:
"Description": "porkypine ${N=SwisEntity;M=NodeDescription} I like big butts ${NodeID} she is a winner",
I always add debugging stuff here 
. Anyways, the node.description from cisco devices that are specifically ios xr routers are giving me the issue. The output of the sql query is:
Cisco IOS XR Software (Cisco ASR9K Series), Version 5.1.3[Default]
Copyright (c) 2014 by Cisco Systems, Inc.
This works as expected:
Cisco IOS XR Software (NCS-5500), Version 6.5.3 Copyright (c) 2013-2019 by Cisco Systems, Inc.
