Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Awk, sed, shell all words in INPUT.txt find in column1 of TABLE.txt and replce with column2 in
Top Forums Shell Programming and Scripting Awk, sed, shell all words in INPUT.txt find in column1 of TABLE.txt and replce with column2 in Post 303011982 by alii on Saturday 27th of January 2018 04:58:13 AM
Old 01-27-2018
search last column of INPUT in TABLEs text and add correspond columns to INPUT
thanks all
i use UBUNTU 16.04 LTS
it's ok.
may explain your code?


so another question
i have INPUT
like this
see last column
number of columns different in one
some row have 12 , some 11

Code:
INPUT
CodeGender Age Grade Dialect Session Sentence Start End Length Phonemic Phonetic 
63 M 27 BS/BA TEHRANI 3 4 298320 310050 11730 j j 
63 M 27 BS/BA TEHRANI 3 4 310050 311430 1380 ( a 
63 M 27 BS/BA TEHRANI 3 4 311430 312080 650 ] ]

and two TABLE text like this.have two columns.
Code:
TABLE1
j feat1
a feat2
.
.
.

Code:
TABLE2
j sp1
a sp2
.
.

I want to add two columns to INPUT
search last column of INPUT in TABLEs text and add correspond columns to INPUT
(i think can merge TABLEs like j feat1 sp1)
and output like this
Code:
output
CodeGender Age Grade Dialect Session Sentence Start End Length Phonemic Phonetic feat sp
63 M 27 BS/BA TEHRANI 3 4 298320 310050 11730 j j feat1 sp1
63 M 27 BS/BA TEHRANI 3 4 310050 311430 1380 ( a feat2 sp2
63 M 27 BS/BA TEHRANI 3 4 311430 312080 650 ] ]

Last edited by alii; 01-27-2018 at 06:02 AM.. Reason: Misspelling
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed to read x.txt and grep from y.txt

How would I write a command(s) to read from a file (list) that looks like this: 29847374384 and grep from a second file (list) that looks like this: 29847374384, jkdfkjdf,3833,ddd:confused: (1 Reply)
Discussion started by: smellylizzard
1 Replies

2. UNIX for Dummies Questions & Answers

find lines in file1.txt not found in file2.txt memory problem

I have a diff command that does what I want but when comparing large text/log files, it uses up all the memory I have (sometimes over 8gig of memory) diff file1.txt file2.txt | grep '^<'| awk '{$1="";print $0}' | sed 's/^ *//' Is there a better more efficient way to find the lines in one file... (5 Replies)
Discussion started by: raptor25
5 Replies

3. Shell Programming and Scripting

Convert shell script output txt file to html table

Hi, I have script which generates the output as below: Jobname Date Time Status abc 12/9/11 17:00 Completed xyz 13/9/11 21:00 Running I have the output as a text file. I need to convert it into a HTML Table and sent it thru email ... (6 Replies)
Discussion started by: a12ka4
6 Replies

4. Shell Programming and Scripting

awk append fileA.txt to growing file B.txt

This is appending a column. My question is fairly simple. I have a program generating data in a form like so: 1 20 2 22 3 23 4 12 5 43 For ever iteration I'm generating this data. I have the basic idea with cut -f 2 fileA.txt | paste -d >> FileB.txt ???? I want FileB.txt to grow, and... (4 Replies)
Discussion started by: theawknewbie
4 Replies

5. UNIX for Dummies Questions & Answers

How to Update DB table from txt file using CRONJOB in Unix Shell Script

Hi Experts, can guide how we can Update a Database Table using a txt file source Using Unix Shell Scripts. What are the Cron Jobs codes can written to Update DB table. txt file contains record like data. US 09/03/2012 User DocType DocID. these above feilds in txt files need to be updated in... (4 Replies)
Discussion started by: mahesh.sap
4 Replies

6. Shell Programming and Scripting

Read input txt while find copy

I have a text file called file.txt which has a list of file as shown below that i need to find and copy to a particular location. FILENAMES skter.pdf abcdf.sas tereen.lst abc12.txt i am using following code and it never works however i try it. cat file.txt | while read FILENAME;do find... (4 Replies)
Discussion started by: MILAN KUMAR
4 Replies

7. Shell Programming and Scripting

Desired output.txt for reading txt file using awk?

Dear all, I have a huge txt file (DATA.txt) with the following content . From this txt file, I want the following output using some shell script. Any help is greatly appreciated. Greetings, emily DATA.txt (snippet of the huge text file) 407202849... (2 Replies)
Discussion started by: emily
2 Replies

8. Shell Programming and Scripting

Convert shell script output txt file to html table

My concnern related to the post -Convert shell script output txt file to html table, in this how to print the heading as color. awk 'BEGIN{print "<table>"} {print "<tr>";for(i=1;i<=NF;i++)print "<td>" $i"</td>";print "</tr>"} END{print "</table>"}' <filename> (8 Replies)
Discussion started by: sarajobmai
8 Replies

9. Shell Programming and Scripting

How to get the shell script to read the .txt file as an input/data?

i have written my shell script in notepad however i am struggling to pass the data file to be read to the script the data file is of .txt format. My target is to run the shell script from the terminal and pass 3 arguments e.g. polg@DESKTOP-BVPDC5C:~/CS1420/coursework$ bash valsplit.sh input.txt... (11 Replies)
Discussion started by: Gurdza32
11 Replies

10. Shell Programming and Scripting

Search last column of INPUT.txt in TABLEs text and add correspond columns to INPUT.txt

Hi dears i use bash shell i have INPUT.txt like this number of columns different in one some row have 12 , some 11 columns see last column INPUT.txt CodeGender Age Grade Dialect Session Sentence Start End Length Phonemic Phonetic 63 M 27 BS/BA TEHRANI 3 4 298320 310050... (2 Replies)
Discussion started by: alii
2 Replies

LEARN ABOUT DEBIAN

nec2small

NEC2(1) 						      General Commands Manual							   NEC2(1)

NAME

       nec2, nec2small - Numerical Electromagnetics Code (Antenna Modelling Program)

SYNOPSIS

       nec2 [INPUT] [OUTPUT]
       nec2small [INPUT] [OUTPUT]

DESCRIPTION

       nec2,  is  a  versatile	numerical  Boundary  Element Method (commonly called Method of Moments) antenna modelling code for the analysis of
       antennas and other metal structures.  It solves the integral equations for the currents induced on the structure  by  sources  or  incident
       fields.	The structure may either be excited by voltage sources on the structure, or by an incident plane wave of either elliptic or linear
       polarisation.  The structure and excitation are described in the INPUT file and the output is written to OUTPUT.

OPTIONS

       Due to the age of the program, it expects input in the form of punched cards fed into a hopper.	It currently does not accept any options.

       If OUTPUT is omitted, output is written to stdout and if INPUT and OUTPUT are omitted then the input is taken from  stdin  and  the  output
       written to stdout.

       The  maximum  size  of  problem which the code can handle must be hard coded at compile time and no dynamic memory allocation is performed.
       Two versions are therefore provided suitable for different sizes of problem, nec2 is compiled for a maximum of 10000 wire segments and 5000
       surface patches, while nec2small is compiled for a maximum of 600 wire segments and 200 surface patches.

SEE ALSO

       somnec(1)

       The  NEC-2 code is fully documented in the report Numerical Electromagnetics Code (NEC) -- Method of Moments" by Burke and Poggio, which is
       available as a printed publication in three parts covering the theory of operation, the program code and the  users'  manual.   An  updated
       form of the users' manual part of this report can be found in /usr/share/doc/nec/NECdoc

BUGS

       nec2  has been superseded by nec4, but this revised code has not been made available to the public, so it is possible that some bugs remain
       in this version.

       Also note that many variant source codes exist based on the original FORTRAN-IV listing in the report.  This one is  believed  to  be  cor-
       rectly working, but may still contain extra errors.

AUTHOR

       This manual page was written by	<alanb@chiark.greenend.org.uk>.  The program was developed by G. J. Burke and A. J. Poggio of the Laurence
       Livermore Laboratory.

																	   NEC2(1)
All times are GMT -4. The time now is 01:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy