If we go to post #1 in this thread and look at the XLATE KEY, XLATE TABLE, and COM fields in your sample input, it is immediately obvious that your fields are not fixed width (i.e., they do not appear at the same locations in each record).
Since your fields are not fixed width, since you have not defined what fields are present in general (as opposed to three record sample including blank lines that you say are not present in your real data), and since we have no idea what fields will be present or where they will be located in your real data; there is little we can do to help you solve your problem.
Hi Don,
The the xlate key, xlate table, com were not on the same position in 3 records but they repeat in the same position for every 3 records. The sample which i posted here is for demo data. I attached the sample data input file. Please let me know your thoughts after seeing this.
Hello all,
I am a unix dummy. I am trying to remove spaces between fields. I have the file in the following format
12332432, 2345 , asdfsdf ,100216 , 9999999
12332431, 2341 , asdfsd2 ,100213 , 9999999
&... (2 Replies)
I have a situation where I am reading a text file line-by-line. Those lines of data contain comma separated fields of data. However, each line can vary in the number of fields it can contain. What I need to do is parse apart each line and write each field of data found (left to right) into a file.... (7 Replies)
Hi,
I have a variable which has a list of string separated by comma.
for ex ,
Variable=/usr/bin,/usr/smrshbin,/tmp
How can i get the values between the commas separately using shell scripts.Please help me.
Thanks,
Padmini. (6 Replies)
Hi
pls help me to get the code:
i have a file in which content is :
2.01304E+11 2.01304E+11 ori 2 01:00
2.01304E+11 2.01304E+11 ori 2 01:02
2.01304E+11 2.01304E+11 ori 3 01:02
2.01304E+11 2.01304E+11 ori 3 ... (7 Replies)
Hi,
I have a large number of files which are written as csv (comma-separated values).
Does anyone know of simple sed/awk command do achieve this?
Thanks!
---------- Post updated at 10:59 AM ---------- Previous update was at 10:54 AM ----------
Guess I asked this too soon. Found the... (0 Replies)
hello experts,
i am retrieving values in variables jobKey and jobName within my shell script. these values are returned to me within braces and i am using following command to remove those braces:
jobKeys=`echo $jobKeys | sed 's:^.\(.*\).$:\1:'`
jobNames=`echo $jobNames | sed... (1 Reply)
Hi,
I have a list of tables in a file.txt
C_CLAIM
C_HLD
C_PROVIDER
I want the output to be
'C_CLAIM','C_HLD','C_PROVIDER'
Currently I'm usin awk and getting output which is almost correct but still has minor defects
awk -vORS="','" '{ print $1 }' file.txt
The output of... (4 Replies)
My OS : RHEL 6.7
I have a text file with comma separated values like below
$ cat testString.txt
'JOHN' , 'KEITH' , 'NEWMAN' , 'URSULA' , 'ARIANNA' , 'CHENG', . . . .
I want these values to appear like below
'JOHN' ,
'KEITH' ,
'NEWMAN' ,
'URSULA' ,
'ARIANNA' ,
'CHENG',
.... (4 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 PHP
px_get_info
PX_GET_INFO(3)PX_GET_INFO(3)px_get_info - Return lots of information about a paradox fileSYNOPSIS
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)