transforming records


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting transforming records
# 8  
Old 06-13-2010
ok
my system
Code:
SunOS test01 5.10 Generic_138888-01 sun4u sparc SUNW,Sun-Fire-280R

an error:
Code:
awk: syntax error near line 1
awk: illegal statement near line 1
awk: syntax error near line 1
awk: illegal statement near line 1

# 9  
Old 06-13-2010
Check if you have gawk installed.
# 10  
Old 06-13-2010
2bartus11
no
only awk and nawk
# 11  
Old 06-13-2010
The easiest way to solve that problem is to install gawk Smilie I think it is included in Solaris 10 Companion CD.

You could also use Perl:
Code:
perl -pe 's/,/ /g;s/\"([0-9]+) ([0-9]+)\"/\1,\2/g' infile


Last edited by bartus11; 06-13-2010 at 01:12 PM.. Reason: Perl solution
This User Gave Thanks to bartus11 For This Post:
# 12  
Old 06-13-2010
shizik,
what's wrong with the sed approaches in the other thread?
# 13  
Old 06-13-2010
2bartus11
thanks a lot
# 14  
Old 06-14-2010
try below perl

Code:
my $str='0,1,0,87,0,0,"6,87","170,03",0,"43,5",0,0,0,0,"6,87","126,53"';
$str=~s/(,)(?=
[^"]*$
|
(?:(?:[^",]*,)*(?:"[^"]*",)*(?:[^",]*,)*)*(?:[^",]+|"[^"]*")$
)/  /xg;
$str=~s/"//g;
print $str;

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