08-11-2011
Help required in parsing a csv file
Hi Members, I am stuck with the following problem. Request your kind help
I have an csv file which contains, 1 header record, data records and 1 footer record. Sample is as below
Contents of cm_update_file_101010.csv
--------------------------------------------------
cm_update_file_101010, 2
123,abc,aa@aa,123
234,edf,bb@bb,234
4
The first line, contains the filename and the number of data records, which in this case is 2. The footer, contains the total number of file records, in this case being 4 including header and footer
I want to write a code to check this. Like, total number of data records(2) +2 should be equal to footer (4) or
Footer (4) - (Number of data records mentioned in the header record (2) = Total number of data records
Can anyone please suggest how can I acheive this from a shell script
Many thanks in advance
Regards,
Ramakanth
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a CSV file which contains number series as one of the fields. Some of the records of the field look like :
079661/3
I have to convert the above series as
079661
079662
079663
and store it as 3 different records.
Looking for help on how to achieve this. Am a newbie at Shell... (10 Replies)
Discussion started by: mihirk
10 Replies
2. Shell Programming and Scripting
I am trying to parse a csv file in the below 'name-value pair' format and then use the values corresponding to the name.
Type:G,Instance:instance1,FunctionalID:funcid,Env:dev,AppName:appname... (6 Replies)
Discussion started by: chiru_h
6 Replies
3. Shell Programming and Scripting
I have a CSV file that needs to through two seperate processes (in the end there will be 2 files (Dload.unl and Tload.unl and we'll say the input file name is mass.csv). I have a processfile() function that will call the process Dload funtion. In Dload I want to read mass.csv into Dload and then... (1 Reply)
Discussion started by: dolo21taf
1 Replies
4. Shell Programming and Scripting
I have been trying to find a good solution for this seemingly simple task for 2 days, and I'm giving up and posting a thread. I hope someone can help me out!
I'm on HPUX, using sqlplus, mailx, awk, have some other tools available, but can't install stuff that isn't already in place (without a... (6 Replies)
Discussion started by: soldstatic
6 Replies
5. Shell Programming and Scripting
Hey guys,
I'm in the process of learning PHP and BASH scripting. I'm getting there, slowly ;)
I would like some help with parsing a CSV file. This file contains a list of hostnames, dates, and either Valid, Expired, or Expired Soon in the last column.
Basically, I want to parse the file,... (12 Replies)
Discussion started by: dzl
12 Replies
6. Shell Programming and Scripting
Yes, there is a great doc out there that discusses parsing csv files with sed, and this topic has been covered before but not enough to answer my question (unix.com forums).
I'm trying to parse a CSV file that has optional quotes like the following:
"Apple","Apples, are fun",3.60,4.4,"I... (3 Replies)
Discussion started by: analog999
3 Replies
7. Shell Programming and Scripting
Hello list,
I am working on a csv file which contains two fields per record which contain IP addresses. What I am trying to do is find records which have identical fields(IP addresses) which occur 4(four) times, and if they do, delete all records with that specific identical field(ip address).
... (4 Replies)
Discussion started by: landossa
4 Replies
8. Shell Programming and Scripting
Hi,
Newbie here and I need some help to parse a csv file that contains fields separated by ",". What I need to achieve here is, read the 1 line file and extract 240 fields and pass to a variable and then read the next 240 fields and pass to a variable, over and over. If anyone can assist that... (4 Replies)
Discussion started by: tmslixx
4 Replies
9. Shell Programming and Scripting
Hi,
I have basic knowledge on unix shell scripting(not an expert).
My requirement is reading the csv file using the schema defined in the configuration file and if the condition is not mached then move the unmatched record to a error file and matched good records into other file.
In brief: ... (43 Replies)
Discussion started by: shree11
43 Replies
10. Shell Programming and Scripting
Hello All,
I have an input CSV file like below, where first row data can be in different position after every run of the tool, i.e. pzTest in below example is in column 1, but it can be also in 3 column and same for all the headers in the first row.
pzTest, pzExtract, pxUpdate, pzInfo... (1 Reply)
Discussion started by: asirohi
1 Replies
LEARN ABOUT PHP
px_get_info
PX_GET_INFO(3) PX_GET_INFO(3)
px_get_info - Return lots of information about a paradox file
SYNOPSIS
array px_get_info (resource $pxdoc)
DESCRIPTION
PARAMETERS
o $pxdoc
- Resource identifier of the paradox database as returned by px_new(3).
RETURN VALUES
Returns an associated array with lots of information about a paradox file. This array is likely to be extended in the future.
o fileversion
-Version of file multiplied by 10, e.g. 70.
o tablename
-Name of table as stored in the file. If the database was created by pxlib, then this will be the name of the file without the
extension.
o numrecords
-Number of records in this table.
o numfields
-Number of fields in this table.
o headersize
-Number of bytes used for the header. This is usually 0x800.
o recordsize
-Number of bytes used for each record. This is the sum of all field sizes (available since version 1.4.2).
o maxtablesize
- This value multiplied by 0x400 is the size of a data block in bytes. The maximum number of records in a datablock is the integer
part of (maxtablesize * 0x400 - 8) / recordsize.
o numdatablocks
- The number of data blocks in the file. Each data block contains a certain number of records which depends on the record size and
the data block size (maxtablesize). Data blocks may not necessarily be completely filled.
o numindexfields
- Number of fields used for the primary index. The fields do always start with field number 1.
o codepage
- The DOS codepage which was used for encoding fields with character data. If the target encoding is not set with px_set_targeten-
coding(3) this will be the encoding for character fields when records are being accessed with px_get_record(3) or
px_retrieve_record(3).
SEE ALSO
px_numfields(3), px_numrecords(3).
PHP Documentation Group PX_GET_INFO(3)