How to read the first column in a flat file with ~ as delimiter

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
How to read the first column in a flat file with ~ as delimiter

google unix.com

Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
how to read fixed length flat file....	willywilly	Shell Programming and Scripting	2	08-04-2009 08:02 AM
Flat File column manipulation	net	Shell Programming and Scripting	5	03-05-2009 03:14 AM
Converting Column to Rows in a Flat file	srinikal	Shell Programming and Scripting	5	10-10-2008 04:32 PM
How to read lines from a flat file	bihani4u	Shell Programming and Scripting	2	09-28-2006 02:54 PM
Look up column in a flat file	jambesh	Shell Programming and Scripting	5	09-18-2006 06:44 AM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

3 Weeks Ago

siri_886

Registered User

Join Date: Jul 2009

Posts: 16

How to read the first column in a flat file with ~ as delimiter

I have one flat file like below

id1~col~batch1
id2~col2~batch2
id3~col3~batch3

I need to read the first column one by one and I need to write one db2 query based on that column1
Like
for (i=0;i<=10;i++)
do
insert into table column (con_id) values (select column from table where id=$i)
done<input_file

Here i should be id1,id2 & id3 etc...
something like this..
Can you please help me in reading the first column of the flat file and how can I use that value in the query.

Thanks in advance.

Bookmarks

« awk to select rows based on condition on column | CVS file operation in Perl »

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 02:07 AM.