Search Results

Thank you Aigles, it is working perfectly.

I am trying to capture the file name(which is not of fixed length) and put it in a variable. It is working in unix whereas when I am running the same script in Informatica it is not giving me the...

Hi,
I have file with all not null cols. Assuming there are 5 fields each record and if any of them are null then should generate an error saying var1=300, if no. of fields are not equal to 5 then...

Thank you very much for your quick response.
As I said earlier also, that it is working if I check for -eq, but if I want to check for -ne or != it is not working. Please help me out !!

Hi,
I have a file whose first line has some name followed by the timestamp and the sequence number. The last 3 digits of that line is seq number. If I get seq num other than 001, 004, 007 then I...

Thank you very much !!

Hi,
I'll get a file whose first line comprises of system name, timestamp of file creation and the seq number. System name and seq num I need to other computation. My requirement is, I'll have to...

It is not checking for tab-delimited format. The following is the error I am getting, can you pl help?

Script:
#!/bin/ksh

awk -F\t 'NR>=3 { ## to start from 3rd line
!/\t/ {exit 101} ##...

Marvellous !!
Its working perfectly.

Thank you so much. I appreciate it.

Excellent !! its working fine now.
But there is one small problem, If there is an error in field one and also field two then I should have only error to be printed as "102". but not both "102" and...

Thank you for your quick response, I tried replacing as you said but still I am getting errors. The script is :
#!/bin/ksh

awk -F"<tab>" 'NR>=3 {
if ( $2 ~ /^ *$/ ) printf("102")
if ( $4 ~ /^...

I tried with the sample data but it is not giving the exact output:
The sample data is :
545689512<tab>20070424<tab>20070414<tab>456.25<tab>20061121<tab>pqr...

I am totally confused now.
Since I am a newbie and wrote the above script with the help of this forum.
I'll get a file which is tab delimited and from 3rd line onwards it has data. First field...

Hi,
I am trying to execute the following script but I am getting error:
My requirement is to check whether the data in the file is tab delimited and pass error as say "105" to var1 and desc as "not...

Thank you Reborg,
Excellent piece of work. Its working fine now.


Regards,
Balaji Manda

I am a newbie to Unix, I am using vi editor. I was able to print output to the screen using simple scripts. But when I tried a midlevel script I don't see anything on the screen and Cursor is just...

Thank you cfajohnson for your quick response, I'll confirm you what ASCII format means. For now I know that my script should check whether a file is in ASCII format or not. Regarding date format,...

Hi All,

Please help me out with a script which checks whether a given file say abc.txt is in ASCII format and data is tab-delimited. If the condition doesn't satisfy then it should generate error...

Hi reborg,

I am sorry as I was not clear enough.
"File size" means: calculate the size of the file in terms of bytes excluding first 2 lines, store that in a variable say $four and comparing it...

Hi devmiral,

File name is not of fixed length, it'll keep changing.

Hi All,

I'll get a file whose 2nd line contains 3 fields: filename(variable length), file size char(10), and record count int(10). How do I cut it and put it into 3 variables?

eg:...

Hi All,
I have a table with 10 columns. Some columns(2nd,4th,5th,7th,8th and 10th) are Not Null columns. I'll get a tab-delimited file and want to check col by col and generate seperate error code...