09-27-2003
Somthing like this may work for you:
#! /usr/bin/ksh
FILE=somefile.txt
cat ${FILE} | sed 's/,/ /g' | while read LINE
do
set ${LINE}
< do what you want to do here>
done
A little explanation. I think you can follow the cat and sed command. The 'while read LINE' basically reads one line at a time and pumps it into the body of the while loop. The 'set ${LINE}' is the cool part. It sets the first string up to the first white space to $1. It sets the second string to the second white space at $2, and so forth. You can then use these variables to do what ever you need to do. This is much more effiecient then doing a for or while loop and then awking each variable individually.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi I am using KSH and trying to read variables from a csv file. I've set the IFS=, and it workds. Problem is where one of the values is text containing a comma. For example the following lines exist in my file. How can I read everything between the quotes into a single variable?
APW13812,,1... (2 Replies)
Discussion started by: ventris
2 Replies
2. Shell Programming and Scripting
I want to be able to convert the following data from a CSV into individual variables from the columns 2 4 and 8
I can use awk to grab the columns using var1=`cat text.csv | awk "," '{print $2}'` but how do I create separate variables for each line.
595358 ,ECON1010 ,THU ,08:00 - 10:00 ,11 Mar... (6 Replies)
Discussion started by: domsmith
6 Replies
3. Shell Programming and Scripting
Hi Fellows,
I have been struggling to fix an issue in csv records to compose sql statements and have been really losing sleep over it. Here is the problem:
I have csv files in the following pipe-delimited format:
Column1|Column2|Column3|Column4|NEWLINE
Address Type|some descriptive... (4 Replies)
Discussion started by: khayal
4 Replies
4. Shell Programming and Scripting
I have a flat file (template) where I want to replace variables based upon a value in another file (csv).
The variables in the template are named %VAR_X_z%
The values are in the csv file and X is field 0 of each line and y field 1 and up.
Example of the csv:
Badidas, 13.00, 12.00, 11.00,... (8 Replies)
Discussion started by: biscayne
8 Replies
5. Shell Programming and Scripting
I'm new to shell scripting so I'm guessing I'm just not looking at this from the correct angle as this has to be a common task.
What I'm trying to do is take data I've compiled for servers (Name, IPs, HBA WWN's, Storage, etc) and trying to turn that into one row in a CSV file.
So
File1:... (3 Replies)
Discussion started by: The_Grim_Coder
3 Replies
6. Shell Programming and Scripting
Hi guys,
New to the forum, and been messing around with Linux for about a year now. I'm still very much a rookie, so just assume that I'm a total idiot:
I currently have a shell that spits out a CSV number string of about 8 numbers as follows:
1.00,2.00,3.00 ... ,8.00I need to assign a... (7 Replies)
Discussion started by: hansol
7 Replies
7. UNIX for Beginners Questions & Answers
I'm trying to use awk to count the occurrences of two matching fields of a CSV file.
For instance, for data that looks like this...
Joe,Blue,Yes,No,High
Mike,Blue,Yes,Yes,Low
Joe,Red,No,No,Low
Joe,Red,Yes,Yes,Low
I've been trying to use code like this...
countvar=`awk ' $2~/$color/... (4 Replies)
Discussion started by: nmoore2843
4 Replies
8. Shell Programming and Scripting
I have a text file that looks like this:
FIELD1, FIELD2, THIS IS FIELD3, FIELD4
FIELD1, FIELD2, THIS IS FIELD3, FIELD4
FIELD1, FIELD2, THIS IS FIELD3, FIELD4
I need it to turn it into an XML file to run against a custom application. My ultimate goal is for it to look like... (15 Replies)
Discussion started by: jeffs42885
15 Replies
9. 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
10. UNIX for Beginners Questions & Answers
Hi..
I need some help in converting the below horizontal lines to vertical lines format.
can anyone help me on this.
input file
Hour,1,2,3,4,5
90RT,106,111,111,112,111
output file
Hour,90RT
1,106
2,111
3,111
4,112
5,111 (3 Replies)
Discussion started by: Raghuram717
3 Replies
MEDIT(1) General Commands Manual MEDIT(1)
NAME
medit - text editor
SYNOPSIS
medit [OPTION]... [FILES]
DESCRIPTION
medit is a text editor.
OPTIONS
-n, --new-app
run new instance of medit. By default medit opens FILES (or creates a new document if none are given) in an existing instance of
application
-s, --use-session[=yes|no]
load and save session. By default medit does it when -n is not used. If this option is not given on command line then medit uses
the corresponding preferences setting.
--pid PID
use existing instance with process id PID.
--app-name NAME
use instance name NAME. If an instance with this name is already running, then it will send files given on the command line to that
instance and exit.
-e, --encoding ENCODING
use provided character encoding to open the file
-l, --line LINE
open file and position cursor on line LINE. Alternatively line number may be specified with filename, e.g. medit foo.txt:12
-r, --reload
automatically reload opened file if it was modified on disk by another program.
-w, --new-window
open file in a new window.
-t, --new-tab
open file in a new tab.
--log-file FILE
write debug output into FILE. This option is only useful on Windows.
--log-window
show debug output in a log window. This option is only useful on Windows.
--debug DOMAINS
enable debug output for DOMAINS (if medit was compiled with --enable-debug option).
--geometry WIDTHxHEIGHT
--geometry WIDTHxHEIGHT+X+Y
default window size and position.
-h, --help
show summary of options.
-v, --version
show program version.
FILES list of files to open. Filenames may include line numbers after colon, e.g. /tmp/file.txt:200. Trailing colon is ignored.
ENVIRONMENT VARIABLES
MEDIT_PID
if set, it is used as --pid argument. When medit spawns a process (e.g. a DVI viewer) it sets MEDIT_PID to its own process id, so
the child process may in turn simply use 'medit filename' to open a file (e.g. for inverse DVI search).
CONTACT
http://mooedit.sourceforge.net/contact.html
AUTHOR
Written and maintained by Yevgen Muntyan <emuntyan@users.sourceforge.net>
September 2010 MEDIT(1)