Sponsored Content
Top Forums Shell Programming and Scripting Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2 Post 302467893 by rydz00 on Sunday 31st of October 2010 11:39:32 PM
Old 11-01-2010
I keep getting

Unmatched '.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Changing one column of delimited file column to fixed width column

Hi, Iam new to unix. I have one input file . Input file : ID1~Name1~Place1 ID2~Name2~Place2 ID3~Name3~Place3 I need output such that only first column should change to fixed width column of 15 characters of length. Output File: ID1<<12 spaces>>Name1~Place1 ID2<<12... (5 Replies)
Discussion started by: manneni prakash
5 Replies

2. Shell Programming and Scripting

Match one column of file1 with that of file2

Hi, I have file1 like this aaa ggg ddd vvv eeeand file2 aaa 2 aaa 443 xxx 76 aaa 34 ggg 33 wee 99 ggg 33 ddd 1 ddd 10 ddd 98 sds 23 (4 Replies)
Discussion started by: polsum
4 Replies

3. Shell Programming and Scripting

Replace column that matches specific pattern, with column data from another file

Can anyone please help with this? I have 2 files as given below. If 2nd column of file1 has pattern foo1@a, find the matching 1st column in file2 & replace 2nd column of file1 with file2's value. file1 abc_1 foo1@a .... abc_1 soo2@a ... def_2 soo2@a .... def_2 foo1@a ........ (7 Replies)
Discussion started by: prashali
7 Replies

4. UNIX for Dummies Questions & Answers

if matching strings in file1 and file2, add column from file1 to file2

I have very limited coding skills but I'm wondering if someone could help me with this. There are many threads about matching strings in two files, but I have no idea how to add a column from one file to another based on a matching string. I'm looking to match column1 in file1 to the number... (3 Replies)
Discussion started by: pathunkathunk
3 Replies

5. Shell Programming and Scripting

Based on column in file1, find match in file2 and print matching lines

file1: file2: I need to find matches for any lines in file1 that appear in file2. Desired output is '>' plus the file1 term, followed by the line after the match in file2 (so the title is a little misleading): This is honestly beyond what I can do without spending the whole night on it, so I'm... (2 Replies)
Discussion started by: pathunkathunk
2 Replies

6. Shell Programming and Scripting

Match part of string in file2 based on column in file1

I have a file containing texts and indexes. I need the text between (and including ) INDEX and number "1" alone in line. I have managed this: awk '/INDEX/,/1$/{if (!/1$/)print}' file1.txt It works for all indexes. And then I have second file with years and indexes per year, one per line... (3 Replies)
Discussion started by: phoebus
3 Replies

7. Shell Programming and Scripting

Need to select some column from file1 if condition match.

I have two files file1.txt and file2.txt. want to print some column(number,status,date1,date2,description(descrption column end before category column start with'Oracle Services') and assigned_to column from file1.txt ...If the assigned_to name in file2.txt matches with assinged_to name in... (2 Replies)
Discussion started by: vijay_rajni
2 Replies

8. Shell Programming and Scripting

awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column

Hi, My input files is like this axis1 0 1 10 axis2 0 1 5 axis1 1 2 -4 axis2 2 3 -3 axis1 3 4 5 axis2 3 4 -1 axis1 4 5 -6 axis2 4 5 1 Now, these are my following tasks 1. Print a first column for every two rows that has the same value followed by a string. 2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

9. Shell Programming and Scripting

Match column 8 in file 1 with column 2 in file 2 and replace..

I am looking at the NR==FNR posts and trying to use them to achieve the following but I am not getting it. I have 2 files. I want to match column 8 in file 1 with column 2 in file 2. When they match I want to replace column 9 in file 1 with column 1 in file 2. This is and extract from file 1 ... (5 Replies)
Discussion started by: kieranfoley
5 Replies

10. UNIX for Beginners Questions & Answers

Replace a column in tab delimited file with column in other tab delimited file,based on match

Hello Everyone.. I want to replace the retail col from FileI with cstp1 col from FileP if the strpno matches in both files FileP.txt ... (2 Replies)
Discussion started by: YogeshG
2 Replies
QMIDIROUTE(1)						      General Commands Manual						     QMIDIROUTE(1)

NAME
qmidiroute - MIDI event processor and router SYNOPSIS
qmidiroute [OPTION] [file] qmidiroute { --help | --version } DESCRIPTION
qmidiroute is a versatile MIDI event processor and router for the ALSA sequencer. The graphical interface is based on the Qt4 toolkit. qmidiroute permits setting up an unlimited number of MIDI maps in which incoming events are selected, modified or even changed in type before being directed to a dedicated ALSA output port. The maps work in parallel, and they are organized in tabs. With qmidiroute it is for example possible to change or invert the scale of a keyboard, to transform keyboard strokes into program changes or controller data into notes. Incoming MIDI events can be logged in a list and are displayed in different colors according to their MIDI type. qmidiroute provides one ALSA input port and as default two ALSA output ports. The numerical ALSA client id is displayed as part of the window title. General Usage After starting the application, the Unmatched tab is presented (see below). To start MIDI routing setup, the New map... button can be clicked, which will create a new MIDI map appearing as a tab in the map area. The entire setup can be saved to and loaded from a QMidiRoute file (.qmr). Several maps can be created to work in parallel. The maps can be organized using the Map Rename, Remove and Clone buttons. The Event Log is displayed in the bottom area by default, but can be hidden if not needed or floated as a top-level window on the desktop. Log- ging can also be disabled generally or for MIDI Clock events only. MIDI Input The Input field represents the incoming event filter of each map. Handled event types are Note, Controller, Pitchbend and Program Change. The events can be filtered by their respective values or by MIDI channel. Events matching the conditions specified in the Input field are directed to the Output field. MIDI Output The Output field sets terms into which event type the matching events are transformed, how their channel and values are transformed, and to which ALSA port they are directed. Channels and Values can be set Fixed, Offset or Reverse Offset with respect to the input event. As an example, Reverse Offset will take the value specified and subtract the incoming event value from it to produce the output event value. If the output range for a value is different from its input counterpart, the input range will be smoothly scaled to the output range. Events will be sent to the ALSA port specified. The number of available ALSA ports can be set using the corresponding command-line option. Unmatched MIDI events In the Unmatched tab, the handling of events not matching any input filter of the defined maps is specified. These events can be discarded or sent to a specified ALSA port. OPTIONS
--portCount <num> Set the number of available ALSA output ports to <num>. The default is 2. --help Print possible command-line options and exit. --version Print version information and exit. file Name of a valid QMidiRoute (.qmr) file to be loaded on start. FILES
*.qmr QMidiRoute files containing MIDI routing data in plain text format. EXAMPLES
An example MIDI map file can be found in /usr/share/qmidiroute or in /usr/local/share/qmidiroute NOTES
Errors and warnings are written to stderr(3). SUPPORT
alsamodular-devel@lists.sourceforge.net AUTHORS
Matthias Nagorni, Frank Kober and Guido Scholz. This manual page was written by Frank Kober <emuse@users.sourceforge.net>. 2009-09-13 QMIDIROUTE(1)
All times are GMT -4. The time now is 12:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy