Hi J
It is to be exluded because that is how it is defined in my spec. Unfortunately, I do not know enough about the system to determine what you are suggesting is true or not. I would be most grateful therefore if you can give a suggestion based on Ref 2, and all similar cases, being excluded.
Many thanks again.
grinder332518
Last Activity: Mar 2 '11, 10:43 AM
Joined: Jun 26 '09
Location:
-
Hi J
I do indeed only want the highest seqno for each ref where the date is not null. So ref 2 would be excluded entirely. Many thanks for your ongoing help.Leave a comment:
-
thanks J
This gives me one value for all the different sequence numbers.
If I have :-
ref seq date
1 1 1/1/11
1 2 1/3/11
1 3 1/5/11
2 1 2/1/11
2 2 null
3 1 2/10/11
3 2 2/11/11
then I would like the following as my output :-
1 3 1/5/11
3 2 2/11/11
Sorry if I wasn't...Leave a comment:
-
max command
My file has 2 fields : seqno and date
There can be lots of records for each seqno.
For each seqno, the date can be either set, or nulls.
How do I use the max function to return only the highest seqno which has a date set ?
ie ignoring those where the highest seqno is null ?
Thanks -
constructing a file to print
I have a text file, data.txt, which looks like :-
head1 head2 head3
data1 1 data 1 2 data 1 3
data 2 1 data 2 2 data 2 3
data 3 1 data 3 2 data 3 3
etc etc
I would like to print this file, using the lp –d command,
with a heading line, as follows :-
Report for whatever department as at {today’s date}
Then a... -
Informix : update syntax using a field name
I use Informix SQL.
I have 2 tables, each with a reference and a status.
I would like to update the table 1 status with the value of table 2's status, but do not know the syntax.
I have tried something like :-
but get t2 not declared.Code:update t1 set t1.status = t2.status where t1.reference in (select reference from t2)
Any assistance will be most gratefully received ! -
Is there an awk or sed to remove invalid rows ?
I have a file with rows with 10 columns, separated by 9 “|” (pipe) separators.
However, every now and again, I am getting spurious rows appearing with no separators at all, or other rows appearing with fewer than the 9 separators.
There is no way for me to prevent them from appearing from within the application,
So, my question is, is there an awk command, or, preferably, a sed command, which anyone... -
Thanks Ashitpro : your solution works great for me.Leave a comment:
-
Hi Ashitpro
My version of unix does not recognise your "lastlog" command.
Thanks anyway.
PS The command :
awk '$1==u || /^$/ {next} {print; u=$1}'
removes duplicates for me !Leave a comment:
-
"last" command returning duplicates
Hi
I am running a “last” command and saving the output to a file, which I am going to
ftp to my PC for loading into a DB table.
last > last.txt
I am finding that I am getting lots of duplicate entries for most logins in last.txt.
Eg
userabc pts/3 12.42.35.120 Mon Jun 14 09:17 - 09:19 (03:00)
userabc pts/3 12.42.35.120 Mon Jun 14 09:14... -
How to Identify files with sed command contained in text
Hi
My home directory contains lots of files with differing contents and extensions.
I wish to identify all those files containing a sed command in the text.
I thought I could use something like
,Code:find . –print | grep “ sed “
but this seems to look for files with “ sed “ in the filename, not in the contents.
Can anyone help ? -
thanks Mariostg
I actually came up with
sed -e :a -e '/\\$N; s/\\\n//; ta'
which is more or less what you are proposing.
Best RegardsLeave a comment:
-
How to use Sed to remove characters from file?
My pipe delimited file is coming over with spurious “\” characters inserted into some alpha fields,
which is causing the records to be split into 2.
Eg Abc|def|10/11\
AAAA|xyz
Lmn|opq|10/11BBBB|xyz
etc etc
I am having to go into vi, then enter /\ to locate each occurrence, enter x to delete the character,
then enter shift and J to join the two into one.
... -
sorry for the selay in getting back to you : all is well now : thanks a bundle to 'TheSmileyOne'Leave a comment:
-
ACCESS Forms : Redisplay fields after selection from a combi- dropdown
My Form accesses a Query to retrieve 3 fields from 2 tables :
SELECT tblA.X, tblB.Y, tblB.Z
FROM tblA LEFT JOIN tblB
ON tblA.X = tblB.X
There are lots of rows being retrieved.
My Form has X set up in a combi box.
I wish to select the downarrow for X to select any row,
and then for Y and Z to display the corresponding values.
Eg : if the 1st row... -
Access 2003 Forms : update field via [Event Procedure]
My Form accesses a Query as follows :
This gives me all the rows from tblA, with tblB columns B & C, when present,Code:SELECT tblA.A, tblB.B, tblB.C FROM tblA LEFT JOIN tblB ON tblA.A = tblB.A UNION SELECT tblB.A, tblB.B, tblB.C FROM tblB LEFT JOIN TblA ON tblB.A = TblA.A WHERE tblB.A not in (select TblA.A from TblA)
and also all the rows from tblB for those... -
Hyperlinks displaying hashes (#)
Hi Stewart.
I did find an alternative approach :
From the Form which accesses the Query :-
I went into Query View,
right clicked on each field, &
set 'Is Hyperlink' from the Format tab to 'Yes'.
The displays then ignore the hashes, & the links are displayed as intended.
Many thanks for your contribution.Leave a comment:
-
Hyperlinks displaying hashes (#)
I have a query which accesses a table with 2 fields which are hyperlinks.
There is no problem with the display.
But if I then enhance this query with a union, the hyperlinks show "#" symbols
at the beginning & end of each hyperlink in the query.
Where do they come from, and how do I remove them ?
Many thanks -
MS Access 2003
I have a rogue table which I cannot get rid of.
If I right click on it, and select Open or Design View or Delete or Rename,
I get “Microsoft Office Access has encountered a problem and needs to close”.
I could just ignore it, but I need to use the name of the table when exporting.
Are there any tricks that I can employ to remove it ? -
MS Access forms : spaces in table names & fields
Thanks RuralGuy
I ended up with this :
Private Sub Form_Current()
If Me.[1st Date Issued].Value < Date - 14 Then
MsgBox ("Date is before 14 days ago")
MsgBox ("Enter 2nd Letter Date NOW")
DoCmd.CancelEve nt
Me.Undo
Else
Exit Sub
...Leave a comment:
No activity results to display
Leave a comment: