Sponsored Content
Top Forums Shell Programming and Scripting Convert Data from Column to Row Post 302938976 by asavaliya on Friday 20th of March 2015 01:26:06 PM
Old 03-20-2015
Convert Data from Column to Row

Hi

FileA.txt

Code:
E_TIM	16,
ETE	15,
EOND	26,
EEC	81,
E_1	un,
E_2	un,
E_3	un,
E_4	284,
E_TIM	17,
ETE	15,
EOND	29,
EEC	82,
E_1	un,
E_2	un,
E_3	un,
E_4	249,

Output FileB.txt

Code:
E_TIM	ETE	EOND	EEC	E_1	E_2	E_3	E_4
16,	15,	26,	81,	un,	un,	un,	284,
17,	15,	29,	82,	un,	un,	un,	249,

After 8 line data will be change but first column is same.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

convert column into row with some modifier

A file content have 1 1:-0.289433 2:0.833778 3:0.314471 4:-0.289433 5:-0.81876 6:-0.456693 7:-0.17511 8:-0.644555 9:-0.00666341 10:-1.13603 I will like to have that column into row with numbers to be printed (red color) only after colon output shud be like that -0.289433... (1 Reply)
Discussion started by: cdfd123
1 Replies

2. Shell Programming and Scripting

column to row convert - script - help

Hi, I have a file named col.txt 1.000 2.000 3.000 4.000 5.000 6.000 7.000 8.000 I should get this 1.000 5.000 2.000 6.000 3.000 7.000 (10 Replies)
Discussion started by: G0Y
10 Replies

3. Shell Programming and Scripting

Convert column values into row

hi, I have a requirement where in I read the values from a file using awk. The resulting data should be converted into row format from column format. For ex: My log file login.lst contains the following SERVER1 DB1 SERVER2 DB2 SERVER3 DB3 SERVER4 DB4 I use awk to grep only the server... (6 Replies)
Discussion started by: senthil3d
6 Replies

4. 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

5. Shell Programming and Scripting

How to convert 2 column data into multiple columns based on a keyword in a row??

Hi Friends I have the following input data in 2 columns. SNo 1 I1 Value I2 Value I3 Value SNo 2 I4 Value I5 Value I6 Value I7 Value SNo 3 I8 Value I9 Value ............... ................ SNo N (1 Reply)
Discussion started by: ks_reddy
1 Replies

6. 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

7. Shell Programming and Scripting

Convert row to column

Hi, I have a file like this 50 1 2 1374438 50 1 2 1682957 50 5 2 1453574 50 10 2 1985890 100 1 2 737307 100 5 2 1660204 100 10 2 2148483 and I want to convert this by... (1 Reply)
Discussion started by: gvj
1 Replies

8. 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

9. Shell Programming and Scripting

convert row to column with respect of first column.

Input file A.txt :- C2062 -117.6 -118.5 -117.5 C5145 0 0 0 C5696 0 0 0 Output file B.txt C2062 X -117.6 C2062 Y -118.5 C2062 Z -117.5... (4 Replies)
Discussion started by: asavaliya
4 Replies

10. Shell Programming and Scripting

Script: Convert row in to column

Hi, i need to convert SG_ERP1 SG_ERP2 SG_ERP3 in to: SG_ERP1 SG_ERP2 SG_ERP3 It's possibile? (16 Replies)
Discussion started by: elilmal
16 Replies
EXPINT(3pm)						User Contributed Perl Documentation					       EXPINT(3pm)

NAME
PDL::GSLSF::EXPINT - PDL interface to GSL Special Functions DESCRIPTION
This is an interface to the Special Function package present in the GNU Scientific Library. SYNOPSIS
FUNCTIONS
gsl_sf_expint_E1 Signature: (double x(); double [o]y(); double [o]e()) E_1(x) := Re[ Integrate[ Exp[-xt]/t, {t,1,Infinity}] ] gsl_sf_expint_E1 does not process bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_sf_expint_E2 Signature: (double x(); double [o]y(); double [o]e()) E_2(x) := Re[ Integrate[ Exp[-xt]/t^2, {t,1,Infity}] ] gsl_sf_expint_E2 does not process bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_sf_expint_Ei Signature: (double x(); double [o]y(); double [o]e()) Ei(x) := PV Integrate[ Exp[-t]/t, {t,-x,Infinity}] gsl_sf_expint_Ei does not process bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_sf_Shi Signature: (double x(); double [o]y(); double [o]e()) Shi(x) := Integrate[ Sinh[t]/t, {t,0,x}] gsl_sf_Shi does not process bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_sf_Chi Signature: (double x(); double [o]y(); double [o]e()) Chi(x) := Re[ M_EULER + log(x) + Integrate[(Cosh[t]-1)/t, {t,0,x}] ] gsl_sf_Chi does not process bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_sf_expint_3 Signature: (double x(); double [o]y(); double [o]e()) Ei_3(x) := Integral[ Exp[-t^3], {t,0,x}] gsl_sf_expint_3 does not process bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_sf_Si Signature: (double x(); double [o]y(); double [o]e()) Si(x) := Integrate[ Sin[t]/t, {t,0,x}] gsl_sf_Si does not process bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_sf_Ci Signature: (double x(); double [o]y(); double [o]e()) Ci(x) := -Integrate[ Cos[t]/t, {t,x,Infinity}] gsl_sf_Ci does not process bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. gsl_sf_atanint Signature: (double x(); double [o]y(); double [o]e()) AtanInt(x) := Integral[ Arctan[t]/t, {t,0,x}] gsl_sf_atanint does not process bad values. It will set the bad-value flag of all output piddles if the flag is set for any of the input piddles. AUTHOR
This file copyright (C) 1999 Christian Pellegrin <chri@infis.univ.trieste.it> All rights reserved. There is no warranty. You are allowed to redistribute this software / documentation under certain conditions. For details, see the file COPYING in the PDL distribution. If this file is separated from the PDL distribution, the copyright notice should be included in the file. The GSL SF modules were written by G. Jungman. perl v5.14.2 2012-05-30 EXPINT(3pm)
All times are GMT -4. The time now is 09:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy