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
utimes(2) System Calls Manual utimes(2)
NAME
utimes - set file access and modification times
SYNOPSIS
DESCRIPTION
The function sets the access and modification times of the file pointed to by the path argument to the value of the times argument. The
function allows time specifications accurate to the microsecond.
For the times argument is an array of structures. The first array member represents the date and time of last access, and the second mem-
ber represents the date and time of last modification. The times in the structure are measured in seconds and microseconds since the
Epoch, although rounding toward the nearest second may occur.
If the times argument is a null pointer, the access and modification times of the file are set to the current time. The effective user ID
of the process must be the same as the owner of the file, or must have write access to the file or appropriate privileges to use this call
in this manner. Upon completion, will mark the time of the last file status change, st_ctime, for update.
RETURN VALUE
Upon successful completion, 0 is returned. Otherwise, -1 is returned and is set to indicate the error, and the file times will not be
affected.
ERRORS
The utimes() function will fail if:
Search permission is denied by a component of the
path prefix; or the times argument is a null pointer and the effective user ID of the process does not match
the owner of the file and write access is denied.
Too many symbolic links were encountered in resolving path.
The length of the path argument exceeds or a pathname component is longer than
A component of path does not name an existing file or path is an empty string.
A component of the path prefix is not a directory.
The times argument is not a null pointer and the calling process' effective user ID has write access to the file
but does not match the owner of the file and the calling process does not have the appropriate privileges.
The file system containing the file is read-only.
The function may fail if:
Pathname resolution of a symbolic link produced an intermediate result
whose length exceeds
SEE ALSO
<sys/time.h>.
CHANGE HISTORY
First released in Issue 4, Version 2.
utimes(2)