topic Parse a string with special characters in DQL

Parse a string with special characters

slhempen — Fri, 04 Sep 2026 13:37:35 GMT

I have this string in a message field that needs to be parsed. I need the values between the double quotes extracted into separate fields. I am having a hard time getting the correct syntax to handle eliminating '<', '/>', and '"'.

Thanks,

Steve

Re: Parse a string with special characters

dannemca — Fri, 04 Sep 2026 14:30:00 GMT

A very simple parsing would be:

LD 'Robotics UseCase="' LD:RoboticUseCase '"' LD 'Workstation="' LD:Workstation '"' LD 'UserID="' LD:UserID '"' LD 'Department="' LD:Department '"' LD 'Segment="' LD:Segment '"' LD 'Automation="' LD:Automation '"' LD 'MessageType="' LD:MessageType '"' LD 'Message="' LD:Message '"' LD 'ClaimNumber="' LD:ClaimNumber '"' LD 'TaskID="' LD

The only field not able to include in the above parsing rule was the TaskID since empty, and will requires a different parsing rule.

Try and let us know.