Search results for query: *

Thank you all for your input. I have solved all the problems with your advises Merci

Hello All I have the string below: Red Cross, CPR – life support, completed I have managed to put the string in an array separated by comma. My goal is to do three things: 1)use the default value in third element of the array, else use “completed” if ($array[0] eq ?)...

Somewhat embarrassed to ask this question: Could anyone tell me why the comment is not evaluating if (($array[5] eq "FULL TIME") && ($array[11] eq "BCGE2")){ $array[5] = "ARREARS"; $array[11] = "ARREARS"; print "The element 5th is now $array[5] \n" ; #This is not comming out at all. print "The...

Can any one advise of a place to download the following files: cpp-2.96-108.1.i386.rpm glibc-devel-2.2.4-26.i386.rpm kernel-headers-2.4.9-e.3.i386.rpm gcc-2.96-108.1.i386.rpm binutils-2.11.90.0.8-12.i386.rpm thank you.

I have got it, thanks a lot

Hi Dan, I have managed to get my control file working, however is it is only loading record #1: RWP20004100 SM000016721788446C05102A 1875345804015240800++000000000+ 71 This is perfectly all right. Actually I prefer it this way. All I wanna do now is to create a second and third...

Based on my last update, I have made some modifications. However, I am now getting the following error: SQL*Loader-291: Invalid bind variable LOADDATA in SQL string for column FILE_NUMBER.

I havwe modified my control my control file to be: LOAD DATA APPEND INTO TABLE ADP_EXTRACT_TEMP_100 ( FILE_NUMBER "substr(:loaddata.dat, 6,11 )", RECORD_CODE "substr(:loaddata.dat 12,14 )", DATA_CONTROL_1 "substr(:loaddata.dat, 56,56 )", DATA_CONTROL_2 "substr(:loaddata.dat, 57,57 )"...

Sorry, here is my sample control file. Please any help would be appreciated. Note any of the filed could be in any of the 3 existing lines for each employee. LOAD DATA APPEND INTO ADP_EXTRACT_TEMP_100 ( FILE_NUMBER "substr(:loaddata.dat 6,11)" RECORD_CODE "substr(:loaddata.dat 12,14)"...

Hello All, I have a file(loaddata.dat) with the following sample record below: Here are some facts about current line formart. -There are three lines, like below, for each employee. -each line for each employee always begins with (2 spaces) RWP20004. -each line for each emoployee always ends...

Hi Mikevh, Sorry for not informing you earlier. I was able to get this working early yesterday through my own effort. It seems to be giving out the correct output, and the Business Analyst seems to like the output. Trust me she is a toughie. Anyway, below is the code I ended up developing. Note...

Hello All, I have a file, inputfile, containing the following records: 200095,,,3/6/2003,OTHER^M,3.75,,,3.75 200095,,,5/2/2003,VACATION^M,3.75,,,3.75 200095,,,6/2/2003,VACATION^M,15,,,15 I was wondering if there is script that I could use to take out the carriage return ^M from each record...

Try to open by tailing or heading: from top of file use: head -200000 input file from bottom of file use: tail -200000 input file

Hello, In the foreach loop, the purpose is to make the following changes for each record in the array of input file. 1)check the values in 8th element of input file - from: 200765,,,3/21/1996,3/22/1996,,VACATION,VAC.TAKEN OTHER GRPS,,15,,,0 $array[7]is (VAC.TAKEN OTHER GRPS) 2) compare above...

Hi, Your idea actually works. Thanx Mikevh. However, following your advice to use the harsh, and in order to follow the existing organization standard, I was able to make the following effort while incorporating your idea. #!/usr/bin/perl use strict ; #use warnings ; use Date::Manip ; my...

Thanx, I was able to ommit the n and use the following: awk -F, -v c=8 '{print $c}' levln_ac_in.txt > levln_dt_in.txt It works

Hello All, I have a file (levln_ac_in.txt) with the following sample record format: 200159,,,3/21/1996,3/22/1996,,VACATION,VAC.TAKEN OTHER GRPS,,15,,,0 I am trying to extract the contents of the 8th column of each record of file levln_ac_in.txt and put it in an output file levln_dt_in.txt...

I have only done latter part creating a temp table. I was gonna use the script method too, just to provide a means to check my result from above. Thanx, Ans to gain the experience too.

DP1 080 000 RWP20004 SM000016721788446C05102A 21875345804015240800+0085834058300217700+000000000+ 71 RWP20004 00000014768200+S2 0050102009583405833652+0145834380408000+S2...

coulmn 3 is not actually price. It is a mnemonic value just like columns 3, 4 or 5. However, the value of column 5 is based on the value of column 3 and there are so many values in column 3 to put as: %myhash = ('MATLV' => 'MATERNITY LEAVE', 'VACLV' => 'VACATION LEAV', etc.) ; This is the...