Recent content by UCF87

I think I about got it, but I am getting NULL index numbers. DECLARE @COUNTCOL INT DECLARE @NEWTITLE VARCHAR(50) SELECT rptTitle, SUBSTRING(rptTitle, 1, @COUNTCOL)+ 'Detailed Statement of Income - Dept' FROM ReportRules WHERE (rptTitle LIKE N'%(0001)%') ORDER BY rptTitle SELECT @COUNTCOL

The table name is ReportRules The column names are rptTitle and rptRuleDescription rptTitle and rptDecription have the same information. (rptTitle is the actual title the user sees and rptDescription is for the administrator for a quick reference in the software) problem: Need to change part of...

1. I need to know where in the command I place the userid and password? Is there a way to get around it just for a file transfer? :-D 2. Can a specify on AIX the exact directory path where to place the file? What would be the syntax ftp -n -s:\CMAX\dls.prt 125.9.99.99 /Path? Thanks for you...

sed "s/^0/0/g" file > newfile This works... I was making this too complicated. Other zeros are moved but does not corrupt the file.

well shoot, I have tried every tr and sed sequence I can think of and still can not remove the space. Thanks for your help anyway.

What application uses trim? Forget to mention I am on AIX 5.1.

Need a way to remove the space before 0444 and 0068(bottom) without affecting other data in the file. I have about 730 numbers in this file that I need to remove the leading space. Thanks in advance. Sample data: dscoggi CAPVBRET 55 55 Transfer output file VENBAL to 2...

That is exactly what is happening. For some reason "something" is creating a -346 directory on our NFS mounted drive (NT Server). It is not being created in AIX because it will not allow you to create a dash in front of a directory name. We are unable to determine at this time how...

I found the problem, I had a -386 directory. Once I deleted it, it ran ok. Thank you for responding

Tried that already... same error.

I can run the script fine on 4.3 but it fails on 5.1 Error: cd: 0403-010 A specified flag is not valid for this command. Script: for DIRA in `ls` do if [ -d $DIRA ] then cd $DIRA <--- Line failure ls dis* > /dev/null 2>&1 if [ $? -eq 0 ] then pwd >...

I can run the script fine on 4.3 but it fails on 5.1 Error: cd: 0403-010 A specified flag is not valid for this command. Script: for DIRA in `ls` do if [ -d $DIRA ] then cd $DIRA <--- Line failure ls dis* > /dev/null 2>&1 if [ $? -eq 0 ] then pwd >...

Is it possible in an if statement, to determine if a variable contains a two or three digit number? Then I will need to add 2 or 1 preceeding zero(s) to that number respectively.

Thank you! That worked.

The ^ for begining of line still does not capture and print CCCC only. Maybe AWK does not work well with spaces? I want the output to show all occurrences of any lines without numbers.