Sponsored Content
Top Forums Shell Programming and Scripting How to get row data printed in column using awk? Post 303002548 by Scrutinizer on Sunday 27th of August 2017 11:39:45 AM
Old 08-27-2017
Try:
Code:
awk '
  BEGIN {
    RS=""
    OFS="\t"
    keys="MSISDN:\tSUBSTYPE:\tNPREFIX:\tmodifyTimestamp:"
    n=split(keys,F)
    print keys
  } 

  {
    for(i=1; i<=NF; i+=2) A[$i]=$(i+1)
    $0=""
    for(i=1; i<=n; i++) $i=A[F[i]]
    print
  }
' file

Code:
MSISDN:	SUBSTYPE:	NPREFIX:	modifyTimestamp:
400512345677	3	QT	20170216121047Z
400512345678	3	QT	20170223114401Z


Last edited by hicksd8; 04-27-2020 at 09:44 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Format - Inventory Row data into Column - Awk - Nawk

Hi All, I have the following file that has computer data for various pcs in my network... Snap of the file is as follows ******************************************************************************* Serial 123456 Computer IP Address lo0:... (1 Reply)
Discussion started by: aavam
1 Replies

2. Shell Programming and Scripting

Convert row data to column data

Hi Guys, I have a file as follows: a 1 b 786 c 90709 d 99 a 9875 b 989 c 887 d 111 I want: a 1 9875 b 786 989 (3 Replies)
Discussion started by: npatwardhan
3 Replies

3. Shell Programming and Scripting

row to column and position data in to fixed column width

Dear friends, Below is my program and current output. I wish to have 3 or 4 column output in order to accomodate in single page. i do have subsequent command to process after user enter the number. Program COUNT=1 for MYDIR in `ls /` do VOBS=${MYDIR} echo "${COUNT}. ${MYDIR}" ... (4 Replies)
Discussion started by: baluchen
4 Replies

4. Shell Programming and Scripting

Moving data from a specified column/row to another column/row

Hello, I have an input file like the following: 11_3_4 2_1_35 3_15__ _16989 Where '_' is a space. The data is in a table. Is there a way for the program to prompt the user for x1,y1 and x2,y2, where x1,y1 is the desired number (for example x=6 y=4 is a value of 4) and move to a desired spot... (2 Replies)
Discussion started by: jl487
2 Replies

5. Shell Programming and Scripting

Awk to add selected row column data

Looks at the most efficient way to add up the column of data based off of the rows. Random data Name-Number-ID Sarah-2.0-15 Bob-6.3-15 Sally-1.0-10 James-1.0-10 Scotty-10.7-15 So I would select all those who have ID = 15 and then add up total number read - p "Enter ID number" Num ... (3 Replies)
Discussion started by: Ironguru
3 Replies

6. Shell Programming and Scripting

Subtracting each row from the first row in a single column file using awk

Hi Friends, I have a single column data like below. 1 2 3 4 5 I need the output like below. 0 1 2 3 4 where each row (including first row) subtracting from first row and the result should print below like the way shown in output file. Thanks Sid (11 Replies)
Discussion started by: ks_reddy
11 Replies

7. UNIX for Advanced & Expert Users

Convert column data to row data using shell script

Hi, I want to convert a 3-column data to 3-row data using shell script. Any suggestion in this regard is highly appreciated. Thanks. (4 Replies)
Discussion started by: sktkpl
4 Replies

8. Shell Programming and Scripting

awk - script help: column to row format of data allignment?

Experts Good day, I have the following data, file1 BRAAGRP1 A2X B2X C2X D2X BRBGRP12 A3X B3X Z10 D09 BRC1GRP2 LO01 (4 Replies)
Discussion started by: rveri
4 Replies

9. UNIX for Dummies Questions & Answers

awk to print first row with forth column and last row with fifth column in each file

file with this content awk 'NR==1 {print $4} && NR==2 {print $5}' file The error is shown with syntax error; what can be done (4 Replies)
Discussion started by: cdfd123
4 Replies

10. Shell Programming and Scripting

Column to Row Data.

HI Guys, I have below Input :- X L1 5 Y L1 10 Z L1 15 X L2 20 Y L2 12 Z L2 15 X L3 100 Y L3 Z L3 300 Output:- ID L1 L2 L3 X 5 10 15 Y 20 12 15 Z 100 Null 300 (11 Replies)
Discussion started by: pareshkp
11 Replies
ypmatch(1)							   User Commands							ypmatch(1)

NAME
ypmatch - print the value of one or more keys from a NIS map SYNOPSIS
ypmatch [-k] [-t] [-d domain] key [key...] mname ypmatch -x DESCRIPTION
ypmatch prints the values associated with one or more keys from the NIS's name services map specified by mname, which may be either a map name or a map nickname. Multiple keys can be specified; all keys will be searched for in the same map. The keys must be the same case and length. No pattern match- ing is available. If a key is not matched, a diagnostic message is produced. OPTIONS
The following options are supported: -k Before printing the value of a key, print the key itself, followed by a colon (:). -t Inhibit map nickname translation. -d domain Specify a domain other than the default domain. -x Display the map nickname table. This lists the nicknames the command knows of, and indicates the map name associated with each nickname. OPERANDS
The following operand is supported: mname The NIS's name services map EXIT STATUS
The following exit values are returned: 0 Successful operation. 1 An error occurred. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWnisu | +-----------------------------+-----------------------------+ SEE ALSO
ypcat(1), ypfiles(4), attributes(5) NOTES
ypmatch will fail with an RPC error message on yp operation if enough file descriptors are not available. The number of file descriptors should be increased if this occurs. SunOS 5.10 22 Aug 1997 ypmatch(1)
All times are GMT -4. The time now is 03:22 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy