Thanks, your answer worked on my example. However, the real files I deal with have reocurrence of specified identifiers from column 1, eg.
File 1:
Code:
1 today
1 green
2 tomorrow
3 red
1 today
2 tomorrow
File 2: as above
Desired output:
Code:
1 today a lot
1 today sometimes
1 green a lot
1 green sometimes
2 tomorrow at work
2 tomorrow at home
2 tomorrow sometimes
3 red new
1 today a lot
1 today sometimes
2 tomorrow at work
2 tomorrow at home
2 tomorrow sometimes
Any idea?
---------- Post updated at 05:17 PM ---------- Previous update was at 02:03 PM ----------
no one an idea?
Moderator's Comments:
edit by bakunin: first, you were asked to use CODE-tags for your code AND data. Please use them! Second: this is a forum, not a helpdesk! We are neither obliged to answer at all nor have we made any promises. Attempts at speeding the process up might slow it down (because people do not like being urged to help voluntarily) but it won't make it happen any quicker.
First, I am sorry. As you might have noticed I am new to this forum and need time to learn such things. Writing in BOLD and caps might be your attempt to speed this process up but it clearly won't. Second, ..well this one is obvious (The UNIX and Linux Forums), right? The description 'Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.' speaks for itself. Something else?
Dear Friends,
I really do not know Linux and I really would like to understand it because it does help to work with large data. I am reading this forum for 1 week to try a solution for my problem. I think that, using others post informations, I was almost there...
I have 2 big tables... (4 Replies)
Hello,
I often have this problem:
I have a file with a column of unique identifiers
e.g. file1 below has an id column and data column/columns with p rows:
cat data1
dog data2
cow data3
.
.
.
elephant datap-1
horse datap
and I have a conversion file,file2, with n<p rows... (4 Replies)
consider the following is the contents of the file
cat 11.sql
drop procedure if exists hoop1 ;
Delimiter $$
CREATE PROCEDURE hoop1(id int)
BEGIN
END
$$
Delimiter ;
.
.
.
.
drop procedure if exists hoop2;
Delimiter $$
CREATE PROCEDURE hoop2(id int)
BEGIN
END
$$ (8 Replies)
Hi all
I need your help to get a high-performance solution.
I am working on a extensive script to automate file restores using the bprestore tool on a Solaris 5.10 server (bash 3.00). I will only paste the needed parts of the script to avoid any confusion.
To use the script the user has to... (2 Replies)
Hi all,
I know how to merge two tables and to remove the duplicated lines based on a field (Column 2) . My next challenge is to be able to identify in a new column those common elements between table A & B, those elements in table A not present in table B and vice versa. A simple count would be... (6 Replies)
Hi,
I have a file which I'd like to merge lines based on duplicates in one column while keeping the info for other columns. Let me simplify it by an example:
File
ESR1 ANASTROZOLE NA FDA_approved
ESR1 CISPLATIN NA FDA_approved
ESR1 DANAZOL agonist NA
ESR1 EXEMESTANE NA FDA_approved... (3 Replies)
Hello,
I would like to ask for help with csh script.
An example of an input in .txt file is below, the number of lines varies from file to file and I have 2 or 3 columns with values. I would like to read all the values (probably one by one) and set them to independent unique variables that... (7 Replies)
I do have a text file with multiple lines on it. I want to put the lines of text into a single line where ever there is ";"
for example
ert, ryt, yvig,
fgr;
rtyu, hjk, uio,
hyu,
hjo;
ghj, tyu, gho,
hjp, jklo,
kol;
The resultant file I would like to have is
ert, ryt, yvig, fgr;... (2 Replies)
Hello all,
I have a large csv file where there are four types of rows I need to merge into one row per person, where there is a column for each possible code / type of row, even if that code/row isn't there for that person.
In the csv, a person may be listed from one to four times... (9 Replies)
I Want to merge multiple lines based on the 1st field and keep into single record.
SRC File:
AAA_POC_DB.TAB1
AAA_POC_DB.TAB2
AAA_POC_DB.TAB3
AAA_POC_DB.TAB4
BBB_POC_DB.TAB1
BBB_POC_DB.TAB2
CCC_POC_DB.TAB6
OUTPUT
-----------------
'AAA_POC_DB','TAB1','TAB2','TAB3','TAB4'... (10 Replies)
Discussion started by: raju2016
10 Replies
LEARN ABOUT DEBIAN
freebsd-yyfix
YYFIX(1) BSD General Commands Manual YYFIX(1)NAME
yyfix -- extract tables from y.tab.c
SYNOPSIS
yyfix file [tables]
DESCRIPTION
Programs have historically used a script (often named ``:yyfix'') to extract tables from the yacc(1) generated file y.tab.c. As the names of
the tables generated by the current version of yacc(1) are different from those of historical versions of yacc(1), the shell script yyfix is
provided to simplify the transition.
The first (and required) argument to yyfix is the name of the file where the extracted tables should be stored.
If further command line arguments are specified, they are taken as the list of tables to be extracted. Otherwise, yyfix attempts to deter-
mine if the y.tab.c file is from an old or new yacc(1), and extracts the appropriate tables.
The tables ``yyexca'', ``yyact'', ``yypact'', ``yypgo'', ``yyr1'', ``yyr2'', ``yychk'', and ``yydef'' are extracted from historical versions
of yacc(1).
The tables ``yylhs'', ``yylen'', ``yydefred'', ``yydgoto'', ``yysindex'', ``yyrindex'', ``yygindex'', ``yytable'', ``yyname'', ``yyrule'',
and ``yycheck'', are extracted from the current version of yacc(1).
FILES
y.tab.c File from which tables are extracted.
SEE ALSO yacc(1)HISTORY
The yyfix command first appeared in 4.4BSD.
BSD March 23, 1993 BSD