Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Log 2 transforming the column of a text file

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Log 2 transforming the column of a text file
# 1  
Old 08-03-2011
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!
# 2  
Old 08-03-2011
How big and fast? I would say PERL: google for "PERL read delimited file array tutorial" (did that already today), google for "PERL math lib log base tutorial" and maybe google for some help with floating point from string (like C atof() )and to string (printf() and similar). You want newval=log2(oldval)?

If you map the file into an RDBMS text tool, you can SQL update it.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Compare 2 text file with 1 column in each file and write mismatch data to 3rd file

Hi, I need to compare 2 text files with around 60000 rows and 1 column. I need to compare these and write the mismatch data to 3rd file. File1 - file2 = file3 wc -l file1.txt 58112 wc -l file2.txt 55260 head -5 file1.txt 101214200123 101214700300 101250030067 101214100500... (10 Replies)
Discussion started by: Divya Nochiyil
10 Replies

2. Shell Programming and Scripting

Want to format column of a text file

Hi Techies I have written a script which is collecting the logs of job running on server and let mail me the output. I want to format column of output, please help. CCMS_BAU_from_CACHE RUN ETL_SUBSITE_TO_SITE_BAU RUN GetClient_Prep_Main RUN MDM_Client_BAU RUN Sweeper RUN... (11 Replies)
Discussion started by: atul9806
11 Replies

3. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

Hi, I have a text file in the following format: Code: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 ... (2 Replies)
Discussion started by: evelibertine
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 Dummies Questions & Answers

Using awk to log transform a column in a tab-delimited text file?

How do I use awk to log transform the fifth column of a tab-delimited text file? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies

6. UNIX for Dummies Questions & Answers

Replacing a specific column of a text file with another column

I have a text file in the following format: 13412 NA06985 0 0 2 46.6432798439 4 4 4 4 13412 NA06991 NA06993 NA06985 2 48.8478948517 4 4 2 4 13412 NA06993 0 0 1 45.8022601455 4 4 2 4 13401 NA06994 0 0 1 48.780669145 4 4 4 4 13401 NA07000 0 0 2 47.7312017846 2 4 4 4 13402 NA07019... (3 Replies)
Discussion started by: evelibertine
3 Replies

7. UNIX for Dummies Questions & Answers

Pasting a column into a text file

I have two text files: One is a single column of numbers and the other is a space delimited text file with multiple columns. I want to paste the single column of numbers into the second column of the latter text file. How do I go about doing that? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies

8. Shell Programming and Scripting

Finding the last column value from a text file

Hi, I need to find out the last column value from a text file which is delimited by a tab. The issue here is the last column# for each record can be different i.,e, 1st record can have the last column as 15 and the second record can have the last column as "17". I have to search a string... (3 Replies)
Discussion started by: naveen_sangam
3 Replies

9. Shell Programming and Scripting

Need to get First column from the text file

Hey Guys, I have a very urgent requirement regaridng the searching for value on the text file. The text file is in the below format Number Description "112323", mysampletest1 "12122412", mysampletest2 "11232143", mysampletest3 I need to get the first column like 112323... (2 Replies)
Discussion started by: rahman_riyaz
2 Replies

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