Sponsored Content
Top Forums Shell Programming and Scripting awk script to append suffix to column when column has duplicated values Post 303017094 by RudiC on Wednesday 9th of May 2018 04:41:50 AM
Old 05-09-2018
Scenario 1:
Code:
awk -F\| '
$1 == "CR"      {IX = $3
                 if (!T[IX]) T[IX] = S[IX] = 96
                 $3 = $3 sprintf ("%s%c%s", A[IX], ++T[IX], $1)
                 if (T[IX] > 121)       {A[IX] = sprintf ("%c", ++S[IX])
                                         T[IX] = 96
                                        }
                }
1
' OFS=\| file

Scenario 2:
Code:
awk -F\| '
$1 == "DR"      {IX = $3
                 if (!T[IX])    T[IX] = S[IX] = 96
                 else           $3 = $3 sprintf ("%s%c%s", A[IX], ++T[IX], $1)
                 if (T[IX] > 121)       {A[IX] = sprintf ("%c", ++S[IX])
                                         T[IX] = 96
                                        }
                }
1
' OFS=\| file

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

for each different entry in column 1 extract maximum values from column 2 in unix/awk

Hello, I have 2 columns (1st column has multiple entries but the corresponding values in the column 2 may be the same or different.) however I want to extract unique values for each entry in column 1 by assigning the max value from column 2 SDF4 -0.211654 SDF4 0.978068 ... (1 Reply)
Discussion started by: Diya123
1 Replies

2. Shell Programming and Scripting

AWK script to create max value of 3rd column, grouping by first column

Hi, I need an awk script (or whatever shell-construct) that would take data like below and get the max value of 3 column, when grouping by the 1st column. clientname,day-of-month,max-users ----------------------------------- client1,20120610,5 client2,20120610,2 client3,20120610,7... (3 Replies)
Discussion started by: ckmehta
3 Replies

3. UNIX for Dummies Questions & Answers

append column and row header to a file in awk script.

Hi! Is there a way to append column and row header to a file in awk script. For example if I have Jane F 39 manager Carlos M 40 system administrator Sam F 20 programmer and I want it to be # name gend age occup 1 Jane F 39 manager 2 Carlos M ... (4 Replies)
Discussion started by: FUTURE_EINSTEIN
4 Replies

4. Shell Programming and Scripting

awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column

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)
Discussion started by: jacobs.smith
3 Replies

5. Shell Programming and Scripting

Match value in column and append file with new values

Hi, I need help to match two files based on two columns. file_1 ID AA An Ca Ele Pro Su Ot Tra g13950 No No Yes No Yes Yes Yes Yes g05760 Yes No No No No Yes Yes Yes g12640 No No No No No No No No k17720 No Yes No No No No No Yes g05640 Yes Yes Yes No No Yes Yes Yes file_2 ... (8 Replies)
Discussion started by: redse171
8 Replies

6. Shell Programming and Scripting

How to delete 'duplicated' column values and make a delimited file too?

Hi, I have the following output from an Oracle SQL statement and I want to remove duplicated column values. I know it is possible using Oracle analytical/statistical functions but unfortunately I don't know how to use any of those. So now, I've gone to PLAN B using awk/sed maybe or any... (5 Replies)
Discussion started by: newbie_01
5 Replies

7. Shell Programming and Scripting

Trying to get an awk script to replace values in column

I'm trying to make an awk script to compare values I've set as var1, var2, and var3 earlier in the script to the values in the userinputted column of four text files called Node1.txt, Node2.txt, Node3.txt, and Node4.txt and then replace the values in that userinputted column with either ttt or gcc,... (8 Replies)
Discussion started by: Eric1
8 Replies

8. Shell Programming and Scripting

Matching column value from 2 different file using awk and append value from different column

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

9. Shell Programming and Scripting

awk to Sum columns when other column has duplicates and append one column value to another with Care

Hi Experts, Please bear with me, i need help I am learning AWk and stuck up in one issue. First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique. Second point : For... (1 Reply)
Discussion started by: as7951
1 Replies

10. Shell Programming and Scripting

Need awk or Shell script to compare Column-1 of two different CSV files and print if column-1 matche

Example: I have files in below format file 1: zxc,133,joe@example.com cst,222,xyz@example1.com File 2 Contains: hxd hcd jws zxc cst File 1 has 50000 lines and file 2 has around 30000 lines : Expected Output has to be : hxd hcd jws (5 Replies)
Discussion started by: TestPractice
5 Replies
explain_sprintf_or_die(3)				     Library Functions Manual					 explain_sprintf_or_die(3)

NAME
explain_sprintf_or_die - formatted output conversion and report errors SYNOPSIS
#include <libexplain/sprintf.h> int explain_sprintf_or_die(char *data, const char *format, ...); int explain_sprintf_on_error(char *data, const char *format, ...); DESCRIPTION
The explain_sprintf_or_die function is used to call the sprintf(3) system call. On failure an explanation will be printed to stderr, obtained from the explain_sprintf(3) function, and then the process terminates by calling exit(EXIT_FAILURE). The explain_sprintf_on_error function is used to call the sprintf(3) system call. On failure an explanation will be printed to stderr, obtained from the explain_sprintf(3) function, but still returns to the caller. data The data, exactly as to be passed to the sprintf(3) system call. format The format, exactly as to be passed to the sprintf(3) system call. RETURN VALUE
The explain_sprintf_or_die function only returns on success, see sprintf(3) for more information. On failure, prints an explanation and exits, it does not return. The explain_sprintf_on_error function always returns the value return by the wrapped sprintf(3) system call. EXAMPLE
The explain_sprintf_or_die function is intended to be used in a fashion similar to the following example: int result = explain_sprintf_or_die(data, format, ...); SEE ALSO
sprintf(3) formatted output conversion explain_sprintf(3) explain sprintf(3) errors exit(2) terminate the calling process COPYRIGHT
libexplain version 0.52 Copyright (C) 2010 Peter Miller explain_sprintf_or_die(3)
All times are GMT -4. The time now is 03:30 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy