Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Inputing info from a CSV file and filling a template file
Top Forums Shell Programming and Scripting Inputing info from a CSV file and filling a template file Post 302959549 by mojoman on Wednesday 4th of November 2015 10:08:40 AM
Old 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

Filling in characters to line a file up

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

Basic System Info Template

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

Filling file with 10 zeros

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

filling in strings in a template file using awk

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

Match list of strings in File A and compare with File B, C and write to a output file in CSV format

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

Creating a larger .xml file from a template(sample file)

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

Compare 2 files of csv file and match column data and create a new csv file of them

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

Save output of updated csv file as csv file itself

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

Save output of updated csv file as csv file itself, part 2

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)
All times are GMT -4. The time now is 03:03 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy