I need a script which will pick up the data from a .CSV file and reformat it as per the requirement and write it to another .CSV file.
I am using an application that will only take data in a particular format and need something that will convert without manual intervention.
The original data is in sample 1.csv and final output should look like something in sample 2.csv
The very first line should start with a "ONE record," and should break after 9 commas. Then a "Child Record" should be created followed by the renaming characters from 9th comma on.
It should repeat as "Child record" from 9th comma on as long as the names (milani, DRS, etc) are the same. But if it encounters a new name, it should create a new "One Record" and the process should follow till it hits the end of the csv file.
Hi There
I needed to write a Unix shell script which will pick up the data from a .CSV file and reformat it as per the requirement and write it to another .CSV file.
Currently I am in the proess of Data Import to "Remedy System" (A one kind of incident mangement Application) and this... (8 Replies)
Hi all,
I have written a shell script to search a specified directory (e.g. /home/user) for a list of specific words (shown as ${TMPDIR}/wordlist below). The script works well enough, but I was wondering if there was a way to display the line number that the word is found on?
Thanks!
cat... (1 Reply)
Hi All,
I have created a Unix Shell script whch creates a *.csv file and export it to Excel.
The problem i am facing is that Users wants one of the AMOUNT field in comma separted values. Example :
if the Amount has the value as 3000000 User wants to be in 3,000,000 format.
This Amount format... (2 Replies)
Hi Unix Gurus,
I tried to convert the attached xhtml table content into csv file using unix shell script (lynx -dump filename) and got the below results:
Title ID Owner Priority Estimate Project Change Date Changed By
Complexity Create Date Created By Detail Estimate Total De tail... (6 Replies)
Hallo Friends,
I need you help. My file has 5000 or so lines and currently looks like below(sample).
Service Type,Origin,Destination,Rate Per Minute,Minimum Charge,Time Based Rate,Time Based From Day,Time Based To Day,Time Based From Time,Time Based To Time,Destination Prefix List,,
VoIS... (3 Replies)
Hi all,
I am new here, please don't eat me alive..
I am trying to find a good community to learn and participate in unix / linux discussions to help me improve in my current job.
That being said, I have a problem which I didn't expect to challenge me, but I can't seem to find a viable... (8 Replies)
User Aia had created this below script to help translate LDIF files to CSV format, and it works very well (thanks again Aia if you are reading this)
Here is the original thread.
https://www.unix.com/shell-programming-and-scripting/265753-ldap-data-csv-format.html?referrerid=302170129
However... (2 Replies)
I am new to html and need to convert the attached csv file data to html format ; running into issues. please assist.
#!/bin/ksh
echo "<html>" ;
echo "<head><style> table {border-collapse: collapse;} table, td, th {border: 1px solid black;} </style></head>"
echo "<title> REPORT </title>"
echo... (0 Replies)
HI ,
I m looking for help here!!!
Can we filter the below log data into CSV format ?
timestamp INFO <text > - Some text Drive ..
Need a format of separate field such as
1 2 3 4 ... (2 Replies)
I m looking for help here!!!
Can we filter the below log data into CSV format ?
1 2 3 4 5 6 7 8
timestamp INFO <text > - Some text (1 Reply)
Discussion started by: MohSalNiz
1 Replies
LEARN ABOUT DEBIAN
slags2.f
slags2.f(3) LAPACK slags2.f(3)NAME
slags2.f -
SYNOPSIS
Functions/Subroutines
subroutine slags2 (UPPER, A1, A2, A3, B1, B2, B3, CSU, SNU, CSV, SNV, CSQ, SNQ)
SLAGS2
Function/Subroutine Documentation
subroutine slags2 (logicalUPPER, realA1, realA2, realA3, realB1, realB2, realB3, realCSU, realSNU, realCSV, realSNV, realCSQ, realSNQ)
SLAGS2
Purpose:
SLAGS2 computes 2-by-2 orthogonal matrices U, V and Q, such
that if ( UPPER ) then
U**T *A*Q = U**T *( A1 A2 )*Q = ( x 0 )
( 0 A3 ) ( x x )
and
V**T*B*Q = V**T *( B1 B2 )*Q = ( x 0 )
( 0 B3 ) ( x x )
or if ( .NOT.UPPER ) then
U**T *A*Q = U**T *( A1 0 )*Q = ( x x )
( A2 A3 ) ( 0 x )
and
V**T*B*Q = V**T*( B1 0 )*Q = ( x x )
( B2 B3 ) ( 0 x )
The rows of the transformed A and B are parallel, where
U = ( CSU SNU ), V = ( CSV SNV ), Q = ( CSQ SNQ )
( -SNU CSU ) ( -SNV CSV ) ( -SNQ CSQ )
Z**T denotes the transpose of Z.
Parameters:
UPPER
UPPER is LOGICAL
= .TRUE.: the input matrices A and B are upper triangular.
= .FALSE.: the input matrices A and B are lower triangular.
A1
A1 is REAL
A2
A2 is REAL
A3
A3 is REAL
On entry, A1, A2 and A3 are elements of the input 2-by-2
upper (lower) triangular matrix A.
B1
B1 is REAL
B2
B2 is REAL
B3
B3 is REAL
On entry, B1, B2 and B3 are elements of the input 2-by-2
upper (lower) triangular matrix B.
CSU
CSU is REAL
SNU
SNU is REAL
The desired orthogonal matrix U.
CSV
CSV is REAL
SNV
SNV is REAL
The desired orthogonal matrix V.
CSQ
CSQ is REAL
SNQ
SNQ is REAL
The desired orthogonal matrix Q.
Author:
Univ. of Tennessee
Univ. of California Berkeley
Univ. of Colorado Denver
NAG Ltd.
Date:
November 2011
Definition at line 152 of file slags2.f.
Author
Generated automatically by Doxygen for LAPACK from the source code.
Version 3.4.1 Sun May 26 2013 slags2.f(3)