11-04-2015
Inputing info from a CSV file and filling a template file
Hi,
I have a .csv file that contains a variety of fields for 60 clients: USERNAME, PASSWORD, and COMMENTS. I have a template file which contains a great deal of data for each client and has the fields USERNAME, PASSWORD, and COMMENTS that has to be filled with the values of USERNAME, PASSWORDS,and COMMENTS from the .csv file. So in the end I will need 60 client files based on the template file gathered fromt he info in the .csv file.
I know awk/sed can be used in shell scripting is possible so anyone have any idea how to go about writing some code for this? Perl is an option as well I have available to me as well.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi there, Ive got a feeling this is quite complex but I have a Comma delimited file which is being transfered up to a mainframe and I have to get every column lining up , I need to add in characters to line it up (but different characters and in different positions based on what field/column it... (1 Reply)
Discussion started by: hcclnoodles
1 Replies
2. UNIX for Dummies Questions & Answers
If your boss ask you to create a template for all UNIX systems. Max 10 questions of the system. What would you put down?
The system can be any UNIX flavor.
Some examples:
1. system name
2. OS
3. ETC
What would be for you the most important and relevants. (2 Replies)
Discussion started by: 300zxmuro
2 Replies
3. Shell Programming and Scripting
I am stuck with a problem.
I have some 100 files with extension .txt.
The files look like this:
0
3
0
0
4
All files have variable number of characters and some files are completely EMPTY.
I want to make columns of length 10 by putting zeros (0) after the numbers end and also 10... (1 Reply)
Discussion started by: shoaibjameel123
1 Replies
4. Shell Programming and Scripting
Hi all,
I have a template form to fill in for quite a number of files and I want to automate the filling-in process. the concept seemed to be simple but i cant get it work. the template form is a text file containing the information below:
File Name:
Date Created:
Contents:
I need to... (4 Replies)
Discussion started by: ida1215
4 Replies
5. Shell Programming and Scripting
Hi Friends,
I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving...
File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Discussion started by: asnandhakumar
6 Replies
6. Shell Programming and Scripting
Dear All,
I have a template xml file like below.
....Some---Header.......
<SignalPreference>
...
<SignalName>STRING</SignalName>
...
</SignalPreference>
......Some formatting text.......
<SignalPreference>
.........
... (3 Replies)
Discussion started by: ks_reddy
3 Replies
7. Shell Programming and Scripting
Hi, I am newbie in shell script.
I need your help to solve my problem.
Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file.
File1:
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies
8. Shell Programming and Scripting
Hi, all
I want to sort a csv file based on timestamp from oldest to newest and save the output as csv file itself. Here is an example of my csv file.
test.csv
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0739.JPG,2015:02:17 11:32:21
/home/intannf/foto/IMG_0749.JPG,2015:02:17 11:37:28... (10 Replies)
Discussion started by: refrain
10 Replies
9. Shell Programming and Scripting
Hi,
I have another problem. I want to sort another csv file by the first field.
result.csv
SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw
/home/intannf/foto5/2015_0313_090651_219.JPG,0.,-7.77223,110.37310,30.75,996.46,148.75,180.94,182.00,63.92 ... (2 Replies)
Discussion started by: refrain
2 Replies
LEARN ABOUT DEBIAN
netio230a-cli
NETIO230A-CLI(1) General Commands Manual NETIO230A-CLI(1)
NAME
netio230a-cli - CLI to python-netio230a
SYNOPSIS
netio230a-cli [--host HOST] [--port PORT] [--username USERNAME] [--password PASSWORD] -s SOCKET [--on]
DESCRIPTION
netio230a-cli is a command line interface to access the Koukaam NETIO-230A, a cheap but advanced multiple socket with Ethernet control.
Options:
-?
show help message and exit
-h HOST, --host=HOST
Hostname for the device (defaults to the first one found by the discovery in your LAN)
-p PORT, --port=PORT
TCP port (defaults to 1234)
-u USERNAME, --username=USERNAME
username to use for login (defaults to admin)
-w PASSWORD, --password=PASSWORD
password to use for login (will ask if left empty)
-s SOCKET#, --socket=SOCKET#
socketnumber (1-4) to switch on/off
--on
switch on when --on set, off if omitted
AUTHOR
netio230a-cli was written by Philipp Klaus <philipp.l.klaus@web.de>.
This manual page was written by Philipp Huebner <debalance@debian.org>, for the Debian project (and may be used by others).
SEE ALSO
netio230a-discover(1), netio230a-gui(1)
netio230a-cli 2010-03-09 NETIO230A-CLI(1)