Sponsored Content
Top Forums Shell Programming and Scripting Match words and fetch data in front of it in second column Post 302698313 by manigrover on Sunday 9th of September 2012 10:32:41 PM
Old 09-09-2012
Request to check

Hi


I have checked actually in the second file I don't tthink there is problem related to spacing.

In actual file there are just 2 column of excel sheet in second file

And, In output also I do not want lots of spacing I just want output should be like second file. And, there should n't be any extra spacing.

Kindly check it and let me know any solution if possible
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extract data based on match against one column data from a long list data

My input file: data_5 Ali 422 2.00E-45 102/253 140/253 24 data_3 Abu 202 60.00E-45 12/23 140/23 28 data_1 Ahmad 256 7.00E-45 120/235 140/235 22 data_4 Aman 365 8.00E-45 15/65 140/65 20 data_10 Jones 869 9.00E-45 65/253 140/253 18... (12 Replies)
Discussion started by: patrick87
12 Replies

2. Shell Programming and Scripting

printing words based on column match

pls help Input: file1 word1 text1 word2 text2 word3 text3 file2 word1 text11 word3 text13 can u pls help in getting the same output: file1 text1 text2 text3 (1 Reply)
Discussion started by: bha148
1 Replies

3. Ubuntu

How to compare two columns and fetch the common data with additional column

Dear All, I am new to this forum and please ignore my little knowledge :p I have two types of data (a subset is given below) data version 1: 439798 2 1 451209 1 2 508696 2 1 555760 2 1 582757 1 2 582889 1 2 691827... (2 Replies)
Discussion started by: evoll
2 Replies

4. Shell Programming and Scripting

match sentence and word adn fetch similar words in alist

Hi all, I have ot match sentence list and word list anf fetch similar words in a separate file second file with 2 columns So I want the output shuld be 2 columns like this (3 Replies)
Discussion started by: manigrover
3 Replies

5. Shell Programming and Scripting

Match the word or words and fetch the entries

Hi all, I have 7 words Now I have 1 file which contain data in large number of rows and columns and 6th column contain any of these words or may be more than one words among above 7 words: I want script should search for the above mentioned 7 words in the 6th column ... (9 Replies)
Discussion started by: manigrover
9 Replies

6. Shell Programming and Scripting

Match same file column data

File A B07 U51C 4434 L662C 4412 B07 L64U 612 L651B 4434 B07 L11C 4434 R151B 4434 B05 L12Z 612 L51B 4434 B01 651Z 612 L651C 4434 B04 A51Z 612 L51A 4434 L07 B08D 4434 B1B 4434 B07 RU8D 4434 L51A 4434 B07 L58D 4434 B51C 4434 B07 LA8D 4434 L4B 4434 Now i want File B Output B07... (2 Replies)
Discussion started by: asavaliya
2 Replies

7. Shell Programming and Scripting

Compare 2 files and match column data and align data from 3 column

Hello experts, Please help me in achieving this in an easier way possible. I have 2 csv files with following data: File1 08/23/2012 12:35:47,JOB_5330 08/23/2012 12:35:47,JOB_5330 08/23/2012 12:36:09,JOB_5340 08/23/2012 12:36:14,JOB_5340 08/23/2012 12:36:22,JOB_5350 08/23/2012... (5 Replies)
Discussion started by: asnandhakumar
5 Replies

8. Shell Programming and Scripting

Find common and fetch what ever in front of it

Hi guys As my previous one is not working now I have a different problem with me one file with entries F2 F3 YUH SUH second fiel several columns like excel sheet (8-9) but my file in text F2 fgf gfhjhjghjghj dhgfhgfh 234324 F3 ... (6 Replies)
Discussion started by: Priyanka Chopra
6 Replies

9. Shell Programming and Scripting

Match columns and fetch whatever in front of it

Hi Solved these kind of issues using these codes But these are not wrking for my attached files can anybody check........ awk 'NR==FNR{X++;next}{if(X){print}}' file1 file2 awk 'NR==FNR{X=$0;next}{n=split($1,P," ");sub($1,"",$0);for(i=1;i<=n;i++){if(X]){print P,$0}}}' file1 FS="\t" file2 ... (6 Replies)
Discussion started by: Priyanka Chopra
6 Replies

10. Shell Programming and Scripting

Match first column entries precisely and fetch whatever in front of it

Hi all I have 2 files: first file AABC TTYP JKBH CVBN NHJK KJHM Second file is AABC,XCYU,JUHD Alllele1 GACXT It is approved study TTYP,JKBH Allele2 PPRD It is clinical trial study JKBH Allele2 PPRD ... (5 Replies)
Discussion started by: Priyanka Chopra
5 Replies
PSIGN(1)						      General Commands Manual							  PSIGN(1)

NAME
psign - produce a RADIANCE picture from text. SYNOPSIS
psign [ options ] [ text ] DESCRIPTION
Psign produces a RADIANCE picture of the given text. The output dimensions are determined by the character height, aspect ratio, number of lines and line length. (Also the character size if text squeezing is used.) If no text is given, the standard input is read. -cb r g b Set the background color to r g b The default is white (1 1 1). -cf r g b Set the foreground color to r g b The default is black (0 0 0). -dr Text reads to the right (default). -du Text reads upwards. -dl Text reads to the left (upside down). -dd Text reads downwards. -h cheight Set the character height to cheight. The default is 32 pixels. -a aspect Set the character aspect ratio (height/width) to aspect. The default value is 1.67. -x xsize Set the horizontal image size to xsize. Use with -y option (below) in place of the -h specification to control output image size directly. If the character aspect ratio (-a option, above) is non-zero, then one of the specified x or y output dimensions may be reduced to maintain this ratio. If direction is right (-dr) or left (-dl), then it is not necessary to give the -y option, since it can be computed from the character height (-h). -y ysize Set the vertical image size to ysize. Use with the -x option (described above). If direction is up (-du) or down (-dd), then it is not necessary to give the -x option, since it can be computed from the character height (-h). -s spacing Set the intercharacter spacing to spacing. The magnitude of this value is multiplied by the character height over the aspect ratio (ie. the character width) to compute the desired distance between characters in the output. The sign of the value, posi- tive or negative, determines how this ideal spacing is used in the actual placement of characters. If spacing is positive, then the overall width of the line will not be affected, nor will indentation of textual elements. Thus, the text format will be mostly unaffected. However, spacing between characters will reflect their relative size for a more natural appearance. If spac- ing is negative, characters will be squeezed together to meet the spacing critereon, regardless of how it might affect the format of the output. The default value for spacing is zero, which is interpreted as uniformly spaced characters. -f fontfile Load the font from fontfile. The default font is helvet.fnt EXAMPLE
To put a big "Hi!" on the terminal: psign -h 22 -a 1 -cb 0 0 0 -cf 1 1 1 Hi! | ttyimage ENVIRONMENT
RAYPATH path to search for font files AUTHOR
Greg Ward BUGS
The entire bitmap is stored in memory, which can be a problem for large and/or high-resolution signs. SEE ALSO
getinfo(1), pcompos(1), pfilt(1), ttyimage(1) RADIANCE
10/9/97 PSIGN(1)
All times are GMT -4. The time now is 03:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy