Recent content by HHG

Does anyone know what the following error means - sorry not used BO for a while and we have upgraded recently to xi. I keep getting the following error(fetching data error) and was wondering if anyone know what this means:- Query 1; universname; no data fetched. My query was working perfectly...

Hi all - thanks for your time and help. I have now managed to resolve it by using the command touch and find as below for anyone who wishes to find files that have been created on the current day :- touch -t `date +%y%m%d0000` testfile find . \( -name '*' \) -newer testfile -exec ls {} \;

Sam - this works grate. Can you help with the find statement. For some reason the find statement I had before is not picking up files created today. syntax I am using is:- find . -ctime 0 -print Now I am getting all of the files. Anyone have any ideas please. Thanks in advance.

Hi again, I'm a little stuck now on multiple attachment of files. I have done the following which works, but I need some bodytext. Any one suggest how I might include the body text please. (for file in {directory path/*; do uuencode ${file} $(basename ${file} ) done) | mailx -s "Subject of...

Thanks PHV I have used the find command with the -ctime option. All works find so far. Thanks again

Hi - Not started it yet as I am stuck on stuck on how to actually ready the files and check the date is current date. Any help would be grate. I can do the rest email etc.. Thanks

Hi All, Can anyone help with the following. In a directory I have the following:- -rw-rw-rw- 1 root other 17077 May 1 15:23 1790 -rw-rw-rw- 1 root other 31651 May 1 11:31 1789 -rw-rw-rw- 1 root other 17372 Apr 30 15:25 1788 -rw-rw-rw- 1 root other...

Thank you very much that worked a treat. I used PHV's concept and it worked a treat. Many thanks again to both Feherke and PHV for your kind help.

Hi thanks for this Feherke. I have put the following in a test script. awk -vORS ='{print l==$1?" ":"\n";l=$1}1;END{print""}' inputpc.txt > pcompmw.txt I am getting the following error. # ./test.sh awk: syntax error near line 1 awk: bailing out near line 1 Also, sorry didn't tell you I am...

Hi All, Can anyone help I am pain stakingly trying to go through a file and in vi trying to join to line together. But the file is rather large there must be an easier way to do this. e.g file :- 2226697 29/01/08 2226697 "630511" "0P0705011" 1.00 2226698 29/01/08 2226698 "630571"...

Does anyone use the universes provided by Orchard housing management systems. I am trying to obtain information by designing our own universe unfortunatly we do not have a data dictionary with table names and field names so its difficult to do. Their data dictionaries definitions are not...

Hiya, I have tried this but is only good if there is only one record within your input file (Cat 2). I have a file that will contain, several records. e.g $1 $2 $3 $4 123452,1256235635662,124562463,121313131 134486,6883864133767,454646454,787994947 also the -L removes...

Thanks Thomas I will give this a go. Cheers

Hi All, Does anyone know the best way to do the following if its at all possible using awk or sed. I have a file that contains 3 fields per transaction e.g. Field1,Field2,Field3 I want to recreate the file so that Field1 starts at potion 1 on the line, field2 starts at character position 42...

Thanks all. each time it find an empty file I will want to do a mv so I think I will need to do columb's way. There will be no sub directories but thanks its useful to know the find command way.