[Solved] Column manipulation

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Column manipulation

Hi, I's like to ask for help with the following question: this is an example file: 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9 10 I need to have it re-arranged in the following manner: first 2 columns, zero, zero, last two columns, columns 3 to...

2. UNIX for Advanced & Expert Users

Column manipulation of a file

In a space delimited file how would you go about removing 2 and 3 column of a file and add "word" to the first column of the file in both awk and vi?

3. Shell Programming and Scripting

[Solved] Data manipulation

Hallo Team, I need your help. I have a file that has two colums. See sample below: 105550 0.28 105550 0.24 125550 0.28 125550 0.24 215650 0.28 215650 0.24 315550 0.28 315550 0.24 335550 0.28 335550 0.24 40555 0.21 40555 0.17 415550 0.21 415550 0.17 43555 0.21 43555 0.17

4. Shell Programming and Scripting

Column manipulation

Hallo Team, I have a .csv file. I would like to have another column called Prefix. Under column Prefix i would like to have the first 3 numbers from the theird column. Other Licenced Operator Alpha Code Numbering Per minute Interconnect Fee per rate group (R Excluding VAT) ...

5. Shell Programming and Scripting

[Solved] awk manipulation of sequentially named files

Hello, I am a very novice user of awk, I have a set of files named file001, file002, file003, file004, etc., each contains four fields (columns of data) separated each by a uneven number of spaces. I want to substitute those spaces by a TAB, so I am using this line of awk script: awk -v OFS="\t"...

6. Shell Programming and Scripting

Column manipulation and counter

Hello, I was wondering how I could change this input: cat f1 to produce this output: As you can tell, I have several unsorted repeating strings in col1 of the input file. Each of these strings has an associated word in col2. Col2 has a total of 4 possible words (go, stop,...

7. UNIX for Dummies Questions & Answers

[Solved] Text manipulation help

Hello Unix.com How can I sort from a large email list only the emails that finish with .ca domain? cat <list> | grep "\.ca\b" >> <new list> isnt working perfectly. Any tips? Best regards, Galford D. Weller

8. Shell Programming and Scripting

[Solved] Sorting a column based on another column

hello, I have a file as follows: F0100010 A C F0100040 A G BTA-28763-no-rs 77.2692 F0100020 A G F0100030 A T BTA-29334-no-rs 11.4989 F0100030 A T F0100020 A G BTA-29515-no-rs 127.006 F0100040 A G F0100010 A C BTA-29644-no-rs 7.29827 F0100050 A...

9. UNIX for Dummies Questions & Answers

[Solved] Deleting all rows where the first column equals the second column

Hi, I have a tab delimited text file where the first two columns equal numbers. I want to delete all rows where the value in the first column equals the second column. How do I go about doing that? Thanks! Input: 1 1 ABC DEF 2 2 IJK LMN 1 2 ZYX OPW Output: 1 2 ZYX OPW

10. Shell Programming and Scripting

Column manipulation

Hi, I have an input file in which I need to add a column with the value of part of another column. I.e. I have the following line (example, not the actual data): field1,field2,field3,test12,field5,field6I need to get the last two characters of the 4th field, and add them at the end as a...

LEARN ABOUT CENTOS

aha

aha(1)								 Ansi HTML Adapter							    aha(1)

NAME

	aha - Ansi HTML Adapter

SYNOPSIS

       aha [options] [-f datei]

DESCRIPTION

       aha takes SGR-colored Input and prints W3C conform HTML-Code.
       aha reads the Input from a file or stdin and writes HTML-Code to stdout.

OPTIONS

       --help , -h , -?
	      A help like this

       --black , -b
	      Black Background and white "standard color"

       --pink , -p
	      Pink Background

       --iso X , -i X
	      Uses ISO 8859-X instead of utf-8. X must be 1..16

       --title X , -t X
	      Gives the html output the title

       --line-fix , -l
	      Uses a fix for inputs using control sequences to change the cursor position like htop. It's a hot fix, it may not work with any pro-
	      gram like htop. (See EXAMPLE)

EXAMPLE

       aha --help | aha --black --title "the awesome aha help"> aha-help.htm
	      Creates an HTML file with the help of aha with black background

       colordiff oldfile.c newfile.c | aha > colordiff.htm
	      Creates an HTML file with a colorful diff-output of two files "oldfile.c" and "newfile.c" with white background

       ls --color=always | aha --pink > ls.htm
	      Creates an HTML file with a colorful ls-output with pink background.

       echo a | htop | aha --black --line-fix > htop.htm
	      Creates an HTML file with the output of htop. You have to use --line-fix due the other new-line-commands htop uses.

AUTHOR

       Copyleft Alexander Matthes aka Ziz 2011
       zizsdl@googlemail.com

SEE ALSO

       http://ziz.delphigl.com/tool_aha.php

								  August 31, 2011							    aha(1)

UNIX for Dummies Questions & Answers