Search results for query: *

I have a file with 5 columns and want to use the data in the file to define a hash with key-value pair as shown below: key - c1, c2, c3 value - c1, c2, c3, c4, c5 my(%myHash); my ($c1, $c2, $c3, $c4, $c5); open(IN,"file1") while(my $current = <IN>) { $current =~...

Hello, I have a set of arrays: @Arr1 = (1..20); @Arr2 = (16..41); @Arr3 = (46..109); I want to splice the above into 1 array without duplicates of the format: @Combined = (1..41, 46..109) How can I do this? Thanks, Mika

Hello, I have a file with 3 columns. I want to get data corresponding to Col3 based on matching criteria in Col1. For example my searchInFile.txt contains: 100 P 24 200 Q 31 300 R 65 200 S 41 I need to extract Col3 corresponding to all values that match 200 in Col1. In Unix, I can do...

Hi, Is there a one-liner code that will check to see if a particular variable's value (for e.g $myVar = "S") matches any of the elements of a pre-defined array( @myArray = (P Q R S)? Thanks, Mika

Hello, I have two tables of 70*10^3 and 800*10^3 rows each. I want to get data corresponding to the columns 1, 2 and 3 of the first table from the second table. Sample Data: Table 1 1 PQRS STUV 2 ABCD EFGH 3 HIJK LMNOP Table 2 1 PQRS STUV 987 654 321 2 ABCD EFGH 1275 1375...

Hello, I have a column of data that is of the following format: 611,1,X;323,1,C;209,1,R;119,1,Y;86,1,P I am splitting a field based on ';' and on each of the split values calling on a function (an arbitrary example is the substring function.) Substring works on all of the values except the...

I have about 500,000 records in a file that I want to insert into a hash table. What is the most efficient way to do this? Thanks, Mika

I want to replace characters in specified positions for a series of strings. An arbitrary example: String Input: XXXyRRRtF8 Replace 4th & 8th characters 'y' and 't' with '1' & '2' respectively to give the output: XXX1RRR2F8 Thanks for your help! ~Mika

Hello, I am using the web based Oracle Express Edition. When I am trying to save the results of my query, it exports it as .csv. Is it possible to change this? The .csv format truncates to the results to 65,500 records and I have more than this in my result set. Thanks, Mika.

Hello, I have three columns with data (shown with space delimiter) that look like: Col1 Col2 Col3 -------------- x y y=6/x=7 a b a=9/b=4 p q p=6/q=8 r s s=6/r=4 I want to pick the high value for each row and have it output to the 4th column with information as to which Col has the high value...

Hello, I have a table with two columns in a table with data like: Col1 Col2 1 13172 1 13934 1 15030 1 15544 1 16007 1 16326 1 16357 1 17153 ... ... ... I want to expand this table with data from 4 other tables (t1-t4) which contain the above two columns + other attributes. My output should...

Hello, Is it possible to randomize the length field in the substr($string_variable, start number, length); I have multiple strings in a file that have 50-70 characters. I would like to randomly extract anything between 25 and 35 characters from the beginning for each of the strings...

I have a column in a table where the data looks like the following: d=115/a=25/c=3 b=132/c=3/d=87 d=73/c=3/b=17/a=3/e=14 b=167/a=114/c=3/d=3 d=140/c=54/b=12 d=87/c=44/b=3 b=93/e=19/a=83/d=5 d=125/a=8/c=123/b=7 c=116/b=5/d=31 b=125/d=34/d=3 d=151/a=68/c=12/b=5/e=19 For each of the rows, I want...