07-01-2005
Thanks for the reply
Multiple files can co-exist quite happily as they are imported and processed by SAGE individually.
Once they have been processed I need to rename or move them automatically.
Ideally SAGE would do this but they seem ti discouarage easy comms between other packages.
I suppose I could mount the dos drive and run a Cron to examine the directory for files modified today or within a different time-slot. The files would normally be exported onto Windows PC on the previous night say at 23:00 hours.
Richard
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am trying to manipulate a file that looks something like below:
! 7788 |778855 |SCOTT |
! 7782 |778223 |CLARK |
! 7902 |790245 |FORD |
! 7698 |7698455 |BLAKE |
! 7934 |79345767 |MILLER |
! 7844 |784 |TURNER |... (1 Reply)
Discussion started by: rkumar28
1 Replies
2. Shell Programming and Scripting
To all Guru
I have a file like
test.txt
111,122,212,123
data11,date12, data13, data14...data1n
data21,date22, data23, data24...data2n
data31,date32, data33, data34...data3n
...
...
..
datan1,daten2, datan3, datan4...datann
END
I have to load this data into oracle , where first... (1 Reply)
Discussion started by: u263066
1 Replies
3. UNIX for Advanced & Expert Users
i have a CSV file with 2 columns
Fund,Shares
1,100
2,150
3,190
The file is named as AccountNumber.txt(14888.txt,189879.txt...)
That files shows the funds in that account
I want to create a flat file with accountnumber as one more column since i need accountnumber also.The accoutnnumber... (1 Reply)
Discussion started by: kris01752
1 Replies
4. Shell Programming and Scripting
Legends,
Please help me to get the following
I have a file abc.txt with the following contents
12
13
14
15
And, i want to get the output to a variable like below
12,13,14,15 ....
How do i do this?
Regards,
san
Please use code tags when posting data and code samples! (5 Replies)
Discussion started by: sdosanjh
5 Replies
5. Shell Programming and Scripting
Hello,
I have a file of which six lines are given below:
<a="b" value="N"/>
<a="c" value="x1"/>
<a="b" value="N"/>
<a="c" value="x2"/>
<a="b" value="Y"/>
<a="c" value="x3"/>
I need one file with all the lines just below where value="N"... (4 Replies)
Discussion started by: shekhar2010us
4 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I am looking for an awk script which should help me to meet the following requirement:
File1 has records in following format
INF: FAILEd RECORD AB1234
INF: FAILEd RECORD PQ1145
INF: FAILEd RECORD AB3215
INF: FAILEd RECORD AB6114
............................ (2 Replies)
Discussion started by: mintu41
2 Replies
7. 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
8. Shell Programming and Scripting
Hi,
I am confused how to proceed firther please find the problem below:
Input Files:
DCIA_GEOG_DATA_OCEAN.TXT
DCIA_GEOG_DATA_MCRO.TXT
DCIA_GEOG_DATA_CVAS.TXT
DCIA_GEOG_DATA_MCR.TXT
Output File Name: MMA_RFC_GEOG_NAM_DIM_LOD.txt
Sample Record(DCIA_GEOG_DATA_OCEAN.TXT):(Layout same for... (4 Replies)
Discussion started by: Arun Mishra
4 Replies
9. Shell Programming and Scripting
Hi All!
Please I wonder if I can have some help using awk and sed to extract some information.
If I do ls -lrt in a directory, a list of files of months with their respective dates will appear, like files from january, February... etc, But if I want to list only files of 26th of June, I got... (7 Replies)
Discussion started by: fretagi
7 Replies
10. Shell Programming and Scripting
I am trying to cat on a file located on remote server and assign it to remote variable.
I have both local and remote variables. Running below script from local. test.sh
J_NAME=XXX2
J_IP=XXX
ssh $J_IP "ps auxw |grep java | grep -v grep |grep $J_NAME | awk '{print ... (2 Replies)
Discussion started by: oraclermanpt
2 Replies
LEARN ABOUT DEBIAN
portabase
PORTABASE(1) General Commands Manual PORTABASE(1)
NAME
portabase - an easy-to-use personal database application
SYNOPSIS
portabase [ -h | --help | <file> ]
portabase command [ -p password ] [ options ] <fromfile> <tofile>
DESCRIPTION
PortaBase (portable database) is a personal database application that is available for many platforms, including Linux, Mac OS X, Windows,
and Maemo.
PortaBase's features include:
- One data table per file
- String, Integer, Decimal, Boolean, Note (multi-line text), Date,
Time, Calculation, Sequence, Image, and Enum column types
- Add, edit, and delete rows of data
- Custom data views (subsets of the columns in any order)
- Filter the displayed rows using sets of conditions
- Sort the rows by any combination of columns, each in ascending or
descending order
- Optional page navigation buttons, with a custom number of rows per page
- Add, delete, rearrange, and rename columns at any time
- Specify default values for columns
- View summary statistics for columns (total, average, min, max, etc.)
- Import data from CSV, XML, and MobileDB files
- Export data to CSV and XML files
- Command-line format conversions (to and from XML, from MobileDB)
- Data file encryption
- Unicode support
- Pick any available font to use throughout the application
COMMANDS
PortaBase uses the following commands to indicate a command-line file conversion:
fromxml
Create a new PortaBase file from the input XML file.
frommobiledb
Create a new PortaBase file from the input MobileDB file.
fromcsv
Add rows to an existing PortaBase file from the input CSV file.
toxml Create a new XML file from the input PortaBase file.
tocsv Create a new CSV file from the input PortaBase file.
If an encrypted PortaBase file is to be read or created, the following option can be used immediately after the command:
-p <password>
Open or create the encrypted PortaBase file using the given password
The toxml and tocsv commands accept the following options:
-v <view>
Apply the named view before exporting.
-s <sorting>
Apply the named sorting before exporting.
-f <filter>
Apply the named filter before exporting.
The fromcsv command supports one option:
-e <encoding>
Specifies the text encoding of the imported CSV file; options are UTF-8 (the default) and Latin-1.
OPTIONS
PortaBase accepts the following options:
-h, --help
Display usage instructions.
FILES
$HOME/.qt/portabaserc - user-specific settings. Stores information on font, checkbox editing, delete confirmations, etc.
AUTHOR
This manual page was written by Jeremy Bowman <jmbowman@alum.mit.edu>, for the Debian GNU/Linux system (but may be used by others).
April 16, 2010 PORTABASE(1)