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

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Trim String in 3rd Column in Tab Delimited File...SED/PERL/AWK?

Hey Everybody, I am having much trouble figuring this out, as I am not really a programmer..:mad: Datafile.txt Column0 Column1 Column2 ABC DEF xxxGHI I am running using WGET on a cronjob to grab a datafile, but I need to cut the first three characters from...

2. Shell Programming and Scripting

Delete first column in tab-delimited text-file

I have a large text-file with tab-delimited genetic data that looks like: KSC112 KSC234 0 0 1 1 A G C T I simply wan to delete the first column, but since the file has 600 000 columns, it is not possible with awk (seems to be limited at 32k columns). Does anyone have an idea how to do this?

3. Shell Programming and Scripting

using awk to substitute data in a column delimited text file

using awk to substitute data in a column delimited text file hello i would like to use awk to do the following calculation from the following snippet. input file C;2390 ;CV BOUILLOTTE 2L 2FACES NERVUREES ;1.00 ;3552612239004;13417 ;25 ;50 ; 12;50000 ; ; ...

4. UNIX for Dummies Questions & Answers

Add a new column to a tab delimited text file

I want to add a new column to a tab delimited text file. It will be the first column and it will just be 1's. How do I go about doing that? Thanks!

5. Shell Programming and Scripting

Extract second column tab delimited file

I have a file which looks like this: 73450 articles and news developmental psychology 2006-03-30 16:22:40 1 http://www.usnews.com 73450 articles and news developmental psychology 2006-03-30 16:22:40 2 http://www.apa.org 73450 articles and news developmental psychology 2006-03-30...

6. UNIX for Dummies Questions & Answers

add (append) a column in a tab delimited file

I have a file having the following entries: test1 test2 test3 11 22 33 22 44 66 99 99 44 --- I want to add a column so that the above file becomes: test1 test2 test3 notest 11 22 33 * 22 44 66 * 99 99 44 * --- Thanks

7. Shell Programming and Scripting

Delete an entire column from a tab delimited file

Hi, Can anyone please tell me about how we can delete an entire column from a tab delimited file? Mu input_file.txt looks like this: And I want the output as: I used the below code nawk -v d="1" 'BEGIN{FS=OFS="\t"}{$d=""}{print}' input_file.txtBut in the output, the first column is...

8. UNIX for Dummies Questions & Answers

awk - Extract 4 lines in Column to Rows Tab Delimited between tags

I have tried the following to no avail. xargs -n8 < test.txt awk '{if(NR%6!=0){p=""}else{p="\n"};printf $0" "p}' Mod_Alm_log.txt > test.txt I have tried different variations of the above, the problem is mixes lines together. And it includes the tags "%a and %A" I need them to be all tab...

9. UNIX for Dummies Questions & Answers

Need to convert a pipe delimited text file to tab delimited

Hi, I have a rquirement in unix as below . I have a text file with me seperated by | symbol and i need to generate a excel file through unix commands/script so that each value will go to each column. ex: Input Text file: 1|A|apple 2|B|bottle excel file to be generated as output as...

10. UNIX for Beginners Questions & Answers

Replace a column in tab delimited file with column in other tab delimited file,based on match

Hello Everyone.. I want to replace the retail col from FileI with cstp1 col from FileP if the strpno matches in both files FileP.txt ...

LEARN ABOUT DEBIAN

stag-flatten

STAG-FLATTEN(1p)					User Contributed Perl Documentation					  STAG-FLATTEN(1p)

NAME

       stag-flatten - turns stag data into a flat table

SYNOPSIS

	 stag-flatten -c name -c person/name dept MyFile.xml

DESCRIPTION

       reads in a file in a stag format, and 'flattens' it to a tab-delimited table format. given this data:

	 (company
	  (dept
	   (name "special-operations")
	   (person
	    (name "james-bond"))
	   (person
	    (name "fred"))))

       the above command will return a two column table

	 special-operations	 james-bond
	 special-operations	 fred

       If there are multiple values for the columns within the node, then the cartesian product will be calculated

USAGE

	 stag-flatten [-p PARSER] [-c COLS] [-c COLS] NODE <file>

ARGUMENTS

       -p|parser FORMAT
	   FORMAT is one of xml, sxpr or itext

	   xml assumed as default

       -c|column COL1,COL2,COL3,..
	   the name of the columns/elements to write out

	   this can be specified either with multiple -c arguments, or with a comma-seperated (no spaces) list of column (terminal node) names
	   after a single -c

       -n|nest
	   if set, then the output will be a compress repeating values into the same row; each cell in the table will be enclosed by {}, and will
	   contain a comma-delimited set of values

SEE ALSO

       Data::Stag

perl v5.10.0							    2008-12-23							  STAG-FLATTEN(1p)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Trim String in 3rd Column in Tab Delimited File...SED/PERL/AWK?

Discussion started by: rickdini

2. Shell Programming and Scripting

Delete first column in tab-delimited text-file

Discussion started by: andmal

3. Shell Programming and Scripting

using awk to substitute data in a column delimited text file

Discussion started by: iindie

4. UNIX for Dummies Questions & Answers

Add a new column to a tab delimited text file

Discussion started by: evelibertine