Shell Programming and Scripting

I have a customer file now and would like to separate the names into two cells in a spreadsheet. Here is my data as an example:

SHAWN R KEEGAN
shawn r scroggin
Shawn Regan
Shawn Reilly

The first two have the middle initial so I'd like to include them in the "first name" field and the last name in the "last name" field. So what I need is a script to suck in the names in a text file and replace the last space in each line with a pipe so my data would look like this when converted:

SHAWN R|KEEGAN
shawn r|scroggin
Shawn|Regan
Shawn|Reilly

Best option please? I've searched the forum here and not found a way to do this specific example.

Easy, the bourne shell read builtin splits on IFS (which is by default whitespace) and trims. [edit] fixed to arrange middle initials properly.

Code:

#!/bin/sh

while read A B C
do
        if [ ! -z "${C} ] 
        then
                echo "${A} ${B}|${C}"
        else
                echo "${A}|${B}"
        fi
        C=""
done < input > output

Sorry, I should have specified but I only really know Perl. Can you put it in layman's terms using Perl?

Hi,

Using 'perl':

Code:

$ perl -lpe 's/^(.*)\s+(.*)$/\1|\2/' infile

Regards,
Birei

Consider this your introduction to a scripting language that doesn't resemble line noise, then.

For the record
Using sed:

Code:

tukuyomi@debian:~/unix.com$ cat name
SHAWN R KEEGAN
shawn r scroggin
Shawn Regan
Shawn Reilly
tukuyomi@debian:~/unix.com$ sed -r 's/(.*) (.*)$/\1|\2/' name
SHAWN R|KEEGAN
shawn r|scroggin
Shawn|Regan
Shawn|Reilly

Code:

awk '$NF="|"$NF' infile