awk command to find total number of Special character in a column Post: 302925663

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Finding the total of a column using awk

Here is my file name countries USSR 8650 262 Asia Canada 3852 24 North America China 3692 866 Asia USA 3615 219 North America Brazil 3286 116 South America India 1269 637 Asia Argentina 1072 ...

2. Ubuntu

Inserting a header with column number to a 1.6 GB file with special spacing

Hi; I've been searching posts to find a solution to what I'm trying to do, but I've have NOT found anything yet. I have a file (file1) with 300K columns and 1411 rows, the columns don't have a column no. header (No header at all) and I'm trying to fetch the information from specific columns....

3. UNIX for Dummies Questions & Answers

AWK Command to find text in specific column

I'm new to scripting and would appreciate any help. I have a list of over 20 words in File1 that I need to find in columns 10-15 of File2. I need the entire row of File2 that the File1 list matches. I originally used a grep command which works, but provides File1 results that can be found...

4. Shell Programming and Scripting

remove special character from a specific column

Hello , i have a text file like this : A123 c12AB c32DD aaaa B123 23DS 12QW bbbb C123 2GR 3RG cccccc i want to remove the numbers from second and third column only. i tried this : perl -pe 's///g' file.txt > newfile.txt but it will remove the number from...

5. UNIX for Advanced & Expert Users

awk command in special character

Hi, I want to add below line after end of a file (i.e file1) &&echo "copy done" >> out.txt cat file1 scp user1@server1:/tmp/dir /tmp/dir1 my requirment is cat file1 scp user1@server1:/tmp/dir /tmp/dir1 &&echo "copy done" >> out.txt could any one please help me

6. Shell Programming and Scripting

[Solved] Find and replace till nth occurence of a special character

Hi, I have a requirement to search for a pattern in each line in a file and remove the in between words till the 3rd occurrence of double quote ("). Ex: CREATE TABLE "SCHEMANAME"."AMS_LTV_STATUS" (Note: "SCHEMANAME" may changes for different schemas. Its not a fixed value) I need to...

7. Shell Programming and Scripting

awk - special character not working

Hi, I am trying to use forward slash in awk. While running the command through console, its working fine but not working while running it through shell script. find . -name "*" -ctime -6 | xargs cat | grep -E -v ^fileName\|^ | awk -v DATE="${CURR_DATE}" -v DATE_LOG="$DATE_SYS" ' ...

8. UNIX for Dummies Questions & Answers

How to find count total number of pattern in a file �?

How to find count total number of pattern in a file … File contains : a.txt ------------- aaa bbb nnn ccc aaa bbb aaa ddd aaa aaa aaa aaa grep -c aaa a.txt Op: 4 ( But my requirement is should count the total no of patterns as 7 )

9. Shell Programming and Scripting

Text to column starting/ending with special character in each row

Hello, Here is my text data excerpted from the webpage: input My target is to get: What i tried is: sed 's/.*$connector$/1/' input > output but all characters coming before the word "connector" are deleted which is not good for me. My question:

10. Shell Programming and Scripting

awk or other way to find out number of occurrence of 7th character

Hi all, I am looking for to filter out based on 7th character and list the number of occurrence based on the 7th character if p , d , o or m 1. if 7th character is p , Output should be: p_hosts = N 2. if 7th character is d , Output should be: d_hosts = N 3. if 7th character is o , Output...

LEARN ABOUT POSIX

neaten

NEATEN(1)						      General Commands Manual							 NEATEN(1)

NAME

       neaten - neaten up output columns

SYNOPSIS

       neaten [ format ]

DESCRIPTION

       Neaten  reads  from  its standard input and neatens up columns separated by white space using the specified format.  The format is a string
       consisting of a positive integer followed by an alignment character and another integer.  The alignment	character  is  usually	a  decimal
       point ('.'), but it can be any non-digit.

       The  alignment  character  is used as the central point of each column.	The total column field width will be the number to the left of the
       alignment character plus one for the alignment character itself plus the number to the right of the alignment character.

       If a field does not contain the alignment character, it will be printed to the left of where the alignment character would  have  appeared.
       If  a  field  is  too long to print within the specified format, the entire field will be printed and that row will not be aligned with the
       rest.

       The default format is "8.8".

EXAMPLE

       To examine a file with columns of numbers:

	 neaten 10.8 < input | more

BUGS

       Columns wider than the total width of the format specification will be printed without any separating white space.

       The program does not do anything special with tabs on the input.

AUTHOR

       Greg Ward

SEE ALSO

       cnt(1), rcalc(1), rlam(1), total(1)

RADIANCE
							     11/15/93								 NEATEN(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Finding the total of a column using awk

Discussion started by: ironhead3fan

2. Ubuntu

Inserting a header with column number to a 1.6 GB file with special spacing

Discussion started by: sogi

3. UNIX for Dummies Questions & Answers

AWK Command to find text in specific column

Discussion started by: Chillin

4. Shell Programming and Scripting

remove special character from a specific column

Discussion started by: shelladdict