I have a comma delimited file that sometimes has addresses details in. The problem is that the address detail can be seen as:
"Sample House, Sample Road". When I run a script specifying the file is comma delimited I would like it to ignore comma's that are in between speech marks.
Is this... (2 Replies)
Hi experts,
I need urget help! I have the a text file with this format:
Types of fruits
Name of fruits
1,1
Farm_no,1
apple,1
pineapple,1
grapes,1
orange,1
banana,1
2,2--->this is the record seperator
Farm_no,2
apple,1
pineapple,1
grapes,3
orange,2
banana,1
3,3--->this is the... (1 Reply)
Hi All,
I have output of sql saved in comma separated file.
Now i need to read line by line this file
and assign word to a unix variable for further processing
Eg:
Test file
world, 1, 3, 4
earth,2,3,4,5
moon,1,2,3,4
Output should be
word1= world
word2=1
echo " first word... (7 Replies)
I have a flat file whose contents are comma delimited and there are 84 columns in total, so everytime I try to view the contents, things get over lapped it becomes diffcult to read through the result set.
Is there a command / what would be the best way...if I want to view the results alligned... (4 Replies)
Hi,
I have a comma (,) delimited file, in which few fields are enclosed with in double quotes " ". I have to print the records in the file which donot have expected number of field with the line number.
File1
====
name,desgnation,doj,project #header#... (7 Replies)
Question about how to change the first & last name in column one & two so that the names have a capital letter for just the first letter. Example:
asdf@asdf.com,asdf,asdfasdf,176.23.22.345,4/12/2012
changed to:
asdf@asdf.com,Asdf,Asdfasdf,176.23.22.345,4/12/2012
Thank you kindly,
Nick (2 Replies)
Hi All,
I need a unix script to convert .csv files to .skv files (changing a comma delimited file to a semi colon delimited file). I am a unix newbie and so don't know where to start. The script will be scheduled using cron and needs to convert each .csv file in a particular folder to a .skv... (4 Replies)
Hi,
I am wanting to create a script that will construct a SQL statement based on a a space delimited string that it read from a config file.
Example of the SQL will be
For example, it will read a string like "AAA BBB CCC" and assign to a variable named IN_STRING.
I then concatenate... (2 Replies)
can anyone help me!!!! How to I parse the CSV file
file name : abc.csv (csv file) The above file containing data like
abv,sfs,,hju,',',jkk wff,fst,,rgr,',',rgr ere,edf,erg,',',rgr,rgr I have a requirement like i have to extract different field and assign them into different... (4 Replies)
Discussion started by: J.Jena
4 Replies
LEARN ABOUT BSD
mkerrlst
MKERRLST(1) General Commands Manual MKERRLST(1)NAME
mkerrlst - create system error file
SYNOPSIS
mkerrlst [ -i inputfile ] [ -o outputfile ]
DESCRIPTION Mkerrlst(1) creates error message files in the format described by syserrlst(5).
With no arguments mkerrlst creates the file /etc/syserrlst from the internal array sys_errlist.
Give just the -o option mkerrlst will create the file outputfile from the internal array sys_errlist.
Given just the -i option mkerrlst will create the file /etc/syserrlst from the input file inputfile.
Given both -i and -o options mkerrlst will create the error message file outputfile from the strings contained in inputfile.
NOTE: error messages are numbered from 0. If the error 0 does not have a message associated with it the first string in inputfile must
still be present.
RETURN VALUE
mkerrlst exits with status of 0 if no errors are encountered. If errors do occur an error message is printed on stderr and the exit status
is 1.
ERRORS mkerrlst(1) can encounter any of the errors for the open(2), lseek(2), read(2), or write(2) system calls.
SEE ALSO syserrlst(3)syserrlst(5)HISTORY mkerrlst(1), first appeared in 2.11BSD.
BUGS
Error messages can be a maximum of 80 characters.
3rd Berkeley Distribution March 14, 1996 MKERRLST(1)