Dynamically merging 2 files on header values

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to print multiple required columns dynamically in a file using the header name?

Hi All, i am trying to print required multiple columns dynamically from a fie. But i am able to print only one column at a time. i am new to shell script, please help me on this issue. i am using below script awk -v COLT=$1 ' NR==1 { for (i=1; i<=NF; i++) { ...

2. Shell Programming and Scripting

Merging two files to form header

Dear experts required you support to achieve below i need the file 2 values show on top of file 1 for mentioned valuesENTER CREDENTIALS or beside this please support to achieve the expected result . if I get the result 2 that will be better I have two files File 1 ENTER CREDENTIALS BILLING...

3. UNIX for Beginners Questions & Answers

Concatenate column values when header is Matching from multiple files

there can be n number of columns but the number of columns and header name will remain same in all 3 files. Files are tab Delimited. a.txt Name 9/1 9/2 X 1 7 y 2 8 z 3 9 a 4 10 b 5 11 c 6 12 b.xt Name 9/1 9/2 X 13 19 y 14 20 z 15 21 a 16 22 b 17 23 c 18 24 c.txt Name 9/1 9/2...

4. Shell Programming and Scripting

Generate a DML dynamically based off of header record

I have the following scenario where I need to use a header record from a file and generate a DML based off of it... E.g.: The header can change periodically with an additional column in between or remove a col.... Sample header : (head -1 sample.txt)...

5. UNIX for Dummies Questions & Answers

Merging two text files by a column and filling in the missing values

Hi, I have to text files that I want to merge by the first column. The values in the first column pretty much match for the first part. However there are some values that are present in column 1 and not present in column 2 or vice versa. For such values I would like to substitute X for the...

6. Shell Programming and Scripting

Modifying the values of dynamically named arrays

Hi all, In ksh, I'm trying to loop through all of my arrays, named array1, array2, array3..., and update the indices. But I'm getting errors and I'm not sure how to fix them. The errors are ./parse.sh: 6+1: not found The code is: eval \${array$c}=$(eval \${array$c}+1 ) Any help...

7. Programming

Retreving the dynamically allocated values from bdb using C

In one of the assignment which i am working on, i am am trying to insert keys and values into BDB by reading the input records from a input file as below. Here keys i am inserting as character buffer and for values i am dynamically allocating the memory using malloc and then inserting into bdb....

8. UNIX for Advanced & Expert Users

Retreving the dynamically allocated values from bdb using C

9. UNIX for Dummies Questions & Answers

Merge all csv files in one folder considering only 1 header row and ignoring header of all others

Friends, I need help with the following in UNIX. Merge all csv files in one folder considering only 1 header row and ignoring header of all other files. FYI - All files are in same format and contains same headers. Thank you

10. Shell Programming and Scripting

dynamically adding values in c-shell

I am needing to create a variable(changing) and assign it a value(changing) ... I am using C-Shell.. Example: foreach account in ($Accountlist) set account_connect = "$account/$account_pass" end I want to make set account_connect to store various values ? $account_connect did not...

LEARN ABOUT PLAN9

pr

PR(1)							      General Commands Manual							     PR(1)

NAME

       pr - print file

SYNOPSIS

       pr [ option ...	] [ file ...  ]

DESCRIPTION

       Pr  produces  a printed listing of one or more files on its standard output.  The output is separated into pages headed by a date, the name
       of the file or a specified header, and the page number.	With no file arguments, pr prints its standard input.

       Options apply to all following files but may be reset between files:

       -n     Produce n-column output.

       +n     Begin printing with page n.

       -b     Balance columns on last page, in case of multi-column output.

       -d     Double space.

       -en    Set the tab stops for input text every n spaces.

       -h     Take the next argument as a page header (file by default).

       -in    Replace sequences of blanks in the output by tabs, using tab stops set every n spaces.

       -f     Use formfeeds to separate pages.

       -ln    Take the length of the page to be n lines instead of the default 66.

       -m     Print all files simultaneously, each in one column.

       -n     Number the lines of each file.

       -on    Offset the left margin n character positions.

       -sc    Separate columns by the single character c instead of aligning them with white space.  A missing c is taken to be a tab.

       -t     Do not print the 5-line header or the 5-line trailer normally supplied for each page.

       -wn    For multi-column output, take the width of the page to be n characters instead of the default 72.

SOURCE

       /sys/src/cmd/pr.c

SEE ALSO

       cat(1), lp(1)

																	     PR(1)

UNIX for Dummies Questions & Answers