Hi all,
I have an accout number 12345ABC and the length of this account number can vary from 123ABC, 1234567ABC until 12 bytes length is the max.
I need to somehow trim the ABC part off of the account number. I was told that a decode statement might be able to do this but I am not familiar.
Any ideas how I can get rid of the alpha characters within this acct nbr.
Please remember that...
ndoggy020
Last Activity: May 6 '08, 01:45 PM
Joined: Sep 24 '06
Location:
-
I think my problem is that this field I am trying to order by is a varchar and not truly numeric. This could be the cause. -
It did not work. Please help.
Thanks for the try.Leave a comment:
-
OrderBy question
Hello.
I am trying to sort my results via the account number field.
I am sorting in descending order but the kicker is, the account numbers can contain letters as well. For example:
123456ABC1
What I am seeing in my results is this for example: (remember in DESC order)
123456ABC
1222
111234DEF
I dont undestand how that '1222' could be right there.... -
Unix Date Help
Hey guys.
I need to manipulate the system date to move forward a day. So, if the system date was 02/14/08, I need the 'new' date to be 02/15/08 so my script will look for the date of 02/15/08. The thing is the file I will be looking for always has the date of the next day. Any simple unix command solution?
Any ideas,
Thanks -
I acutally figured it out. Thanks for your help Jeff.Leave a comment:
-
UNIX and file size
Hey guys.
What I need to do is this:
I need write a script to find files that have a certain filesize (for this case a file size of 0 (zero) ) I see that the cksum command will help me find the filesize. I am new to the unix environment and not too sure how ot write a script that does the following:
When I find this file with a filesize of zero I need to echo a statement that tells the user to delete... -
Please help guys, assignment is due by tonight. :(Leave a comment:
-
Checkbox Help
Hello.
I am making a standard customer info form program for a class.
I want to my program to put a check in a checkbox when the state entered in the state textbox is "FL". My checkbox is called "chkboxTax" and my state textbox is called "txtState".
I need help on how to go about doing this.
Thank you very much
No activity results to display
Leave a comment: