12-06-2012
Hi biscayne,
If you can show us an example of your template file and a corresponding sample of the output you want to get (based on your example template and CSV files), we can probably give you an awk script that will do it all in one step.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi !!
I have HTML Tables through which i want to generate graphs, but for creating graphs i need the file in CSV format so can anyone can please help me in how can i convert my HTML table file to CSV format.
Thanks in Advance (2 Replies)
Discussion started by: i_priyank
2 Replies
2. UNIX for Dummies Questions & Answers
hello.
I'm somewhat a novice here so please be patient. My stumbling block when loading csvs into ORACLE tables is this:
I need to read a csv datafile, check several fields in each line, and if any of stated fields contain A ZERO only then replace it with a null/blank character.
I had a... (9 Replies)
Discussion started by: MrCarter
9 Replies
3. Shell Programming and Scripting
I've googled a lot on this, but could not fine a simple one-liner to do this.
I have a .csv file that looks like this:
Header one
Header two
Header three
col1,col2,col3
short data, very long data, dataIf I use sed and change the comma to tab, being the colums of variable length I don't get a... (6 Replies)
Discussion started by: ahsog
6 Replies
4. Shell Programming and Scripting
HI,
Please find the text below. I receive a .csv file on server. I need the comma(,) in the second column to be replaced by a semi-colon( ; ).
How to do it. Please help.
Sample text:
"1","lastname1,firstname1","xxxxxx","19/10/2009","23/10/2009","0","N","Leave"... (2 Replies)
Discussion started by: libin4u2000
2 Replies
5. Shell Programming and Scripting
Hi All,
Please give me the solution to the following ASAP.
1) Converting the .xls into .csv
Script i tried,
mv hello.xls hello.csv
The above given script converting the .xls file into .csv successfully. But after i run the below unix command I am no able to open the .csv file, its giving... (4 Replies)
Discussion started by: velava
4 Replies
6. UNIX for Dummies Questions & Answers
Hi
I need to write a bash script to take the data stored in 3 oracle tables .. and filter them and store the results in a csv file.
It is an Oracle database
Thank you (1 Reply)
Discussion started by: ladyAnne
1 Replies
7. Shell Programming and Scripting
Hi there,
i have a file like that in attachment (PLEVA3_280711_SAP.txt), i would extract some basic information from it and report in a new file or table like this:
i try to use bash and i extract the single object in this way (see attach scriptino.sh), but i receive a strange... (5 Replies)
Discussion started by: alen192
5 Replies
8. UNIX for Dummies Questions & Answers
Hi !
I have input.tab with one column containing Item IDs under a number format (the second column is the Location of this item):
Location Item ID
rack1 12; 35; 43
rack35 23; 894; 5478; 98
etc...
(The number of Items per row is variable. Item IDs in a same field are... (17 Replies)
Discussion started by: lucasvs
17 Replies
9. Shell Programming and Scripting
i want to run update query for oracle which is in up.sql taking values from a.csv.
I have implemented shell script to do it.
extn="perl"
ls -1 | while read file
do
echo "$file,$extn" > a.csv
done
up.sql contains
update file_list set filename=$1 where extn=$2;
The code to update is... (2 Replies)
Discussion started by: millan
2 Replies
10. UNIX for Beginners Questions & Answers
I have a source csv file consists of first field as variable name, and the rest are site-specific information (converted from excel file, where site -specific values in columns). I am trying to create a file for every site using a template and replace the multiple variables with values from the... (3 Replies)
Discussion started by: apalex
3 Replies
LEARN ABOUT ULTRIX
lmfsetup
lmfsetup(8) System Manager's Manual lmfsetup(8)
Name
lmfsetup - License Management Facility PAK registration script
Syntax
/etc/lmfsetup [ template ]
Description
The script allows you to register data supplied by a Product Authorization Key (PAK). The script prompts you for the data associated with
each of the fields on a PAK. When all the data has been entered, the License Management Facility (LMF) ensures there are entries against
all the mandatory fields, and that the Checksum validates all the license data. If the data has been entered correctly, the PAK is regis-
tered in the License Database. If the data has been entered incorrectly, the appropriate error message is displayed and you are given the
opportunity to re-enter the data.
The template option allows you to register license data from templates in A template containing a partially complete PAK is created by some
products as part of their installation process. The script only prompts you for data on the fields that are empty in the template. If the
script cannot find the specified template in it searches the current directory.
The script is provided as an alternative to the command. This displays a template, which includes the fields on the PAK, and invokes an
editor so that you can add the license data to the appropriate field. The command also allows errors to be corrected without having to re-
enter all the data.
See Also
lmf(8)
Guide to Software Licensing
lmfsetup(8)