|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Combine and complete multiple CSV files based on 1 parameter
Post 303021907 by Xterra on Monday 20th of August 2018 10:31:15 AM
08-20-2018
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi,
I want to combine two lines in same file. If the line ends with '&' it should belongs to previous line only
Here i am writing example.
Ex1:
line 1 : return abcdefgh&
line 2 : ijklmnopqr&
line 3 : stuvw&
line 4 : xyz
output should be
line 1: return abcdefghijklmnopqrstuvwxyz
... (11 Replies)
Discussion started by: spc432
11 Replies
2. Shell Programming and Scripting
Hi All
I am trying to combine columns from multiple text files into a single file using paste command but the record length being unequal in the different files the data is running over to the closest empty cell on the left. Please see below.
What can i do to resolve this ?
File 1 File... (15 Replies)
Discussion started by: venky_ibm
15 Replies
3. Shell Programming and Scripting
Hi Freinds
I have two .txt file gem1.txt and gem2.txt,
Sample gem1.txt
abstract (1.0.0)
actionmailer (2.3.5, 2.2.2)
actionpack (2.3.5, 2.2.2)
activerecord (2.3.5, 2.2.2)
activerecord-oracle_enhanced-adapter (1.1.9)
activerecord-sqlserver-adapter (2.3.4)
activeresource (2.3.5, 2.2.2)... (3 Replies)
Discussion started by: ankit_view24
3 Replies
4. Shell Programming and Scripting
I have two files which are as follows:
File 1:
1 abc 250
2 pqr 300
3 xyz 100
File 2:
1 abc 230
2 pqr 700
3 xyz 500
Now I need output File, File 3as:
S.No Name Count1 Count2
1 abc 250 230
2 pqr 300 700
3 xyz 100 500
NOTE: (13 Replies)
Discussion started by: karumudi7
13 Replies
5. Shell Programming and Scripting
I'm rather new to programming, and am attempting to combine lines from 2 files in a way that is way beyond my expertise - any help would be appreciated!
I need to take a file (file1) and add columns to it from another file (file2). However, a line from file2 should only be added to a given line... (3 Replies)
Discussion started by: Cheri
3 Replies
6. Shell Programming and Scripting
Hi,
I have an issue to combine multiple lines of a file. I have records as below.
Fields are delimited by TAB. Each lines are ending with a new line char (\n)
Input
--------
ABC 123456 abcde 987
890456 7890 xyz
ght gtuv
ABC 5tyin 1234 789
ghty kuio
ABC ghty jind 1234
678 ght
... (8 Replies)
Discussion started by: ratheesh2011
8 Replies
7. Shell Programming and Scripting
HI,
I have 3 files that contain the following information (sql output from Oracle database stored in a txt file):
File1.txt :
alter table "SYS"."INT_COST_PRICE" enable row movement;
alter table "SYS"."INT_SOH" enable row movement;
alter table "SYSMAN"."XX_ACI_SKURTP" enable row movement;... (6 Replies)
Discussion started by: rparavastu
6 Replies
8. Shell Programming and Scripting
If a file has following kind of data, comma delimited
1,2,3,4
1
1
1,2,3,4
1,2
2
2,3,4
My required output must have only 4 columns with comma delimited
1,2,3,4
111,2,3,4
1,222,3,4
I have tried many awk command using ORS="" but couldnt progress (10 Replies)
Discussion started by: mdkm
10 Replies
9. Shell Programming and Scripting
Hello
I want to collapse a file with multiple rows into consolidated lines of entries based on selected columns as the 'key'.
Example:
1 2 3 Abc def ghi
1 2 3 jkl mno p qrts
6 9 0 mno def Abc
7 8 4 Abc mno mno abc
7 8 9 mno mno abc
7 8 9 mno j k
So if columns 1, 2 and 3 are... (6 Replies)
Discussion started by: linuxlearner123
6 Replies
10. Shell Programming and Scripting
Dear Team Members,
I have a unique problem. Below is the dataset which I have. I am writing a script which will read through the file and pull the invoice no. (Field 2 of C1 row).
"C1",990001,"L1","HERO","MOTORCYCLE","ASIA-PACIFIC","BEIJING"
"C2","CLUTCH","HYUNDAI",03032017... (13 Replies)
Discussion started by: chetanojha
13 Replies
LEARN ABOUT DEBIAN
sdbtrf
SDBTRF - compute an LU factorization of a real m-by-n band matrix
A without using partial pivoting or row interchanges SUBROUTINE
SDBTRF( M, N, KL, KU, AB, LDAB, INFO )
INTEGER INFO, KL, KU, LDAB, M, N
REAL AB( LDAB, * ) Sdbtrf computes an LU factorization of a
real m-by-n band matrix A without using partial pivoting or row
interchanges.
This is the blocked version of the algorithm, calling Level 3
BLAS.
M
(input) INTEGER The number of rows of the matrix A. M >=
0. N (input) INTEGER The number of columns of the matrix
A. N >;= 0. KL (input) INTEGER The number of subdiagonals
within the band of A. KL >;= 0. KU (input) INTEGER The num-
ber of superdiagonals within the band of A. KU >;= 0. AB
(input/output) REAL array, dimension (LDAB,N) On entry, the ma-
trix A in band storage, in rows KL+1 to 2*KL+KU+1; rows 1 to KL
of the array need not be set. The j-th column of A is stored in
the j-th column of the array AB as follows: AB(kl+ku+1+i-j,j) =
A(i,j) for max(1,j-ku)<;=i<=min(m,j+kl)
On exit, details of the factorization: U is stored as an upper
triangular band matrix with KL+KU superdiagonals in rows 1 to
KL+KU+1, and the multipliers used during the factorization are
stored in rows KL+KU+2 to 2*KL+KU+1. See below for further de-
tails. LDAB (input) INTEGER The leading dimension of the ar-
ray AB. LDAB >;= 2*KL+KU+1. INFO (output) INTEGER = 0: suc-
cessful exit
< 0: if INFO = -i, the i-th argument had an illegal value
> 0: if INFO = +i, U(i,i) is exactly zero. The factorization has
been completed, but the factor U is exactly singular, and divi-
sion by zero will occur if it is used to solve a system of equa-
tions. The band storage scheme is illustrated by the following
example, when M = N = 6, KL = 2, KU = 1:
On entry: On exit:
* a12 a23 a34 a45 a56 * u12 u23 u34 u45 u56
a11 a22 a33 a44 a55 a66 u11 u22 u33 u44 u55 u66
a21 a32 a43 a54 a65 * m21 m32 m43 m54 m65 *
a31 a42 a53 a64 * * m31 m42 m53 m64 * *
Array elements marked * are not used by the routine.