Sponsored Content
Homework and Emergencies Emergency UNIX and Linux Support Read values in each col starting 3rd row.Print occurrence value. Post 302970691 by Don Cragun on Sunday 10th of April 2016 07:42:10 PM
Old 04-10-2016
In the secondary output:
Code:
0=12times
1=3times
2=4times
3=4times
4=2times

where do these numbers come from?

If you're counting the number of times a digit appears in the input, 0 occurs 13 times (not 12 times) in your sample input. If you're counting the number of times a value appears in your sample input, 0 (or 00) does not appear at all???

All of your input values are two digit strings. Are we supposed to treat 01 and 1 as the same value or as distinct values? If they are the same, is 010 to be treated as an octal value (decimal 8) or as a decimal value (10)?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Print starting 3rd line until end of the file.

Hi, I want to Print starting 3rd line until end of the file. Pls let me know the command. Thanks in advance. (1 Reply)
Discussion started by: smc3
1 Replies

2. Shell Programming and Scripting

Awk to print distinct col values

Hi Guys... I am newbie to awk and would like a solution to probably one of the simple practical questions. I have a test file that goes as: 1,2,3,4,5,6 7,2,3,8,7,6 9,3,5,6,7,3 8,3,1,1,1,1 4,4,2,2,2,2 I would like to know how AWK can get me the distinct values say for eg: on col2... (22 Replies)
Discussion started by: anduzzi
22 Replies

3. Ubuntu

Match col 1 of File 1 with col 1 File 2 and create a 3rd file

Hello, I have a 1.6 GB file that I would like to modify by matching some ids in col1 with the ids in col 1 of file2.txt and save the results into a 3rd file. For example: File 1 has 1411 rows, I ignore how many columns it has (thousands) File 2 has 311 rows, 1 column Would like to... (7 Replies)
Discussion started by: sogi
7 Replies

4. UNIX for Advanced & Expert Users

Print line based on highest value of col (B) and repetion of values in col (A)

Hello everyone, I am writing a script to process data from the ATP world tour. I have a file which contains: t=540 y=2011 r=1 p=N409 t=540 y=2011 r=2 p=N409 t=540 y=2011 r=3 p=N409 t=540 y=2011 r=4 p=N409 t=520 y=2011 r=1 p=N409 t=520 y=2011 r=2 p=N409 t=520 y=2011 r=3 p=N409 The... (4 Replies)
Discussion started by: imahmoud
4 Replies

5. UNIX for Dummies Questions & Answers

how to join files with diff col # and row #?

I am a new user of Unix/Linux, so this question might be a bit simple! I am trying to join two (very large) files that both have different # of cols and rows in each file. I want to keep 'all' rows and 'all' cols from both files in the joint file, and the primary key variables are in the rows.... (1 Reply)
Discussion started by: BNasir
1 Replies

6. Shell Programming and Scripting

Change col to row using shell script..Very Complex

Hi guys I have file A with Below Data ABC123 X1 X2 X3 ABC123 Y1 Y33 Y4 ABC123 Z1 ZS2 ZL3 ABC234 P1 PP3 PP9 ABC234 Q1 ABC234 R1 P09 PO332 PO331 OKI12 .. .. .. Now I want file B as below ABC123 X1 X2 X3;Y1 Y33 Y4;Z1 ZS2 ZL3 ABC234 P1 PP3 PP9;Q1;R1 P09 PO332 PO331 OKI12... (1 Reply)
Discussion started by: asavaliya
1 Replies

7. Shell Programming and Scripting

Modifying col values based on another col

Hi, Please help with this. I have several excel files (with and .xlsx format) with 10-15 columns each. They all have the same type of data but the columns are not ordered in the same way. Here is a 3 column example. What I want to do add the alphabet from column 2 to column 3, provided... (9 Replies)
Discussion started by: newbie83
9 Replies

8. Shell Programming and Scripting

Read row number from 1 file and print that row of second file

Hi. How can I read row number from one file and print that corresponding record present at that row in another file. eg file1 1 3 5 7 9 file2 11111 22222 33333 44444 55555 66666 77777 88888 99999 (3 Replies)
Discussion started by: Abhiraj Singh
3 Replies

9. Shell Programming and Scripting

UNIX help to print 50 lines after every 3rd occurrence pattern till end of file

I need help with extract/print lines till stop pattern. This needs to happen after every 3rd occurrence of start pattern and continue till end of file. Consider below is an example of the log file. my start pattern will be every 3rd occurrence of ERROR_FILE_NOT_FOUND and stop pattern will be... (5 Replies)
Discussion started by: NSS
5 Replies

10. Shell Programming and Scripting

How to mark the row based on col value.?

Hi Gurus, I have requirement to identify the records based on one column value. the sample file as below: ID AMT, AMT1 100,10, 2 100,20, 3 200,30, 0 200, 40, 0 300, 20, 2 300, 50, 2 400, 20, 1 400, 60, 0 for each ID, there 2 records, if any one record amt1 is 0, the in 4th col add... (5 Replies)
Discussion started by: ken6503
5 Replies
tr(1)							      General Commands Manual							     tr(1)

NAME
tr - translate characters SYNOPSIS
string1 string2 string1 string1 string1 string1 DESCRIPTION
copies the standard input to the standard output with substitution or deletion of selected characters. Input characters from string1 are replaced with the corresponding characters in string2. If necessary, string1 and string2 can be quoted to avoid pattern matching by the shell. recognizes the following command line options: Translates on a byte-by-byte basis. When this flag is specified does not support extended characters. Complements the set of characters in string1, which is the set of all characters in the current character set, as defined by the current setting of except for those actually specified in the string1 argument. These characters are placed in the array in ascending collation sequence, as defined by the current setting of Deletes all occurrences of input characters or collating elements found in the array specified in string1. If and are both specified, all characters except those specified by string1 are deleted. The contents of string2 are ignored, unless is also specified. Note, however, that the same string cannot be used for both the and the flags; when both flags are specified, both string1 (used for deletion) and string2 (used for squeezing) are required. If is not specified, each input character or collating element found in the array specified by string1 is replaced by the character or collating element in the same relative position specified by string2. Replaces any character specified in string1 that occurs as a string of two or more repeating characters as a single instance of the character in string2. If the string2 contains a character class, the argument's array contains all of the characters in that character class. For example: In a case conversion, however, the string2 array contains only those characters defined as the second characters in each of the or character pairs, as appropriate. For example: The following abbreviation conventions can be used to introduce ranges of characters, repeated characters or single-character collating elements into the strings: c1-c2 or Stands for the range of collating elements c1 through c2, inclusive, as defined by the current setting of the locale category. Stands for all the characters belonging to the defined character class, as defined by the current setting of locale category. The following character class names will be accepted when spec- ified in string1: or Character classes are expanded in collation order. When the and flags are specified together, any of the character class names are accepted in string2; otherwise, only character class names or are accepted in string2 and then only if the corresponding character class and respectively) is specified in the same relative position in string1. Such a specification is interpreted as a request for case conversion. When appears in string1 and appears in string2, the arrays contain the characters from the mapping in the category of the current locale. When appears in string1 and appears in string2, the arrays contain the characters from the map- ping in the category of the current locale. Stands for all the characters or collating elements belonging to the same equivalence class as c, as defined by the current setting of locale category. An equivalence class expression is allowed only in string1, or in string2 when it is being used by the combined and options. Stands for n repetitions of a. If the first digit of n is n is considered octal; otherwise, n is treated as a decimal value. A zero or missing n is interpreted as large enough to extend string2-based sequence to the length of the string1-based sequence. The escape character can be used as in the shell to remove special meaning from any character in a string. In addition, followed by 1, 2, or 3 octal digits represents the character whose ASCII code is given by those digits. An ASCII NULL character in string1 or string2 can be represented only as an escaped character; i.e. as but is treated like other characters and translated correctly if so specified. NULL characters in the input are not stripped out unless the option is given. EXTERNAL INFLUENCES
Environment Variables provides a default value for the internationalization variables that are unset or null. If is unset or null, the default value of "C" (see lang(5)) is used. If any of the internationalization variables contains an invalid setting, will behave as if all internationalization variables are set to "C". See environ(5). If set to a non-empty string value, overrides the values of all the other internationalization variables. determines the interpretation of text as single and/or multi-byte characters, the classification of characters as printable, and the char- acters matched by character class expressions in regular expressions. determines the locale that should be used to affect the format and contents of diagnostic messages written to standard error and informa- tive messages written to standard output. determines the location of message catalogues for the processing of RETURN VALUE
exits with one of the following values: All input was processed successfully. An error occurred. EXAMPLES
For the ASCII character set and default collation sequence, create a list of all the words in file1, one per line in file2, where a word is taken to be a maximal string of alphabetics. Quote the strings to protect the special characters from interpretation by the shell (012 is the ASCII code for a new-line (line feed) character): Same as above, but for all character sets and collation sequences: Translate all lower case characters in file1 to upper case and write the result to standard output. Use an equivalence class to identify accented variants of the base character in file1, strip them of diacritical marks and write the result to file2: Translate each digit in file1 to a (number sign), and write the result to file2. The (asterisk) tells to repeat the (number sign) enough times to make the second string as long as the first one. AUTHOR
was developed by OSF and HP. SEE ALSO
ed(1), sh(1), ascii(5), environ(5), lang(5), regexp(5). STANDARDS CONFORMANCE
tr(1)
All times are GMT -4. The time now is 01:28 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy