Help Required In Transforming A File


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help Required In Transforming A File
# 1  
Old 01-15-2008
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>
<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>
<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>

to this
<LDATE>10-12-07</LDATE><LTIME>13:47:48.553</LTIME><LTEXT>dnvdmxk</LTEXT>
<LDATE>10-12-07</LDATE><LTIME>13:47:48.553</LTIME><LTEXT>dnvdmxk</LTEXT>
<LDATE>10-12-07</LDATE><LTIME>13:47:48.553</LTIME><LTEXT>dnvdmxk</LTEXT>

Basically i want some portions of a file to be merged and form a new file

anju
# 2  
Old 01-15-2008
Code:
sed 's/.*\(<LDATE>.*<\/LDATE>\).*\(<LTIME>.*<\/LTIME>\).*\(<LTEXT>.*<\/LTEXT>\).*/\1\2\3/g' "file"

# 3  
Old 01-15-2008
you can do like this by cut :
ex
input is your file
cut -c 40-62 ch1-ch2 ch3-ch4input
<LDATE>10-12-07</LDATE>
<LDATE>10-12-07</LDATE>
<LDATE>10-12-07</LDATE>
# 4  
Old 01-15-2008
Bug

Quote:
Originally Posted by ghostdog74
Code:
sed 's/.*\(<LDATE>.*<\/LDATE>\).*\(<LTIME>.*<\/LTIME>\).*\(<LTEXT>.*<\/LTEXT>\).*/\1\2\3/g' "file"

thank you so much...!!!!! it worked
Login or Register to Ask a Question

Previous Thread | Next Thread

8 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 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 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

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

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

7. Shell Programming and Scripting

Getting required fields from a test file in required fromat in unix

My data is something like shown below. date1 date2 aaa bbbb ccccc date3 date4 dddd eeeeeee ffffffffff ggggg hh I want the output like this date1date2 aaa eeeeee I serached in the forum but didn't find the exact matching solution. Please help. (7 Replies)
Discussion started by: rdhanek
7 Replies

8. 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
Login or Register to Ask a Question