Search Results

I tried this and it simply added the pipe at the end of each customer record as follows:

customer.txt file includes:

SHAWN R KEEGAN
shawn r scroggin
Shawn Regan
Shawn Reilly

Script:

...

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

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...