I tried to replace "^[^ ]+ [^ ]+ ([^ ]+).*$" with $1 in "create table leq_octave_5min ( recorded_time DATETIME CONSTRAINT pk1 PRIMARY KEY, leq5m FLOAT CONSTRAINT leq5m NOT NULL, min FLOAT CONSTRAINT min NOT NULL, max FLOAT CONSTRAINT max NOT NULL, L05 FLOAT CONSTRAINT 05 NOT NULL, L10 FLOAT CONSTRAINT 10 NOT NULL, L50 FLOAT CONSTRAINT 50 NOT NULL, L90 FLOAT CONSTRAINT 90 NOT NULL, L95 FLOAT CONSTRAINT 95 NOT NULL, FR01 FLOAT CONSTRAINT fr01 NOT NULL, FR02 FLOAT CONSTRAINT fr02 NOT NULL, FR03 FLOAT CONSTRAINT fr03 NOT NULL, FR04 FLOAT CONSTRAINT fr04 NOT NULL, FR05 FLOAT CONSTRAINT fr05 NOT NULL, FR06 FLOAT CONSTRAINT fr06 NOT NULL, FR07 FLOAT CONSTRAINT fr07 NOT NULL, FR08 FLOAT CONSTRAINT fr08 NOT NULL, FR09 FLOAT CONSTRAINT fr09 NOT NULL, FR10 FLOAT CONSTRAINT fr10 NOT NULL, FR11 FLOAT CONSTRAINT fr11 NOT NULL, FR12 FLOAT CONSTRAINT fr12 NOT NULL, FR13 FLOAT CONSTRAINT fr13 NOT NULL, FR14 FLOAT CONSTRAINT fr14 NOT NULL, FR15 FLOAT CONSTRAINT fr15 NOT NULL, FR16 FLOAT CONSTRAINT fr16 NOT NULL, FR17 FLOAT CONSTRAINT fr17 NOT NULL, FR18 FLOAT CONSTRAINT fr18 NOT NULL, FR19 FLOAT CONSTRAINT fr19 NOT NULL, FR20 FLOAT CONSTRAINT fr20 NOT NULL, FR21 FLOAT CONSTRAINT fr21 NOT NULL, FR22 FLOAT CONSTRAINT fr22 NOT NULL, FR23 FLOAT CONSTRAINT fr23 NOT NULL, FR24 FLOAT CONSTRAINT fr24 NOT NULL, FR25 FLOAT CONSTRAINT fr25 NOT NULL, FR26 FLOAT CONSTRAINT fr26 NOT NULL, FR27 FLOAT CONSTRAINT fr27 NOT NULL, FR28 FLOAT CONSTRAINT fr28 NOT NULL, FR29 FLOAT CONSTRAINT fr29 NOT NULL, FR30 FLOAT CONSTRAINT fr30 NOT NULL, status TEXT(2) CONSTRAINT st NOT NULL)".
The purpose was to get the third token, "leq_octave_5min".
The expected result string is "leq_octave_5min", but the actual result string is the input string itself.
What's wrong with my method?
