Exporting data into Comma Delimiter.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Exporting data into Comma Delimiter.
# 1  
Old 05-09-2011
Exporting data into Comma Delimiter.

Hi,

Requirement: Exporting data from Oracle to UNIX into "Comma" delimiter.

Help Needed: I was able to connect to Oracle and import the data. But please let me know while importing the data I need to make it into Comma delimiter flat file.

For Example:
Source Data -
100 ABC TLead
200 XYZ PManager
300 LMN PLead

Target Data to be loaded into Flat File -
100,ABC,TLead
200,XYZ,PManager
300,LMN,PLead

Thanks in advance for your reply.
# 2  
Old 05-09-2011
you can try this...

Code:
 
sed -e  's/^[ ]*//g'  -e  's/\([0-9a-zA-Z\.]*\)  */\1,/g' inputfile

Regards,
Usha
This User Gave Thanks to usha rao For This Post:
# 3  
Old 05-09-2011
else, u can write Oracle query which give u comma seperated output

select EMP_ID||','||EMP_NAME||','||LOCATION FROM EMP;
This User Gave Thanks to ace_friends22 For This Post:
# 4  
Old 05-09-2011
Thanks for your replies.

Hi Usha,

Now i am facing another issue.
Source:
8-9KH-1733 07-NOV-08 8-1729UB 04-DEC-08 8-1729UB 1 8-9KH-1733 N Y N N N Y Y Y
8-9KH-4221 07-NOV-08 8-1729UB 07-NOV-08 8-1729UB 0 8-9KH-4221 N Y N N N Y Y Y
8-9KH-534 07-NOV-08 8-1729UB 07-NOV-08 8-1729UB 0 8-9KH-534 N Y N N N Y Y Y
8-9KH-2596 07-NOV-08 8-1729UB 07-NOV-08 8-1729UB 0 8-9KH-2596 N Y N N N Y Y Y
8-9KH-448 07-NOV-08 8-1729UB 07-NOV-08 8-1729UB 0 8-9KH-448 N Y N N N Y Y Y

Target:
I need to remove the SPACES and instead of SPace i need to add a Comma delimiter.

Thanks for your reply.
# 5  
Old 05-09-2011
Excellent !!!

Thanks alot guys Smilie
# 6  
Old 05-09-2011
A perl :
Code:
perl -pne 's/\s+[^\n]/,/g' file

---------- Post updated at 02:30 PM ---------- Previous update was at 02:24 PM ----------

This is the right one Smilie:
Code:
perl -pne 's/\s+([^\s+])/,\1/g' file

---------- Post updated at 02:30 PM ---------- Previous update was at 02:30 PM ----------

This is the right one Smilie:
Code:
perl -pne 's/\s+([^\s+])/,\1/g' file

This User Gave Thanks to Klashxx For This Post:
# 7  
Old 05-09-2011
With awk:
Code:
awk '$1=$1' OFS=\, file

This User Gave Thanks to Franklin52 For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Insert a new column with sequence number (Delimiter as comma)

Hi All, I have a file which has data like a,b c,d e,f g,h And I need to insert a new column at the begining with sequence no( 1 to n) 1,a,b 2,c,d 3,e,f 4,g,h Please let me know how to acheive this in unix (3 Replies)
Discussion started by: weknowd
3 Replies

2. Shell Programming and Scripting

Replace comma delimiter by newline

The input file is as below AR,age,marks,roll,section,evin,25,80,456,A,atch,23,56,789,B,eena,24 ,78H245,C,Ps,ot,ecessary,hat,ame comes first then age and rest AR AZ,kevin,25,80,456,A,Satch,23,56,789,Satch,23,56,789,B,Meena,24,78,H245,C,AZ ................ ................ I am writting... (8 Replies)
Discussion started by: millan
8 Replies

3. Shell Programming and Scripting

Change the delimiter from Comma to Pipeline

Hello All, I need to convert a csv file to pipeline delimiter file in UNIX. The data in file itself contains comma with double qouted qualifier apart from the comma separator. Let me know how to do it. Appreciate any help if awk can be used to do it. Mentioned below is the sample record of... (14 Replies)
Discussion started by: Arun Mishra
14 Replies

4. Shell Programming and Scripting

Substituting comma "," for dot "." in a specific column when comma"," is a delimiter

Hi, I'm dealing with an issue and losing a lot of hours figuring out how i would solve this. I have an input file which looks like this: ('BLABLA +200-GRS','Serviço ','TarifaçãoServiço','wap.bla.us.0000000121',2985,0,55,' de conversão em escada','Dia','Domingos') ('BLABLA +200-GRR','Serviço... (6 Replies)
Discussion started by: poliver
6 Replies

5. Shell Programming and Scripting

nawk won't accept comma as delimiter

I have a text file delimited by commas, with three fields (no " marks). I want to use awk to create a fourth field which is equal to the line number + field 1 + .txt I've searched this forum and found the following nawk -v OFS=';' '{print $0, FNR}' myFile Which I've amended to change the... (2 Replies)
Discussion started by: b.hamilton
2 Replies

6. UNIX for Dummies Questions & Answers

Making a Tab delimiter file to Comma

How can i make a tab delimiter file to a comma delimiter??? (13 Replies)
Discussion started by: saggiboy10
13 Replies

7. Shell Programming and Scripting

Replacing Comma delimiter coming inside the data.

Hello, I am having flat file (Comma Delimiter) and the data in the file is as given below. EMPNO, ENAME, DESIGNATION, SALARY 10979, Arun Kumar, Cosultant, 35000 13555, Bidhu Shekar, Senior Consultant, 45000 15000, Kiran, Kumar, Senior, Consultant, 40000 If... (9 Replies)
Discussion started by: arunvasu2
9 Replies

8. Shell Programming and Scripting

Pull Data After Comma if 2 word before comma

Hi, I am trying to truncate word after comma in a file ONLY if there are already 2 words BEFORE comma. If there is one word or 3 or more words BEFORE comma, then I have to leave the data AS IS. See below for example. Input File : John Smith, Manager Smith, John Frank J F K... (2 Replies)
Discussion started by: msalam65
2 Replies

9. Shell Programming and Scripting

comma delimiter and space

I have a csv file and there is a problem which I need to resolve. Column1,Column2,Colum3,Column4 ,x,y,z ,d,c,v t,l,m,n ,h,s,k ,k,,y z,j, ,p Now if you see column1 for row 1 and row 4 though they are null there is a space but in case of row2 and row 5 there is no space. I want row... (3 Replies)
Discussion started by: RubinPat
3 Replies

10. Windows & DOS: Issues & Discussions

Exporting data

My friend's boss has asked me to help update a customer database. They have a limited amount of space and have asked if I can do this from my home computer. She is working on a Unix system with a program called Accuterm. My understanding is that this program is a dedicated program for the... (0 Replies)
Discussion started by: clearchoice
0 Replies
Login or Register to Ask a Question

Featured Tech Videos