Hi, Some of my events doesn't have an timestamp and its has been written as multiple line items in the log. I want to merge the multiple line items into previous line item Below are the examples, i want to merge the line items which doesn't have a timestamp, need to add it with previous line 2024-05-24 14:11:51.7212|INFO|Services.Voice.VoiceManager|Wake word detected. hey_mentor 2024-05-24 14:11:51.7212|INFO|Services.Sound.SoundManager|Playing Sound.VoiceStart_TEMP 2024-05-24 14:11:53.9271|INFO|Services.Voice.VoiceManager|Received command Spoken text: hey mentor turn off L E D Intent Name: ChangeImageTransformOnOff Intent Value: turn { OnOff off } { ImageTransformsOnOff L E D } Slot 1: OnOff=off Slot 2: ImageTransformsOnOff=L E D 2024-05-24 14:11:53.9271|INFO|NotificationService|Notify: [Illumination set to Off] 2024-05-24 14:11:59.5010|INFO|Services.Voice.VoiceManager|Wake word detected. hey_mentor 2024-05-24 14:11:59.5010|INFO|Services.Sound.SoundManager|Playing Sound.VoiceStart_TEMP 2024-05-24 14:12:01.8935|INFO|Services.Voice.VoiceManager|Received command Spoken text: hey mentor turn on L E D Intent Name: ChangeImageTransformOnOff Intent Value: turn { OnOff on } { ImageTransformsOnOff L E D } Slot 1: OnOff=on Slot 2: ImageTransformsOnOff=L E D 2024-05-24 14:12:01.8935|INFO|NotificationService|Notify: [Illumination set to On] 2024-05-24 14:12:01.8935|INFO|Services.Sound.SoundManager|Playing Sound.VoiceStop_TEMP 2024-05-24 14:12:06.7081|INFO|Controls.Live.LiveModel|IsReady=True, Pause << ------- Could any please help me how to write a query to achieve this.
... View more