Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Stack Internal
Knowledge at work
Bring the best of human thought and AI automation together at your work.
Explore Stack Internal Using GNU sed:
sed 'N;s/,\(\s*\n.*PRIMARY\)/)\1/;P;D' file ID_SOUR_CALENDAR BIGINT NOT NULL DEFAULT 0 COMPRESS 0 ) UNIQUE PRIMARY INDEX ( CALENDAR_DATE ); ID , ID_SOUR ) PRIMARY INDEX ( CALENDAR_DATE ); N Read/append the next line of input into the pattern space.P Print up to the first embedded newline of the current pattern space.D Delete up to the first embedded newline in the pattern space. Start next cycle, but skip reading from the input if there is still data in the pattern space. Using sed:
sed 'N;s/,\(\s*\n.*PRIMARY\)/)\1/;P;D' file ID_SOUR_CALENDAR BIGINT NOT NULL DEFAULT 0 COMPRESS 0 ) UNIQUE PRIMARY INDEX ( CALENDAR_DATE ); ID , ID_SOUR ) PRIMARY INDEX ( CALENDAR_DATE ); N Read/append the next line of input into the pattern space.P Print up to the first embedded newline of the current pattern space.D Delete up to the first embedded newline in the pattern space. Start next cycle, but skip reading from the input if there is still data in the pattern space. Using GNU sed:
sed 'N;s/,\(\s*\n.*PRIMARY\)/)\1/;P;D' file ID_SOUR_CALENDAR BIGINT NOT NULL DEFAULT 0 COMPRESS 0 ) UNIQUE PRIMARY INDEX ( CALENDAR_DATE ); ID , ID_SOUR ) PRIMARY INDEX ( CALENDAR_DATE ); N Read/append the next line of input into the pattern space.P Print up to the first embedded newline of the current pattern space.D Delete up to the first embedded newline in the pattern space. Start next cycle, but skip reading from the input if there is still data in the pattern space. Using sed:
sed 'N;s/,\(\s*\nPRIMARY\\s*\n.*PRIMARY\)/)\1/;P;D' file ID_SOUR_CALENDAR BIGINT NOT NULL DEFAULT 0 COMPRESS 0 ,) UNIQUE PRIMARY INDEX ( CALENDAR_DATE ); ID , ID_SOUR ) PRIMARY INDEX ( CALENDAR_DATE ); N Read/append the next line of input into the pattern space.P Print up to the first embedded newline of the current pattern space.D Delete up to the first embedded newline in the pattern space. Start next cycle, but skip reading from the input if there is still data in the pattern space. Using sed:
sed 'N;s/,\(\s*\nPRIMARY\)/)\1/;P;D' file ID_SOUR_CALENDAR BIGINT NOT NULL DEFAULT 0 COMPRESS 0 , UNIQUE PRIMARY INDEX ( CALENDAR_DATE ); ID , ID_SOUR ) PRIMARY INDEX ( CALENDAR_DATE ); Using sed:
sed 'N;s/,\(\s*\n.*PRIMARY\)/)\1/;P;D' file ID_SOUR_CALENDAR BIGINT NOT NULL DEFAULT 0 COMPRESS 0 ) UNIQUE PRIMARY INDEX ( CALENDAR_DATE ); ID , ID_SOUR ) PRIMARY INDEX ( CALENDAR_DATE ); N Read/append the next line of input into the pattern space.P Print up to the first embedded newline of the current pattern space.D Delete up to the first embedded newline in the pattern space. Start next cycle, but skip reading from the input if there is still data in the pattern space.