You may pimp up your own approach by adding an address specification. Be aware that it will NOT change the third field if that doesn't contain 165, or change any other field that holds that value.
EDIT: If you want to replace field 3 regardless of its contents, try
P.S.: you might want to adapt the title of your thread.
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 All,
I have a file with data as below:
A,FILE1_MYFILE_20130309_1038,80,25.60
B,FILE1_MYFILE_20130309_1038,24290,18543.38
C,FILE1_dsc_dlk_MYFILE_20130309_1038,3,10.10
A,FILE2_MYFILE_20130310_1039,85,110.10
B,FILE2_MYFILE_20130310_1039,10,12.10... (10 Replies)
Hi all I have a need of searching some pattern in file by month and then count unique records
D11
G11
R11 -------> Pattern available in file
S11
Jan$1 to $5 column contains some records in which I want to find unique
for this purpose I have written script like below
awk '/Jan/ ||... (4 Replies)
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)
Hi All,
I have a requirement where I need to find sum of values from column D through O present in a CSV file and check whether the sum of each Individual column matches with the value present for that corresponding column present in the trailer record.
For example, let's assume for column D... (9 Replies)
file:
1|12322|tow|
5|23422|pow|
6|23423|cow|
3|34324|how|
deletelines:
12322
23423
My command to delete line
while read NUM
do
awk -F"\|" '$2 !~ /`"$NUM"`/' file >file.back
mv file.back file
done<deletelines (3 Replies)
Hi all,
I have searched and searched, but I have not found a solution that quite fits what I am trying to do.
I have a long list of data in three columns. Below is a sample:
1,10,8
2,12,10
3,13,12
4,14,14
5,15,16
6,16,18
Please use code tags
What I need to do is as follows: If a... (4 Replies)
Discussion started by: bleedingturnip
4 Replies
LEARN ABOUT DEBIAN
moosex::types::common::string
MooseX::Types::Common::String(3pm) User Contributed Perl Documentation MooseX::Types::Common::String(3pm)NAME
MooseX::Types::Common::String - Commonly used string types
SYNOPSIS
use MooseX::Types::Common::String qw/SimpleStr/;
has short_str => (is => 'rw', isa => SimpleStr);
...
#this will fail
$object->short_str("string
with
breaks");
DESCRIPTION
A set of commonly-used string type constraints that do not ship with Moose by default.
o SimpleStr
A Str with no new-line characters.
o NonEmptySimpleStr
A Str with no new-line characters and length > 0
o LowerCaseSimpleStr
A Str with no new-line characters, length > 0 and no uppercase characters A coercion exists via "lc" from NonEmptySimpleStr
o UpperCaseSimpleStr
A Str with no new-line characters, length > 0 and no lowercase characters A coercion exists via "uc" from NonEmptySimpleStr
o Password
o StrongPassword
o NonEmptyStr
A Str with length > 0
o LowerCaseStr
A Str with length > 0 and no uppercase characters. A coercion exists via "lc" from NonEmptyStr
o UpperCaseStr
A Str with length > 0 and no lowercase characters. A coercion exists via "uc" from NonEmptyStr
o NumericCode
A Str with no new-line characters that consists of only Numeric characters. Examples include, Social Security Numbers, PINs, Postal
Codes, HTTP Status Codes, etc. Supports attempting to coerce from a string that has punctuation in it ( e.g credit card number
4111-1111-1111-1111 ).
SEE ALSO
o MooseX::Types::Common::Numeric
AUTHORS
Please see:: MooseX::Types::Common
perl v5.14.2 2012-06-14 MooseX::Types::Common::String(3pm)