Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Cut specific column from 2 file and merge
Top Forums UNIX for Beginners Questions & Answers Cut specific column from 2 file and merge Post 302994485 by ctsgnb on Thursday 23rd of March 2017 11:53:09 AM
Old 03-23-2017
Man is your friend :
Code:
man join

Code:
man paste

Did you try something like :
Code:
ksh paste -d# <(cut -c1-44 FILE1 ) <(cut -c1-20 FILE2) <(cut -c45-60 FILE1)

Here i have set # as delimiter , choose one which does not already occur in your file so you can easy get rid off of it adding a | sed 's/#//g'
Last edited by ctsgnb; 03-23-2017 at 01:36 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

To cut entire column from a file and apend it to another file as another column

file1.txt : india pakistan bangladesh japan canada africa USA srilanka Nepal file2.txt Delhi Tokyo washington I have to cut the first column of file1.txt and apend it with file2.txt as another column like this Delhi india Tokyo japan washington USA ... (4 Replies)
Discussion started by: sakthifire
4 Replies

2. UNIX for Advanced & Expert Users

cut a specific value from a column

Dear Friends, I have an output like this: 7072;0;7072901 7072;1001;7072902 7072;101;7072903 7072;102;7072904 7072;1101;7072905 7072;1301;7072906 7072;1401;7072907 7072;162;7072908 7072;1;7072909 and I need to print the value in the column 3 , row number 1. which is 7072901 only.... (2 Replies)
Discussion started by: sfaqih
2 Replies

3. Shell Programming and Scripting

How to cut first line only from a text near a specific column without cutting a word

First I have to say thank you to this community and this forum. You helped me very much builing several useful scripts. Now, I can't get a solution the following problem, I'm stuck somehow. Maybe someone has an idea. In short, I dump a site via lynx and pipe the output in a file. I need to... (7 Replies)
Discussion started by: lowmaster
7 Replies

4. Shell Programming and Scripting

Assigning a specific format to a specific column in a text file using awk and printf

Hi, I have the following text file: 8 T1mapping_flip02 ok 128 108 30 1 665000-000008-000001.dcm 9 T1mapping_flip05 ok 128 108 30 1 665000-000009-000001.dcm 10 T1mapping_flip10 ok 128 108 30 1 665000-000010-000001.dcm 11 T1mapping_flip15 ok 128 108 30... (2 Replies)
Discussion started by: goodbenito
2 Replies

5. 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

6. Shell Programming and Scripting

Awk: Need help replacing a specific column in a file by part of a column in another file

Hi, I have two input files as File1 : ABC:client1:project1 XYZ:client2-aa:project2 DEF:client4:proj File2 : client1:W-170:xx client2-aa:WT-04:yy client4:L-005A:zz Also, array of valid values can be hardcoded like Output : ABC:W:project1 XYZ:WT:project2 (1 Reply)
Discussion started by: aa2601
1 Replies

7. UNIX for Dummies Questions & Answers

How to cut from a text file based on value of a specific column?

Hi, I have a tab delimited text file from which I want to cut out specific columns. If the second column equals one, I want to cut out columns 1 and 5 and 6. If the second column equals two, I want to cut out columns 1 and 5 and 7. How do I go about doing that? Thanks! (4 Replies)
Discussion started by: evelibertine
4 Replies

8. Shell Programming and Scripting

How to merge variable data from another file into specific place?

Hello, I'm trying to create multiple commands using a variable input from another file but am not getting any successful results. Basically, file1.txt contains multiple lines with single words: <file1.txt> yellow blue black white I want to create multiple echo commands with these... (8 Replies)
Discussion started by: demmel
8 Replies

9. Shell Programming and Scripting

Merge column file

Hi All, I have on file1 and file2 some, $cat file1 aaa bbb ccc ddd eee fff ggg hhh iii jjj with line blank, and (12 Replies)
Discussion started by: aav1307
12 Replies

10. Shell Programming and Scripting

Overwrite specific column in xml file with the specific column from adjacent line

I have an xml file dumped from rrd file, that I want to "patch" so the xml file doesn't contain any blank hole in the resulting graph of the rrd file. Here is the file. <!-- 2015-10-12 14:00:00 WIB / 1444633200 --> <row><v> 4.0419731265e+07 </v><v> 4.5045912770e+06... (2 Replies)
Discussion started by: rk4k
2 Replies

LEARN ABOUT DEBIAN

iceauth

ICEAUTH(1)						      General Commands Manual							ICEAUTH(1)

NAME

       iceauth - ICE authority file utility

SYNOPSIS

       iceauth [ -f authfile ] [ -vqib ] [ command arg ... ]

DESCRIPTION

       The iceauth program is used to edit and display the authorization information used in connecting with ICE.  This program is usually used to
       extract authorization records from one machine and merge them in on another (as is the case when using remote logins or granting access	to
       other users).  Commands (described below) may be entered interactively, on the iceauth command line, or in scripts.

OPTIONS

       -f authfile  Name of the authority file to use. Will default to
		    the file currently in use by the session.

       -v	    Turns on extra messages (verbose mode)

       -q	    Turns off extra messages (quiet mode)

       -i	    Ignore the locks on the authority file

       -b	    Break the locks on the authority file

       -u	    Print basic usage instructions

USAGE

       When iceauth is run it will allow the following set of commands to be entered interactively or in scripts.

       ?

       List available commands.

       help

       Print help information. You may supply a command name to help to get specific information about it.

       info

       Print information about the entries in the authority file.

       list

       List (print) entries in the authority file. You may specify optional modifiers as below to specify which entries are listed.

       list [ protocol_name ] [ protocol_data ] [ netid ] [ authname ]

       add

       Add an entry to the authority file. This must be in the format

       add protocol_name protocol_data netid authname authdata

       remove

       Remove entries from the authority file.

       remove [ protocol_name ] [ protocol_data ] [ netid ] [ authname ]

       extract

       Extract	entries  from  the  authority file in to a destination file. You must supply the path to the destination to this command as in the
       following format. Optional specifiers allow you to narrow which entries are extracted.

       extract filename [ protocol_name ] [ protocol_data ] [ netid ] [ authname ]

       merge

       Merge entries from other files in to the authority file selected by the program. You may supply any number of file paths to this command as
       follows:

       merge filename1 [ filename2 ] [ filename3 ] ...

       exit

       Save changes and exit the program.

       quit

       Abort changes and exit the program without saving.

       source

       Read and execute commands from a file.

       source filename

AUTHOR

       Ralph Mor, X Consortium

X Version 11							   iceauth 1.0.5							ICEAUTH(1)
All times are GMT -4. The time now is 08:25 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy