AWK CSV to TXT format, TXT file not in a correct column format

mdap · #1 (**permalink**) 08-13-2008

HI guys,

I have created a script to read 1 column in a csv file and then place it in text file.

However, when i checked out the text file, it is not in a column format...

Example:
CSV file contains
name,age
aa,11
bb,22
cc,33

After using awk to get first column
TXT file contains
name[]aa[]bb[]cc

the [] are box characters.

the command used is:

cat file1.csv | awk -F "," '{print $1}' > file2.txt

do you have any idea why this is happening?

Could this be resolved?

Thanks,
Martin

mdap · #2 (**permalink**) 08-14-2008

HI guys,

Just disregard this post. I just found out that columns are working fine..

mdap

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Option in sql script to include column headers when spooling file to .csv format	Vijaya	UNIX for Dummies Questions & Answers	3	06-10-2009 02:47 PM
How to print log file in column format using awk	suresh3566	Shell Programming and Scripting	2	05-06-2008 02:18 PM
To convert multi format file to a readable ascii format	gaur.deepti	UNIX for Dummies Questions & Answers	5	03-25-2008 03:03 PM
Correct format in a log file	sd12	UNIX for Advanced & Expert Users	11	12-12-2007 06:40 PM
Convert UTF8 Format file to ANSI format	rajreddy	UNIX for Advanced & Expert Users	1	05-24-2007 07:40 AM

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 Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by