Search Results

I have attached the report sample for better understanding

:b:
Hi Folks,
I have a requirement to find the number of consecutive occurences based on month. Here is the below sample of my requirement.

I have say four columns

CARUSERNAME BRAND_CODE...

Thanks for your replies..
All the above command works. But I want to check for special characters at specific position. In the above sample input, if special character is present in first 5...

Hello Folks,
I am working on filtering a file having some special characters.
Let's say for an example a file contains person name and phone number based on positions. First 5 characters name and...

Folks,
Is there anyone to help on GPG file encryptions here.
I got a public key from third party. I imported the key in server.
I want to encrypt the public key. But without being signed , the key...

Hello Folks,
I am having a below example.


CAR_NAME SERVICE_DATE
------------------------------------
ALTIMA 01/01/2007
ALTIMA 03/01/2007
ALTIMA 05/02/2008
FORD GT ...

Hi Ahmed,
It works ...Thanks a lot...
I want to do this processing for millions of records. Hope it completes quickly...
Thanks for your timely help..

---------- Post updated at 11:35 PM...

Hello All,
I am having a below requirement.

File1 contains

KEY|VIN|SEQUENCE|COST

101 | XXX111 | 1 | 234.22
234 | XXX111 | 2 | 134.32
444 | ABC234 | 1 | 100.22
555 | DFF611 | 1 |...

Hi pravin27.. Thanks for reply..
I have tried with:
awk '{print "select columnname from table where id="$0}' inputfile
but it is simply printing following statements in output:
select columnname...

I need to read one txt file using awk script. The data in this file I need to use in where clause of select query.Then based upon the result of this select query need to perform some operation on...

Thanks for your replies..I have used the following code to find the exact match..


cat <filename> | cut -c <start position>-<end-position> | grep -n "required data"


From the above I will...

Hi ctsgnb,
Thanks for your reply. Can you please tell me what is the use of ^. I am new to UNIX. Also, if the emp ID does not start in the position 1 how do we need to modify the command. Please...

Dear Folks,
I am having a requirement to grep a word which could be a part of a substring of a file. Please help me with the command for korn shell.

Let me give you a example
I am having a file...

Dear Folks,
I want to calculate the elapsed hours between two time columns. I am using timestampdiff method for the same. I am able to get the value. But facing an issue of decimal values. For...

I am having a below requirement of formatting the data available in a file.

I am having 2 users details as below
Data is in order of Name,Vehicle Name,RepairDate

DINESHCAR20100901...

Hi Karthi,
Thanks for your reply
I do not have any pattern in my flat file. It is just a simple text. I want to replace the text say from position 20 to 30 with my text.
Also,my shell is unable...

Hi Folks,
I am here with a simple doubt. I am having a flat file in which I want to replace the characters from say 5 to 15 as some text.
Flat file contains a single line.

For example
...

chris..Thanks for your reply.grep -o is NOT recognized by my shell. I am using Korn Shell

Dear Folks,
I am a newbee to UNIX. I want to extract the SQLSTATE from a log file. For example the log file content is


SQL0010N The string constant beginning with "' from table1 a, table...

eval "file=\$$filename"


This is the absolute answer for my question. Thanks a lot..It is working:b:

Dear Folks,
I am facing an issue in getting a value of a variable.Let me explain the scenario.

I am having a list file say files.list in which I have mentioned
1 FILE1
2 FILE2

...

Dear Folks,
Is there anyone know how to do the group and ungroup cells feature of MS Excel through java.

Please help.

Please find the attachment.I want the code to do something like this.

Hi Tony,
Thanks for ur reply..I am not working with Perl..I need it in ksh only

Hello folks,,,
I am calling a Unix shell script from java. The unix script is transferring a file through FTP. I wonder how can I confirm whether the script has been executed properly without any...

Dear Folks,
Please suggest any Open source db2 tool for working with SQL queries