Shell Programming and Scripting

That's a whole lot going on there...

Try this:

Code:

grep INSERT NEWOUTPUT | perl -pe 's/^\n//;s/^(\d+) (.*?)(\);)/$2, $1$3/g'

INSERT INTO Opera_ShirtCatlog(col1,col2) VALUES (1,'TEST1'),(2,'TEST2', 1389685);
INSERT INTO Opera_ShirtCatlog_Wom(col1, col2, col3) VALUES (9, 'Siz12, FormFit', 'Test', 1389675);

in2nix4life,

I just dont like to say this but Its not doing anything.No errors no action output is just the same as ever before ....



regards,
Manohar.

---------- Post updated at 07:29 PM ---------- Previous update was at 06:07 PM ----------

Smartfolks,

Can someone please post an answer to my query up here as I have spent pretty much all day but I am back to where I was and the given perl solution is not working. I tried to substitute the value of ") VALUES" with ",LASTSTRING) VALUES" using simple sed replace.

However the Critical part of moving the first string into the string where its pushed as the last value using closing parenthesis is not working for me and I know this for sure that SED should do it but I am not getting it.

Please advise.

regards,
Manohar.

regards,
Manohar.

You give no explanation of why the following is used:

Code:

$cat NEWOUTPUT | grep 'INSERT' | cut  -f 5- | awk '{print $2=$3=$4=""}1'

If the file contains the following as you initially explained:

Code:

INPUT LINE 1-
1389685 INSERT INTO Opera_ShirtCatlog(col1,col2) VALUES (1,'TEST1'),(2,'TEST2');

OUTPUT LINE 1- 
INSERT INTO Opera_ShirtCatlog(col1,col2, FIRSTCOL) VALUES (1,'TEST1', 1389685),(2,'TEST2', 1389685);

Why use all of those commands? Of course the solution I gave doesn't work cause you're including a bunch of what seems to be unnecessary commands.

in2nix4life,

Yes, I needed all these commands to get it to the current state where in, all I am left with is, to finally move in the first set of numbers as a last value before closing the paranthesis. I tried to do what I can by pushing the cart as far as I can and thats exactly what I did in here. So, the first set of commands bought the data to this point.

But, If you want to tackle the raw line itself sure ... Here it is.


#### 3601 0089 22360 1389675 INSERT PARTITION_443 Opera_ShirtCatalog INSERT INTO Opera_ShirtCatalog(COL1, COL2) VALUES (1, 'TEST1'), (2,'TEST2');
#### 12001 0093 22362 1389685 INSERT PARTITION_454 Opera_ShirtCatlog_Wom INSERT INTO Opera_ShirtCatlog_Wom(col1, col2, col3) VALUES (9,'Siz12, FormFit', 'Test');

Also, let me re-hash as to what is needed in here.

All I need out of this, is from the insert statement onwards, I need to print the rest of line ie., from INSERT INTO …. till ";" which is the end of the line. The trickiest part in here is, I need to yank the 5th column and move that as the last column inside the values clause. So, what I would necessarily want to see as final output would be as below -

INSERT INTO Opera_ShirtCatalog(COL1, COL2, NEWCOLUMN) VALUES (1, 'TEST1', 1389675), (2,'TEST2', 1389675);
INSERT INTO Opera_ShirtCatlog_Wom(col1, col2, col3, NEWCOLUMN) VALUES (9,'Siz12, FormFit', 'Test', 1389685);

Hope you understand my situation with this and hope I am clear in what I need to do.