Replacing column with another column of different file by awk
Hi All,
I will really appreciate if you kindly lookinto my requirement below and provide me a solution
First file format test1.txt
Second file format text2.txt
Now o/p I want as text1.txt's 4th column replaced by 1st column of second file
Please help me to solve this
Moderator's Comments:
Having 34 posts you should be familiar using code tags - please do so next time!
Hi, I have two input files.
File1:
ID Name Place
1-234~name1~Newyork
1-34~name2~Boston
1-2345~name3~Hungary
File1 is a variable length file where each column is seperated by delimitter "~".
File2:
ID Country
1-34<<11 SPACES>>USA<<7 spaces>>
1-234<<10 SPACES>>UK<<8 spaces>>
... (1 Reply)
Hi, I have two input files.
File1:
ID Name Place
1-234~name1~Newyork
1-34~name2~Boston
1-2345~name3~Hungary
File1 is a variable length file where each column is seperated by delimitter "~".
File2:
ID Country
1-34<<11 SPACES>>USA<<7 spaces>>
1-234<<10 SPACES>>UK<<8 spaces>>
... (1 Reply)
Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2
file 1 sample
SNDK 80004C101 AT
XLNX 983919101 BB
NETL 64118B100 BS
AMD 007903107 CC
KLAC 482480100 DC
TER 880770102 KATS
ATHR 04743P108 KATS... (7 Replies)
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)
Hi,
I know that this topic has been discussed in the past and I've tried to follow all the guidelines. Anyhow, I following describe my problem.
I have a file (file1 , no. records = 67) containing pairs of IP addresses as follows (with single space as delimiter between the fields):
example... (5 Replies)
Hi have a large spreadsheet which has 4 columns
APM00111803814 server_2 96085 Corp IT Desktop and Apps
APM00111803814 server_2 96085 Corp IT Desktop and Apps
APM00111803814 server_2 96034 Storage Mgmt Team
APM00111803814 server_2 96152 GWP... (6 Replies)
input
"A","B","C,D","E","F"
"S","T","U,V","W","X"
"AA","BB","CC,DD","EEEE","FFF"
required output:
"A","B","C,D","C,D","F"
"S", T","U,V","U,V","X"
"AA","BB","CC,DD","CC,DD","FFF"
tried using awk but double quotes not preserving for every field. any help to solve this is much... (5 Replies)
Hi,
I have 2 csv files.
a.csv
HUAWEI,20LMG011_DEKET_1296_RTN-980_IDU-1-11-ISV3-1(to LAMONGAN_M),East_Java,20LMG011_DEKET_1296_RTN-980_IDU-1,20LMG011,20LMG
027_1287_LAMONGAN_RTN980_IDU1,20LMG027,1+1(HSB),195.675,20LMG011-20LMG027,99.9995,202.6952012... (7 Replies)
Discussion started by: tententen
7 Replies
LEARN ABOUT DEBIAN
audio::mpd::common::item::song
Audio::MPD::Common::Item::Song(3pm) User Contributed Perl Documentation Audio::MPD::Common::Item::Song(3pm)NAME
Audio::MPD::Common::Item::Song - a song object with some audio tags
VERSION
version 1.120881
DESCRIPTION
Audio::MPD::Common::Item::Song is more a placeholder with some attributes. Those attributes are taken from the song tags, so some of them
can be empty depending on the file.
The constructor should only be called by Audio::MPD::Common::Item's constructor.
ATTRIBUTES
album
Album of the song. (format code: %d)
artist
Artist of the song. (format code: %a)
albumartist
Artist of the album. (format code: %A)
composer
Song composer. (format code: %C)
date
Last modification date of the song. (format code: %M)
disc
Disc number of the album. This is a string to allow tags such as "1/2". (format code: %D)
file
Path to the song. Only attribute which will always be defined. (format code: %f)
genre
Genre of the song. (format code: %g)
id
Id of the song in MPD's database. (format code: %i)
last_modified
Last time the song was modified. (format code: %m)
name
Name of the song (for http streams). (format code: %N)
performer
Song performer. (format code: %P)
pos
Position of the song in the playlist. (format code: %p)
title
Title of the song. (format code: %t)
track
Track number of the song. (format code: %n)
time
Length of the song in seconds. (format code: %l)
METHODS
as_string
my $str = $song->as_string( [$format] );
Return a string representing $song. If $format is specified, use it to format the string. Otherwise, the string returned will be:
either "album = track = artist = title"
or "artist = title"
or "title"
or "file"
(in this order), depending on the existing tags of the song. The last possibility always exist of course, since it's a path.
This method is also used to automatically stringify the $song.
WARNING: the format codes are not yet definitive and may be subject to change!
AUTHOR
Jerome Quelin
COPYRIGHT AND LICENSE
This software is copyright (c) 2007 by Jerome Quelin.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
perl v5.14.2 2012-04-01 Audio::MPD::Common::Item::Song(3pm)