There are two types of raw data. What is the regular expression to get the value between the /* special symbol and the */ special symbol in the raw data?
I tried this regex but it doesn't work
rex field=query "^[^/\n]*/\*(?P<test>[^\*]+)"
DATA1
SELECT /*4/18 test */ DRTA_SEQ\r\n FROM DATA_REQ_LIST\r\n WHERE DATE < TO_DATE('2023-04-18 06:00:00', 'YYYY-MM-DD HH24:MI:SS')\r\n
DATA2
with my_index as (\n select index_name from ALL_indexes where table_owner = :1 \n /* test select index_name from CHAN_indexes where table_owner = :schema_name and table_name in ( :[*object_names] )\n *//* test select * from Chanlist */
I want this string to be extracted
DATA1
4/18 test
DATA2
test select index_name from CHAN_indexes where table_owner = :schema_name and table_name in ( :[*object_names] )\n
test select * from Chanlist
... View more