08-29-2016
Sorry for causing confusion with input.. I used extra empty line for readability.
R. Singh your command works great.. Can you explain how this part of awk works?
($1 in A){$1=X} {A[Q]=A[Q]?A[Q] s1 $0:$0}
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a file with
aaa,bbb,ccc,dddd,eee,xyz
aaa,bbb,ccc,dddd,eee,xyz,12345,rty
aaa,bbb,ccc,dddd,eee,xyz,12345,rty,tsrt
1. line columns are not fixed
2. all words are seperated by comma
what i want is always the string after last comma.
regards,
Senthil... (9 Replies)
Discussion started by: senthilk615
9 Replies
2. Shell Programming and Scripting
I have a requirement in which i have to read a file which has multiple columns seperated by a pipe "|" from this i have to read each column values seperately and create a comma seperated row for the column and write to another file.
eg:
Input file:
ColA ColB
1 2
2 x
3 y... (5 Replies)
Discussion started by: nvuradi
5 Replies
3. Shell Programming and Scripting
Hi,
I have a table in Db2 with data say
id_1 phase1
id_1 phase2
id_1 phase3
id_2 phase1
id_2 phase2
I need to concatenate the values like
id_1 phase1,phase2,phase3
id_2 phase1,phase2
I tried recursive query but in vain as the length of string to be concatenated in quite long. ... (17 Replies)
Discussion started by: jsaravana
17 Replies
4. Shell Programming and Scripting
Hi,
I am new to shell scripting, i have requirement can any one help me out in this regrads,
in directory i have file like invoice1.txt, invoice2.txt in each file i have fixed number of columns, 62 in number but they are randomly arranged.like
for first file invoice1.txt can have columns... (5 Replies)
Discussion started by: madhav62
5 Replies
5. Shell Programming and Scripting
Hi,
I have a requirement with,
No~Dt~Notes
1~2011/08/1~"aaa
bbb
ccc
ddd
eee
fff
ggg
hhh"
Single column alone got splitted into multiple lines.
I require the output as
No~Dt~Notes
1~2011/08/1~"aaa<>bbb<>ccc<>ddd<>eee<>fff<>ggg<>hhh"
mean to say those new lines to be... (1 Reply)
Discussion started by: Bhuvaneswari
1 Replies
6. UNIX for Dummies Questions & Answers
Hi ,
Can You Please let Know How use unix uniq command on a single column for deleting records from file
with Below Structure.Pipe Delimter File .
Source
Name | Account_Id
A | 101
B... (2 Replies)
Discussion started by: anudeepkumar123
2 Replies
7. Shell Programming and Scripting
Hey guys, I have a column that consists of string and integer values without a distinctive deliminator, looking like this...
7ASA
14LAL
245FOO
656MOM
87577DAD
...
I want to split the column into two columns, one containing the numbers and one containing the text part.
edit: numbers... (3 Replies)
Discussion started by: origamisven
3 Replies
8. Shell Programming and Scripting
Hi,
I have pipe separated file which contains some data having comma(,) in it. I want to remove the comma(,) only from particular column without changing data in other columns.
Below is the sample data file, I want to remove the comma(,) only from 5th column.
$ cat file1
ABC | DEF, HIJ|... (6 Replies)
Discussion started by: Prathmesh
6 Replies
9. Shell Programming and Scripting
Hello everyone,
i need to replace in the second column of my csv file, points by nothing and dash by comma like this:
Input:
1 2 1;12.111.312-2;1.2;2;1-3
2 1 1;11.212.331-1;3.3;1;2-2
Output:
1 2 1;12111312;2;1.2;2;1-3
2 1 1;11212331;1;3.3;1;2-2
SED or PERL commands preferably.
... (7 Replies)
Discussion started by: satir
7 Replies
10. Shell Programming and Scripting
Hi All,
I am trying to output uniq values per column. see file below. can you please assist? Thank you in advance.
cat names
joe allen ibm
joe smith ibm
joe allen google
joe smith google
rachel allen google
desired output is:
joe allen google
rachel smith ibm (5 Replies)
Discussion started by: Apollo
5 Replies
diction(1) General Commands Manual diction(1)
NAME
diction, explain, suggest - Prints wordy sentences and looks them up in an interactive thesaurus.
SYNOPSIS
diction [-fpattern_file] [-k] [-ma] [-me] [-ml] [-ms] [-n] [file...]
explain
suggest
The diction command finds all sentences in an English language document that contain phrases from a database of bad or wordy diction. The
explain command is an interactive thesaurus for the English language phrases found by the diction command and only for those phrases.
The diction command reads from standard in if no file operand is provided.
The suggest command is a synonym for explain.
OPTIONS
Names a user-created pattern file to be used in addition to the default file. Passes the -k option to the deroff command. The -k option
keeps blocks of text specified nroff by requests or macros; for example, the request. Passes the -ma option to deroff. The -ma option
interprets nroff man macros only. Overrides the default nroff -ms macro package. Causes deroff to skip lists; should be used if a docu-
ment contains many lists of nonsentences. Overrides the default nroff -ms macro package. Suppresses use of the default file (used with
-f). Only the user-created pattern file is used.
DESCRIPTION
Each phrase found by the diction command is enclosed in [ ] (brackets). Because diction runs deroff before looking at the text, include
formatting header files as part of the input.
Before using the explain command, use the diction command to obtain a list of poorly worded phrases. When you use the explain command, the
system prompts you for a phrase and responds with a grammatically acceptable alternative. You can continue typing phrases, or you can exit
by pressing the End-of-File key sequence.
The explain command can also take input redirected from a file. No other command line arguments are valid.
NOTES
Use of nonstandard formatting macros may cause incorrect sentence breaks. In particular, diction does not understand -me.
FILES
Default pattern file. Thesaurus used by the explain command.
SEE ALSO
Commands: deroff(1), nroff(1)
diction(1)