How to structure into JSON unstructured STRING data with Lenses SQL?

Lenses
1

I have unstructured events such as a STRING in a Kafka topic. Such as this:

SSM
LT
07APR00001C001
RPL
UA024
17MAY22 03JUN22 1234567
J 76L J55O11Y99
LHR1110 EWR1622
QQAAWR 97/C
LHRAQQ 99/2

Can I process and structure it using Regex into JSON/AVRO/PROTOBUF in a streaming SQL application?

2

You can use the REGEX function in the Lenses SQL engine to extract the field. Such as:

INSERT INTO myTargetTopic
   SELECT STREAM
      REGEX(_value, "[A-Z]+") as myField,
      FROM mySourceTopic