Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Transforming data so it looks like the one you specified

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Transforming data so it looks like the one you specified
# 1  
Old 08-03-2014
Transforming data so it looks like the one you specified
Lets say for instance I have this data within a file named transform
Code:
xxx#yyy@zzz

and I want it to be in the format of
Code:
ZZZ xxx-yyy

How do I go about doing this?
# 2  
Old 08-03-2014
Try something like:
Code:
awk -F'#' '{printf("%s %s-%s\n", toupper($3), $1, $2)}' transform

If you want to try this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk, /usr/xpg6/bin/awk, or nawk.
# 3  
Old 08-03-2014
Quote:
Originally Posted by Don Cragun
Try something like:
Code:
awk -F'#' '{printf("%s %s-%s\n", toupper($3), $1, $2)}' transform

If you want to try this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk, /usr/xpg6/bin/awk, or nawk.
Hmm inputting that gave me an incomplete transformation. Result:
Code:
xxx-yyy@zzz

# 4  
Old 08-03-2014
Sorry, I misread your input format. Change my suggestion to:
Code:
awk -F'[#@]' '{printf("%s %s-%s\n", toupper($3), $1, $2)}' transform

 
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. 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

2. 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

3. UNIX for Dummies Questions & Answers

Log 2 transforming the column of a text file

I have a tab delimited text file. I want to log 2 transform the fifth column of the file. How do I go about doing that? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies

4. 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

5. Shell Programming and Scripting

transforming records

Hi all In input file I have records like this: 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 : 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 (13 Replies)
Discussion started by: shizik
13 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