Both solutions seems to work, however there are caveats for each one given I wasn't very specific on the requirements.
new data set:
radoulov solutions works, though it assumes integers. I like the simplicity so I've tried modifying this code to work for non-integer indices, and it seems to lose the row order significantly(row to column transposed order is OK though):
This implies a problem with the string as array indices, but ivhb's solution uses the same feature.
This works OK as modified.
Final script FTW:
The only problem remains is that the space is assumed as the FS in the regexp, is there a way to escape the FS in a regexp?
Is it possible to do a join on multiple fields of two files? I am trying to do something like join -t, -1 2,3 -2 2,3 -o 2.1,2.2,2.3,1.3 filea fileb
I want the join to be on columns 2 and 3 of filea and columns 2 and 3 of fileb.
What is hapenning is that the second file that I want to do the join... (1 Reply)
Hi,
I have data with broken lines:
Sample data:
"12"|"25"|"a"|"b"|"c"|"d"|"e"|"f"|"2453748"|"08:10:50"
"16"|"25"|"a"|"b"|"c"|"d"|"e"|"f"|"
2453748"|"08:15:50"
"16"|"25"|"a"|"b"|"
c"|"d"|"e"|"f"|"2453748"|"08:19:50"
"16"|"25"|"a"|"b"|"c"|"d"|"e"|"f"|"2453748"|"08:19:50"
In the... (5 Replies)
Hi guys,
anyone know how can i join multiples lines using sed till the end of a file and output to another file in a single line?
The end of each line will be replaced with a special char "#".
I am using the below SED command, however it seems to remove the last 2 lines. Also not all lines... (12 Replies)
Hi, I need help with the join command
I have 2 files that I want to join on multiple fields.
I want to return all records from file 1
I also want empty fields in my joined file if there isn't a match in file 2
I have already sorted them so I know they are in the same order.
file1 ... (0 Replies)
Hi
I have a source file ( written i C ) where a funtion call is spread over multiple lines, for example :
func(
a,
b,
c
);
I want this to be joined into one single line :
func(a,b,c);
How can this be done with awk and sed ?
Regards. Hench (2 Replies)
Hi
I have a file like
1 2
1 2 3
1 5 6
11 12
10 2
7 5
17 12
I would like to have an output as
1 2 3 5 6 10 7
11 12 17
any help would be highly appreciated
Thanks (4 Replies)
I have an input file like this...
All iI want to do is If the lines are identical except for the last field i want to merge them into single line
input_file
I feel something is nothing
I feel something is everything
apple mango banana
apple mango grapes
I want to get output like this:... (3 Replies)
Hello all,
I want to join 2 tabbed files on the first 2 fields, and filling the missing values with 0. The 3rd column in each file is constant for the entire file.
file1
12658699 ST5 XX2720 0 1 0 1
53039541 ST5 XX2720 1 0 1.5 1
file2 ... (6 Replies)
Hi Guys,
Could you please advise how to join multiple details lines into single row, with HEADER 1 as the record separator and comma(,) as the field separator.
Input:
HEADER 1, HEADER 2, HEADER 3,
11,22,33,
COLUMN1,COLUMN2,COLUMN3,
AA1, BB1, CC1,
END: ABC
HEADER 1, HEADER 2,... (3 Replies)
Discussion started by: budz26
3 Replies
LEARN ABOUT LINUX
binfmt.d
BINFMT.D(5) binfmt.d BINFMT.D(5)NAME
binfmt.d - Configure additional binary formats for executables at boot
SYNOPSIS
/etc/binfmt.d/*.conf
/run/binfmt.d/*.conf
/usr/lib/binfmt.d/*.conf
DESCRIPTION
At boot, systemd-binfmt.service(8) reads configuration files from the above directories to register in the kernel additional binary formats
for executables.
CONFIGURATION FORMAT
Each file contains a list of binfmt_misc kernel binary format rules. Consult binfmt-misc.rst[1] for more information on registration of
additional binary formats and how to write rules.
Empty lines and lines beginning with ; and # are ignored. Note that this means you may not use ; and # as delimiter in binary format rules.
CONFIGURATION DIRECTORIES AND PRECEDENCE
Configuration files are read from directories in /etc/, /run/, and /lib/, in order of precedence. Each configuration file in these
configuration directories shall be named in the style of filename.conf. Files in /etc/ override files with the same name in /run/ and
/lib/. Files in /run/ override files with the same name in /lib/.
Packages should install their configuration files in /lib/. Files in /etc/ are reserved for the local administrator, who may use this logic
to override the configuration files installed by vendor packages. All configuration files are sorted by their filename in lexicographic
order, regardless of which of the directories they reside in. If multiple files specify the same option, the entry in the file with the
lexicographically latest name will take precedence. It is recommended to prefix all filenames with a two-digit number and a dash, to
simplify the ordering of the files.
If the administrator wants to disable a configuration file supplied by the vendor, the recommended way is to place a symlink to /dev/null
in the configuration directory in /etc/, with the same filename as the vendor configuration file. If the vendor configuration file is
included in the initrd image, the image has to be regenerated.
EXAMPLE
Example 1. /etc/binfmt.d/wine.conf example:
# Start WINE on Windows executables
:DOSWin:M::MZ::/usr/bin/wine:
SEE ALSO systemd(1), systemd-binfmt.service(8), systemd-delta(1), wine(8)NOTES
1. binfmt-misc.rst
https://www.kernel.org/doc/Documentation/admin-guide/binfmt-misc.rst
systemd 237BINFMT.D(5)