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

txt2po

txt2po(1)						      Translate Toolkit 1.9.0							 txt2po(1)

NAME

       txt2po - convert plain text (.txt) files to Gettext PO localization files

SYNOPSIS

       txt2po  [--version]  [-h|--help]  [--manpage]  [--progress  PROGRESS]  [--errorlevel  ERRORLEVEL] [-i|--input] INPUT [-x|--exclude EXCLUDE]
       [-o|--output] OUTPUT [-P|--pot] [--encoding] [--flavour FLAVOUR] [--duplicates DUPLICATESTYLE]

DESCRIPTION

       See: http://translate.sourceforge.net/wiki/toolkit/txt2po for examples and usage instructions

OPTIONS

       --version
	      show program's version number and exit

       -h/--help
	      show this help message and exit

       --manpage
	      output a manpage based on the help

       --progress
	      show progress as: dots, none, bar, names, verbose

       --errorlevel
	      show errorlevel as: none, message, exception, traceback

       -i/--input
	      read from INPUT in *, txt formats

       -x/--exclude
	      exclude names matching EXCLUDE from input paths

       -o/--output
	      write to OUTPUT in po, pot formats

       -P/--pot
	      output PO Templates (.pot) rather than PO files (.po)

       --encoding
	      The encoding of the input file (default: UTF-8)

       --flavour
	      The flavour of text file: plain (default), dokuwiki, mediawiki

       --duplicates
	      what to do with duplicate strings (identical source text): merge, msgctxt (default: 'msgctxt')

							      Translate Toolkit 1.9.0							 txt2po(1)
All times are GMT -4. The time now is 06:42 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy