07-01-2005
Remote File Manipulation
I am trying to improve teh process of exporting files to SAGE LINE 50.
I am producing a CSV file and dropping it onto a Windows M/c running XP.
When SAGE picks up the import file it processes successfuuly but the file can still be imported an infinite number of times with obvious results.
I need an effective method od automating the renaming of the file to prevent multiple updates say by checking access times and ideally after one update.
Any ideas appreciated.
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)