10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
How to convert this:
F1-R1 F1-R2 F1-R3 into a flat file for bash?? Each record
F2-R1 F2-R2 F2-R3
F3-R1 F3-R2 F3-R3
F4-R1 F4-R2 F4-R3is on one line with all fields for that record, put into an output file. The output file should look like this when converted:
F1-R1,F2-R1,F3-R1,F4-R1... (6 Replies)
Discussion started by: bud1738
2. UNIX for Dummies Questions & Answers
Can anyone please help me with the below scenario.
I have a Flat file of the below format.
03|... (10 Replies)
Discussion started by: sp999
3. UNIX for Dummies Questions & Answers
ex: I have list of files in a folder.
i need to rename all files to get rid of the _ before .txt
result should look like this:
abc_def_geh_12345.txt... (2 Replies)
Discussion started by: lv99
4. Shell Programming and Scripting
I have a flat file with millions of records. .
Now I on this. (I prefer for AWK as its gives good performance.)
1 gopi ase ....
2 arun pl ...
3 jack sutha ..
4 peter pm ..
4 peter pm ..
... (12 Replies)
Discussion started by: Gopal_Engg
5. UNIX for Dummies Questions & Answers
I am in the process of learning how to do system administration (just on my own Linux machine) and have been working with the find command. One of the things I tried was
find / -nouser -o -nogroup
I redirected the output of my find query into a text file, and when I did a wc -l on it, it... (1 Reply)
Discussion started by: kermit
6. UNIX for Advanced & Expert Users
I came to a situation where I need to write flat files using shell scripts, I need to pull the records from the oracle database and create the flat file, This process should be automated.
Can any shell script expert out here to help me.. please..
Will be really glad to... (3 Replies)
Discussion started by: coolbuddy
7. Shell Programming and Scripting
i have a bad problem with multiple occurances of the same file in
different directories.. how this happened i am not sure! but I know
that i can use awk to scan multiple directory trees to find an
occurance of the same file... some of these files differ somwhat
but that does not matter! the... (4 Replies)
Discussion started by: moxxx68
8. UNIX for Dummies Questions & Answers
I have a good script to rename multiple files, but what's the best way I can remove some text from multiple filenames? Say I have a directory with 35 files with a .XLS at the end, how can I rename them to remove the .XLS but keep everything the same, without having to mv manually. Thanks. (6 Replies)
Discussion started by: nj78
9. Shell Programming and Scripting
I have a flat file like this
0001 THER ULT HEAD & NECK VES
0002 THER ULTRASOUND OF HEART
0003 THER ULT PERIPHERAL VES
0009 OTHER THERAPEUTIC ULTSND
0010 IMPLANT CHEMOTHERA AGENT
0011 INFUS DROTRECOGIN ALFA
0012 ADM INHAL NITRIC OXIDE
I need to conver this to a comma delimited flat file... (2 Replies)
Discussion started by: thumsup9
10. Shell Programming and Scripting
Hi, I have a flat text file which contains blank line between each text line. Is there any command to get rid of it?
Thanks for your help (11 Replies)
Discussion started by: xfang
grass-sqlite(1grass) Grass User's Manual grass-sqlite(1grass)
grass-sqlite - SQLite driver
SQLite driver SQLite driver in GRASS
Creating a SQLite database
GRASS is automatically creating the SQLite database if it is not yet existing when the first table is created in the SQLite database. It is
sufficient to define the connection (see next step).
Connecting GRASS to SQLite
The database name 'sqlite.db' is at user's choice. Also the file storage location can be freely chosen. If the database does not exist, it
will be automatically created when database content is created:
# example for storing DB in mapset directory (keep single quotes):
db.connect driver=sqlite database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db'
Supported SQL commands
All SQL commands supported by SQLite (for limitations, see SQLite help page: SQL As Understood By SQLite and Unsupported SQL).
Operators available in conditions
All SQL operators supported by SQLite.
Browsing table data in DB
A convenient SQLite front-end is sqlitebrowser. To open a DB file stored within the current mapset, the following way is suggested (corre-
sponds to above database connection):
# use double quotes:
db.connect, db.execute, db.select
SQL support in GRASS GIS
SQLite web site, SQLite manual, sqlite - Management Tools
Last changed: $Date: 2011-02-07 18:59:50 +0100 (Mon, 07 Feb 2011) $
GRASS 6.4.2 grass-sqlite(1grass)