Shell Programming and Scripting

Hi

consider this as the first line
00010015 MORGAN STANLEY & CO INCORPORATED N 110 INVESTAR 1 0001OT NJ 201-830-5055 01-Jan-1974 00:00:00 1 01-May-2008 00:00:00 05-Jun-2008 13:34:18 0001 - From SMSRun1_GIDQA02
Consider this as the second line
00010015 MORGAN STANLEY & CO INCORPORATED N 110 INVESTAR 1 0001OT NJ 201-830-5055 01-Jan-1974 00:00:00 1 01-May-2008 00:00:00 05-Jun-2008 13:34:18 0001 egesdegjeog rogjeogje - From SMSRun1_GIDQA02

Here i need to cut "- From SMSRun1_GIDQA02" from the end of each line and need to append it at the front as "From SMSRun1_GIDQA02 - ". So that the output looks like

From SMSRun1_GIDQA02 - 00010015 MORGAN STANLEY & CO INCORPORATED N 110 INVESTAR 1 0001OT NJ 201-830-5055 01-Jan-1974 00:00:00 1 01-May-2008 00:00:00 05-Jun-2008 13:34:18 0001

But the problem here is that the position of "- From SMSRun1_GIDQA02" might vary from line to line since there might be odd number of columns.Can "- From" be taken as a key to cut "- From SMSRun1_GIDQA02" and append it to the front?

With sed:

Code:

sed 's/\(.*\)\( - \)\(.*\)/\3\2\1/' file > newfile

Regards

Thanks. Can you please explain it?

Regards,

Ragav.

Code:

 sed 's/\(.*\)\( - \)\(.*\)/\3\2\1/' file > newfile

With \(.*\) you can select portions of a string. This portion is recalled in the replacement string with \1, \2, \3 etc.

The first portion is the begin of the string until the space before the last minus sign (before " - From").
The second portion are the 3 characters " - " before "From" and the last portion is the rest of the line.
In the replacement string the portion is recalled in the order \3\2\1.

Have a read of a sed tutorial, you can find some links here:

https://www.unix.com/answers-frequent...tutorials.html

Regards