Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

transforming records

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting transforming records
# 1  
Old 06-13-2010
transforming records
Hi all
In input file I have records like this:
Code:
0,1,0,87,0,0,"6,87","170,03",0,"43,5",0,0,0,0,"6,87","126,53"

and in output file I need that these records transforms in :
Code:
0 1 0 87 0 0 6,87 170,03 0 43,5 0 0 0 0 6,87 126,53

Could you help me in this case? Please
# 2  
Old 06-13-2010
Please read the The UNIX and Linux Forums - Forum Rules and do not cross/multiple post

sed problem
# 3  
Old 06-13-2010
Code:
awk '{gsub(","," ");$0=gensub("\"([0-9]+) ([0-9]+)\"","\\1,\\2","g");print}' infile

# 4  
Old 06-13-2010
2bartus11

not working
# 5  
Old 06-13-2010
What does
Code:
awk --version

say?
# 6  
Old 06-13-2010
nothing (((
# 7  
Old 06-13-2010
There is not even an error message? What system are you running? You need to be more specific if you want us to help you.
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Transforming data so it looks like the one you specified

Lets say for instance I have this data within a file named transform xxx#yyy@zzz and I want it to be in the format ofZZZ xxx-yyy How do I go about doing this? (3 Replies)
Discussion started by: l3monz
3 Replies

2. Programming

Transforming 3 columns to matrix format

Dear All I have a huge data for 3 columns similar to this D2cls0 D2cls0 1 D2cls0 D2cls1 0.308 D2cls0 D2cls2 0.554 D2cls0 D2cls3 0.287 D2cls0 D2cls4 0.633 D2cls0 D2cls5 0.341 D2cls0 D2cls6 0.665 D2cls0 D2cls7 0.698 D2cls0 D2cls8 0.625 D2cls0 D2cls9 0.429 I... (9 Replies)
Discussion started by: bala06
9 Replies

3. Programming

Transforming data to other format

Dear All I would like to transform data from one format to another format. my Input: 0 0 1 0 1 0.308 0 2 0.554 0 3 0.287 output: Z (0,0)= 1 Z (0,1)=0.308 Z (0,2)=0.554 Z (0,3)=0.287 (2 Replies)
Discussion started by: bala06
2 Replies

4. UNIX for Dummies Questions & Answers

Log transforming a column in a text file?

How do you log transform a column in a text file? Thanks! :o (1 Reply)
Discussion started by: evelibertine
1 Replies

5. UNIX for Advanced & Expert Users

Transforming psmf to ogv

Hi all. I would like to create a program that converts psmf file format (PSMF - MultimediaWiki) to ogv (Ogg - Wikipedia, the free encyclopedia). I know C++ and I worked with BMPs (so I can understand a simple file system like the BMP header is) but I didn't touch any kind of sound/video file... (1 Reply)
Discussion started by: lilezek
1 Replies

6. UNIX for Dummies Questions & Answers

transforming small javascript into perl

I need to transform this small javascript into a perl. So then when I need to use it I can call $something, instead of using this javascript. Could someone help me archive this? (9 Replies)
Discussion started by: marringi
9 Replies

7. Shell Programming and Scripting

Help Required In Transforming A File

How will i convert a file <LREC><L:EPOCH>1198331268.553</L:EPOCH><LDATE>10-12-07</LDATE><L:SERVER>NONE</L:SERVER><L:PORT>NONE</L:PORT><LTIME>13:47:48.553</LTIME><LTEXT>dnvdmxk</LTEXT></LREC>... (3 Replies)
Discussion started by: anju
3 Replies
Login or Register to Ask a Question