Problem with tab seperated file in UNIX - The UNIX and Linux Forums

		The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
Problem with tab seperated file in UNIX

google unix.com

UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
UNIX FTP file problem	Vanilmirth	UNIX for Dummies Questions & Answers	4	07-10-2008 04:40 AM
Search and then concat 4m other file (comma seperated)	szchmaltz	UNIX for Dummies Questions & Answers	1	06-30-2008 02:45 AM
Handling .CSV( Comma seperated value) in awk	Laud12345	Shell Programming and Scripting	1	05-09-2005 04:41 PM
How to load comma seperated values file (*.csv) into Oracle table	handynas	UNIX for Advanced & Expert Users	4	06-24-2002 12:35 PM
How to load comma seperated values file (*.csv) into Oracle table	handynas	UNIX for Dummies Questions & Answers	5	06-04-2002 11:10 PM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

02-19-2009

pssandeep

Registered User

Join Date: Dec 2007

Posts: 35

Problem with tab seperated file in UNIX

Hi All,

I am facing a problem while getting the data from an Oracle table

Problem:

I am getting rows from an Oracle table to a tab seperated file.

One of the columns in that table have value with in between spaces like

AAAAA AAA

It's loading fine to .tab file.
But when opening in an excel it showing it in another column like

AAAAA as 1 column & AAA as another column

I cannot use "AAAAA AAA" in tab file, because when they open the tab file" should not appear

please advice

Regards,
Sandeep

Bookmarks

« use variable for sed print line | How to skip first line from a file while manupulating the file »

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 10:50 AM.