09-11-2015
Clarification of number of fields
Hi,
I missed the number of fields. It is 123. So 123 features i.e. there are 123 binary values, and then a class variable which could be +1 or -1.
And each line contains only 0 or 1 or the class variable (which is + 1 or -1) and that class variable appears only once at the beginning of each line.
Hope that clarifies all the doubts.
And yes I want a CSV i.e. values separated with commas.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hello All,
I have a sql report with 50 columns and 1000 rows result in a file ( txt / csv). is there is any way that we can move them to excel in KSH.
Thanks,
Sateesh (7 Replies)
Discussion started by: kotasateesh
7 Replies
2. Programming
hi all,
i have a select query that gives me the output in the following way...
SYSTYPE
--------------------------------------------------------------------------------
Success Failures Total RFT
---------- ---------- ---------- ----------
TYP
1 0 ... (3 Replies)
Discussion started by: sais
3 Replies
3. Programming
hi...... thanks for allowing me to start a discussion
i am collecting usb usage details of all users and convert it into csv files so that i can export it into some database..
the input text file is as follows:-
USB History Dump
by nabiy (c)2008
(1) --- Kingston DataTraveler 130 USB... (2 Replies)
Discussion started by: certteam
2 Replies
4. Shell Programming and Scripting
Please suggest ways to easily convert pdf to text in perl only on windows (no other tools can be downloaded)
Here is what I have been doing :
using a module CAM::PDF to extract data. But it shows everything in messy format :wall:
But this module is the only one working with the pdf... (0 Replies)
Discussion started by: chakrapani
0 Replies
5. Shell Programming and Scripting
Hi Gurus
I need urgent help to convert a flat log file into csv format to load into database.
Log looks like:
a=1
b=2
c=3
a=4
b=5
c=6
Only the values at right side of = will come into csv and it should create a new line once it receives "a" field. (8 Replies)
Discussion started by: sandipjee
8 Replies
6. Shell Programming and Scripting
Hi ,
I have a simple text file with contents as below:
12345678900 971,76 4234560890
22345678900 5971,72 5234560990
32345678900 71,12 6234560190
the new csv-file should be like:
Column1;Column2;Column3;Column4;Column5
123456;78900;971,76;423456;0890... (9 Replies)
Discussion started by: FreddyDaKing
9 Replies
7. Shell Programming and Scripting
I want to extract IP address, system ID and engine IDs of this file ( marked in red) and put in a csv. E.g.
1.1.1.1, SYSTEMID, 000012345678981123548912
I get these file by running an expect script from solaris.
Here is the text file output of my expect script.
working on 1.1.1.1
SNMP... (5 Replies)
Discussion started by: pbshillong
5 Replies
8. Shell Programming and Scripting
Hi all,
I need to find a way to convert excel file into csv or a text file in linux command. The reason is I have hundreds of files to convert. Another complication is the I need to delete the first 5 lines of the excel file before conversion.
so for instance
input.xls
description of... (6 Replies)
Discussion started by: johnkim0806
6 Replies
9. Shell Programming and Scripting
I have input data looks like this which is a part of a csv file
7,1265,76548,"0102:04"
8,1266,76545,"0112:04"
I need to make the output data should look like this and the output data will be part of text file:
7|1265000 |7654899 |A|
8|12660000 |76545999 |B|
The logic behind the... (6 Replies)
Discussion started by: RJG
6 Replies
10. Shell Programming and Scripting
Hi,
Is there somebody there to post an idea on how to convert this 5 liner row to 1 liner or tab delimiter to be import to database.
Here the text file format:
Description: Description1
Link: https://www.google.com
Date: June 2, 2018
Time: 00:07:44
Age: 1 days ago
Description:... (2 Replies)
Discussion started by: lxdorney
2 Replies
FPUTCSV(3) 1 FPUTCSV(3)
fputcsv - Format line as CSV and write to file pointer
SYNOPSIS
int fputcsv (resource $handle, array $fields, [string $delimiter = ","], [string $enclosure = '"'], [string $escape_char = "
DESCRIPTION
fputcsv(3) formats a line (passed as a $fields array) as CSV and write it (terminated by a newline) to the specified file $handle.
PARAMETERS
o $handle
-The file pointer must be valid, and must point to a file successfully opened by fopen(3) or fsockopen(3) (and not yet closed by
fclose(3)).
o $fields
- An array of values.
o $delimiter
- The optional $delimiter parameter sets the field delimiter (one character only).
o $enclosure
- The optional $enclosure parameter sets the field enclosure (one character only).
o $escape_char
- The optional $escape_char parameter sets the escape character (one character only).
RETURN VALUES
Returns the length of the written string or FALSE on failure.
CHANGELOG
+--------+---------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------+
| 5.5.4 | |
| | |
| | The $escape_char parameter was added |
| | |
+--------+---------------------------------------+
EXAMPLES
Example #1
fputcsv(3) example
<?php
$list = array (
array('aaa', 'bbb', 'ccc', 'dddd'),
array('123', '456', '789'),
array('"aaa"', '"bbb"')
);
$fp = fopen('file.csv', 'w');
foreach ($list as $fields) {
fputcsv($fp, $fields);
}
fclose($fp);
?>
The above example will write the following to file.csv:
aaa,bbb,ccc,dddd
123,456,789
"""aaa""","""bbb"""
NOTES
Note
If PHP is not properly recognizing the line endings when reading files either on or created by a Macintosh computer, enabling the
auto_detect_line_endings run-time configuration option may help resolve the problem.
SEE ALSO
fgetcsv(3).
PHP Documentation Group FPUTCSV(3)