Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mikawin
  • Content: Threads
  • Order by date
  1. mikawin

    Define Hash with $1 & $2

    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 =~...
  2. mikawin

    Splice Arrays

    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
  3. mikawin

    Find data in file corresponding to a search criteria

    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...
  4. mikawin

    One liner to check if variable matches any of an array's elements

    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
  5. mikawin

    Join Two Tables using Perl

    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...
  6. mikawin

    Splitting and using variables as inputs for a function

    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...
  7. mikawin

    Insert data from a file to a hash

    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
  8. mikawin

    replace characters of a string in specified position(s)

    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
  9. mikawin

    Oracle Express Edition Export Results

    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.
  10. mikawin

    compare two column values

    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...
  11. mikawin

    Join from Multiple Tables

    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...
  12. mikawin

    randomize length field for substr

    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...
  13. mikawin

    sort and print numbers

    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...

Part and Inventory Search

Back
Top