Search Results

awk -F"," 'FNR==1{next}; ....'

Hi, @RudiC
awk '
NR==FNR {pat[$1] = $2
next
}
{print substr($0, 134, 12)
}
' FS='|' File2.txt File1.txt | cat -vet

606951-000 $
606951-000 $
607650-000 ...

The OP specified , that's what the formatted sprintf is for. As the sample data are just 10 byte long, not 12, we need to wait until resolved by the OP, we can just guess. Try this simplified but...

In awk, the substr() function is used to extract (partial) strings, but can't be assigned to. You'd need to either break up the line, with substr()s, and reassemble with the new data, or use the...

a slight mod:

awk '
/<accountHolderName/ {accH=FNR}
FNR==NR {
if (/<AdditionalAccountHolders/) {s[accH]=$0;f++;next}
if (f) s[accH]= s[accH] ORS $0
if...

well... your original sample data contained only ONE holder record - not 2 as in the new sample.
You should be more descriptive in the future...
Let me rework the suggestion with the NEW sample.

Hi, try:
awk '{sub(/[ ,]+$/,"",$1); print}' FS='\t' OFS='\t'

or

awk '{sub(/[ ,]+\t/,"\t"); print}'

Please get accustomed to reading man awk!

awk works on pattern {action} pairs for every input record: execute action if pattern is TRUE.

awk '
rec_type1=substr($0,13,4) #...

How about

awk '/AM00/ {SUFFIX = $NF} /AM01/ {CARD = $NF; $0 = $0 FS SUFFIX} /AM32/ {$0 = $0 FS SUFFIX FS CARD} 1' FS=, file3
AM00,1,12345
AM01,ab,677,12345
AM32,10,12345,677
...

awk -F, '$1=="AM00" {n=$NF;print;next} NF && !/--/ {$(NF+1)=n}1' OFS=, myFile

BEGIN {
split(token_search_string, a, "|")
}
{
{
s=t=$0
for(i=1;i in a; i++) {
t=s
while (match(t, a[i])) {
print substr(t, RSTART, token_search_length)
...

In the shell
token_search_string='536088|547698'

You need a -v option for each variable you're setting; not just the first one.

If there is any chance that string_to_search could contain any whitespace characters or characters that have special...

Try awk '!$6{$6=0}1' FS="|" OFS="|" file

sed 's|/\([0-9][0-9]*\)|FW_SLASH\1|g' infile

I'm not sure if this is general enough for your real input, but the following awk script works for your input sample:
awk -v sq="'" '
copy { print
next
}
found && $2 == "AS" {
...

Whoops, typo.

ls -tp abc* | grep -v "/$" | awk -v MAX="$1" 'NR > MAX' | xargs echo rm

Try:
awk -F\| '$6+0>0' file

Try this (and don´t forget the code tags in your posts):
awk -F\| 'NR==FNR{a[$1]++;next}a[$1]' file1 file2

And here's the awk version...

awk -F\| '{
n=split($2,a,"-")
for (i=n; i; i--) {
if (a[i]=="Jan") a[i]="01"
else if (a[i]=="Feb") a[i]="02"
else if...

#!/usr/bin/ksh
mValue=$(cat File2)
sed "s/var_hostname/${mValue}/" File1

sed "s#'[^'][^']*#'newdate#1" myFile

replace
match pattern: single-quote followed by anything BUT a single-quote repeated 1 or more time
with
single-quote followed by a string newdate

1 -...

BEGIN {
mon="JAN|FEB|MAR|APR|MAY|JUN|JUL|AUG|SEP|OCT|NOV|DEC"
# Create an array where mon[1]=JAN, mon[2]=FEB, etc.
monN=split(mon, monA, "|");
}
{
# NF is the number of fields, $NF...

nawk -F'|' -f pc.awk OFS='|' myFile

pv.awk:

BEGIN {
mon="JAN|FEB|MAR|APR|MAY|JUN|JUL|AUG|SEP|OCT|NOV|DEC"
monN=split(mon, monA, "|");
}
{
n=split($NF,a,"[/ ]")
...

sed 's/\(sysdate-[0-9]*\)/&000/' file