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)
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)
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)
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)
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)
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)
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)
Hello,
I was working with Machine learning and would like to apply my regression algorithms on binary classification datasets.
So I came across this adult dataset, LIBSVM Data: Classification (Binary Class)
It is a binary dataset, features have values only 1 and 0.
and I wanted to... (4 Replies)
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)
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
LEARN ABOUT DEBIAN
dbatbl
DBATBL(1) General Commands Manual DBATBL(1)NAME
dbatbl - Manage on-disk reference tables for DB-ALLe
SYNOPSIS
dbatbl [command] [options] [args...]
DESCRIPTION
This tool allows to index and query the tables that are needed for normal functioning of DB-ALLe.
dbatbl always requires a non-switch argument, that indicates what is the operation that should be performed:
help
Print a help summary.
help manpage
Print this manpage.
cat tableid [tableid [...]]
Output all the contents of a WMO B table..
grep string
Output all the contents of the local B table whose description contains the given string..
expand table-entry [table-entry [...]]
Describe a WMO B table entry or expand a WMO D table entry in its components..
expandcode varcode [varcode [...]]
Expand the value of a packed variable code.
index [options] filename index-id
Index the contents of a table file.
describe [options] what [values]
Invoke the formatter to describe the given values. Supported so far are: "level ltype l1 l2", "trange pind p1 p2".
OPTIONS
dbatbl follows the usual GNU command line syntax, with long options starting with two dashes (`-').
Option for command cat
-?, --help
print an help message
-c, --csv
output variables in CSV format
Option for command grep
-?, --help
print an help message
-c, --csv
output variables in CSV format
Option for command expand
-?, --help
print an help message
Option for command expandcode
-?, --help
print an help message
Option for command index
-?, --help
print an help message
-t type, --type=type
format of the table to index ('b', 'd', 'conv')
Option for command describe
-?, --help
print an help message
AUTHOR
dbatbl has been written by Enrico Zini <enrico@enricozini.com> for ARPA Emilia Romagna, Servizio Idrometeorologico.
may 16, 2012 DBATBL(1)