Search Results

All, appreciate your beautiful reply and it's making me sense to move forward, however I am stcuk and unable to finalize the command. Pls refer the details below.

Pls note that, deletion needs to...

Above solution is not working. Tried below statement, however nothing is happening.

echo "l_s := ' INSERT INTO TEST'"|sed "s/[^']*'/'/"

Expected Output
'INSERT INTO TEST'
...

Hi,
Need to delete line prior to (INSERT/UPDATE/DELETE). In case ' available, then keep that. Pls refet below details.

Input
======================
l_s := ' INSERT INTO TEST'
l_P...

Input
======================
l_s := ' INSERT INTO TEST'
l_P PD := ' UPDATE INTO TEST'
l_D := ' DELETE INTO TEST'
This is test

Input
======================
'INSERT INTO TEST'
'UPDATE INTO...

Hi,
Need to delete all the records prior to pattern (INSERT/UPDATE/DELETE). If ' is available, then need to retain it.

Input
======================
l_s := ' INSERT INTO TEST'
l_P PD := ' ...

Hi,
Need to delete all the records prior to pattern (INSERT/UPDATE/DELETE). If ' is available, then need to retain it.

Input
======================
l_s := ' INSERT INTO TEST'
l_P PD := ' ...

Hi,
Before insert, delete everything. If ' available before insert, then we need to keep this.

Input:
====
l_s := ' INSERT INTO TEST1'
INSERT INTO TEST2

Output:
====
'INSERT INTO TEST'...

Hi All,
I want to delete partial line before the INSERT.

Input:
l_s := ' INSERT INTO TEST'

Output:
INSERT INTO TEST'