Shell script to convert rows into cloumns Post: 302996524

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

shell script required to convert rows to columns

Hi Friends, I have a log file as below siteid = HYD spc = 100 rset = RS_D_M siteid = DEL spc = 200 rset = RS_K_L siteid = DEL2 spc = 210 rset = RS_D_M Now I need a output like column wise as below. siteid SPC rset HYD 100 RS_D_M

2. Shell Programming and Scripting

Script to convert rows to 1 record with delimter

I have a data file as follows. The 1st line of record starts with "<JOB" and the last line of record ends with "</JOB". There are multiple rows (62 -70) within <JOB and </JOB and it varies. There are multiple records in the file starting with <JOB and ending with </JOB. Sample data: <JOB...

3. Shell Programming and Scripting

extract multiple cloumns from multiple files; skip rows and include filenames; awk

Hello, I am trying to write a bash shell script that does the following: 1.Finds all *.txt files within my directory of interest 2. reads each of the files (25 files) one by one (tab-delimited format and have the same data format) 3. skips the first 10 rows of the file 4. extracts and...

4. Shell Programming and Scripting

Shell script to extract rows from table

I have an Employee with EID, ENAME and ESTATUS as columns in SQL. I want to extract the status of an employee and update the details if the status is 'A'. Can anyone help in writing the shell script.

5. Shell Programming and Scripting

how to convert a shell script to a php script for displaying next word after pattern match

I have a shell script which I made with the help of this forum #!/bin/sh RuleNum=$1 cat bw_rules | sed 's/^.*-x //' | awk -v var=$RuleNum '$1==var {for(i=1;i<=NF;i++) {if($i=="-bwout") print $(i+3),$(i+1)}}' Basically I have a pages after pages of bandwidth rules and the script gives...

6. UNIX for Advanced & Expert Users

converting rows to clumns using shell script

I have a script which converts rows to columns. file_name=$1 mailid=$2 #CREATE BACKUP OF ORIGINAL FILE #cp ${file_name}.xlsx ${file_name}_temp.xlsx #tr '\t' '|' < ${file_name}_temp.xlsx > ${file_name}_temp.csv #rm ${file_name}_temp.xlsx pivot_row=`head -1 ${file_name}` sed 1d...

7. Shell Programming and Scripting

Converting rows to columns using shell script

8. Shell Programming and Scripting

Convert columns to rows in perl script

Hi All I want to have a Perl script which convert columns to rows. The Perl should should read the data from input file. Suppose the input file is 7215484 date to date 173.3 A 1.50 2.23 8.45 10.14 2.00 4.50 2.50 31.32 7216154 month to month

9. Shell Programming and Scripting

Shell script to convert rows to columns

Hi I have a file having the values like below ---------------------------- .set A col1=�ABC� col2=34 col3=�DEF� col4=�LMN� col5=25 .set A .set B col1=55 col3=�XYZ� col4=�PQR� col5=66 .set B .set C col2=�NNN�

10. Shell Programming and Scripting

Help with script to convert rows to columns

Hello I have a large database with the following structure: Headword=Gloss1;Gloss2;Gloss3 The Glosses are separated by a ; What I need is to reduce the multiple glosses on each row to columns Headword=Gloss1 Headword=Gloss2 Headword=Gloss3 I had written the following script in awk...

LEARN ABOUT X11R4

alcc

ALCC(1) 							  aMule utilities							   ALCC(1)

NAME

       alcc - text based eD2k links calculator for aMule

SYNOPSIS

       alcc [-p] [-v] <inputfiles_list>

       alcc [-h]

DESCRIPTION

       Compute the eD2k links of all the input files given in the <inputfiles_list> (There can be one or more files).

       [ -p, --parthashes ]
	      Compute and add part hashes to the computed eD2k links.

       [ -h, --help ]
	      Prints a short usage description.

       [ -v, --verbose ]
	      Be verbose - show also calculation steps.

REPORTING BUGS

       Please report bugs either on our forum (http://forum.amule.org/), or in our bugtracker (http://bugs.amule.org/).  Please do not report bugs
       in e-mail, neither to our mailing list nor directly to any team member.

COPYRIGHT

       aMule and all of its related utilities are distributed under the GNU General Public License.

SEE ALSO

       alc(1), amuled(1), amulecmd(1), amuleweb(1), cas(1), ed2k(1), wxcas(1), xas(1)

AUTHOR

       This manpage was written by Vollstrecker <amule@vollstreckernet.de>

aMule eD2k links calculator					   November 2011							   ALCC(1)