Get Column Data

theref · #1 06-21-2012

Hi

I have a file which contains customer data...

Quote:

200000000000000475559xxxxxxxxxxxxCARDCX10 GBMRS. xxx xxxxxx xxxx xxxxxxx & CO LTD xxx xxxxxx ROAD ^I COLCHESTER ESSEX^I xxx xxx xxxx.xxxxx@GOOGLEMAIL.COM 0000000000000912906R0000000000000000000000000000 07509207499

I need to be able to strip out everything from the file so I am only left with the order number (0000000000000912906R)

The lenght of the columns can vary depending on the name, address etc but it appears that the order number is the second from last column.

Any help would be greatly appreciated.

alister · #2 06-21-2012

In AWK you can refer to the next to last field using $(NF-1) .

Regards,
Alister

Thread Tools	Search this Thread
Show Printable Version Email this Page Subscribe to this Thread	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Replace column that matches specific pattern, with column data from another file	prashali	Shell Programming and Scripting	7	05-15-2012 04:17 PM
Need to extract data from Column having variable length column	ns64110	Shell Programming and Scripting	6	01-30-2012 08:19 AM
row to column and position data in to fixed column width	baluchen	Shell Programming and Scripting	4	03-15-2010 06:46 AM
Split Data in one column into 2 column in Excel using DOS or VBScript	dashing201	Windows & DOS: Issues & Discussions	3	03-12-2010 05:04 AM
Extract data based on match against one column data from a long list data	patrick87	Shell Programming and Scripting	12	11-17-2009 03:27 AM