AnsweredAssumed Answered

PDM_Load on Call_Req: Handle CRLF in description

Question asked by JDiegelIV on May 18, 2017
Latest reply on May 27, 2017 by TMACUL

If you're running PDM_Load for the Call_Req table, how do you handle the "description" value when it has more than one line? It might be hard to see it here but there is a CRLF between 11:48 and SOLUTION.

 

TABLE Call_Req
external_system_ticket type active_flag
category log_agent requested_by status group_id summary description

{ "HPOV:962730" ,"R" ,"1" ,"pcat:404101","U'0D74E711B6906745812ACB51801BD135'","U'0D74E711B6906745812ACB51801BD135'","CL" ,"U'64C899EE838C4440AD4099B422E3B7D1'","Test, Test D~R~TELEPHONE~Test, Test J~****W4RESPONSE 1/8" ,"R~TELEPHONE~Test, Darnell J~05-JAN-15~Test, Test, 01/08/2015 11:48
SOLUTION" }

Outcomes