Posts
 
Reputation
Joined
Last Seen
Ranked #541
Strength to Increase Rep
+6
Strength to Decrease Rep
-1
100% Quality Score
Upvotes Received
22
Posts with Upvotes
21
Upvoting Members
7
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
12 Commented Posts
~19.5K People Reached
Favorite Forums
Favorite Tags
Member Avatar for k_manimuthu

SAMPLE TABLE 1 =================================== product Division sales % =================================== product1 divsion1 99 product2 divsion1 51 product3 divsion1 50 product4 divsion2 98 product5 divsion2 41 product6 divsion2 40 product7 divsion3 97 product8 divsion3 31 product9 divsion3 30 =================================== Expected output 1 =================================== product2 divsion1 51 product3 divsion1 50 product5 divsion2 41 …

Member Avatar for diafol
0
550
Member Avatar for k_manimuthu

Hi All, I have a sql query i am trying to get the count of how rows it returned. select a.field1, b.field2, c.field2 from table1 as a, table2 as b, table2 as c where a.field1=b.field1 Considered the above query return 9 rows. I want to get count of '9' in …

Member Avatar for k_manimuthu
0
286
Member Avatar for k_manimuthu

Hi, I am trying to get same field name from different tables. And i am using like the below query to get the field name. I am expecting some other queries to get distinct 'function_name' column from 'N' of tables. SELECT function_name FROM base_table UNION SELECT function_name FROM firstcall_table UNION …

Member Avatar for diafol
0
244
Member Avatar for k_manimuthu

Hi All, I am trying to write perl code for extract 'C' user defined function from 'diff' format file. I am using the below keyword to identify the function 'starting pharse' (return value). I am not familar about 'C'. Please suggest some addtion return type which missing from the below …

Member Avatar for rubberman
0
305
Member Avatar for k_manimuthu

Hi all, I am not able to get correct count, if col1 (percentage with respect to product) and col2 have uniq value. Below I post my sample table data and expect output and which i query I tried. Please help me to get in to right direction. CREATE TABLE mysample …

Member Avatar for k_manimuthu
0
231
Member Avatar for k_manimuthu

Hi all, Below is my sample data. I am trying to get the 'product' name only if the percentage count is varying. Could you please suggest your maximum no of 'Mysql' queries to approach this. Thanks in advance. Input: ============================================== percentage product ============================================== 100.00 A 100.00 A 100.00 A 2.18 …

Member Avatar for k_manimuthu
0
293
Member Avatar for k_manimuthu

Hi All, I want to copy the missing 'data' field from 'tb1' to 'tb2' based on the 'id' value. Please suggest the possible queries. mysql> select * from tb1; +------+------+ | id | data | +------+------+ | 1 | A | | 2 | B | | 3 | C …

Member Avatar for k_manimuthu
0
311
Member Avatar for axn

How do i match "00:04" and "4+21:08" which is ("days+hrs:mins" and "hrs:mins") in a file. I would like to combine regex patterns so I can calculate running time. This is what i got for regex but does not match "00:04" --> (\d\d)(\:)(\d\d) [CODE]if($string = ~ m/(\d)(\+)(\d\d)(\:)(\d\d)/) { #code goes here …

Member Avatar for axn
0
154
Member Avatar for damorph

I am a complete beginner to PERL. I am using Strawberry PERL. I am coming across text files that I need to format. I basically need to take field data that starts with a certain character and output the field data to a new file which will have all the …

Member Avatar for d5e5
0
231
Member Avatar for anunitha

Hi, I have excel sheet which contain 100 and 100 of email and corresponding name. I need to seprate them according to the number of occurrence of their name. eg: name email chandran [email]chan@gmail.com[/email] maidhu maidu2yahho.com karan [email]karniii@nii.in[/email] Chandran [email]chan@gmail.com[/email] Chandran [email]chan@gmail.com[/email] karan [email]karniii@gmail.com[/email] excell sheet contain name and email, …

Member Avatar for anunitha
0
89
Member Avatar for boshu

Dear all, I need to copy a set of files every once in a while from my build env to a shared drive. The set of files are same, names may vary but they come with same extension. So far I am doing it manually. I wish it could be …

Member Avatar for d5e5
0
373
Member Avatar for biojet

Hi, I made the perl script and I print out with Txt file. For EX : [CODE]Open (OUTPUT,">data.txt"));[/CODE] out put [CODE]data.txt[/CODE] But I hope at the day that I run the script, the day will be labeled with the name file. Like the name below: [CODE]20110919data.txt[/CODE] Could you please show …

Member Avatar for biojet
0
131
Member Avatar for biojet

Hi, I have the data file. txt (3.96 MB) and I want to make each 50 Character on the one line. For EX: In put data : [CODE]GTGAGCCAGAACTCATCTTCTTTGCTCGAAACCTGGCGCCAAGTTGTTGCCGATCTC........ [/CODE] [CODE] out put with 50 character on one line: GTGAGCCAGAACTCATCTTCTTTGCTCGAAACCTGGCGCCAAGTTGTTGCC TGAGCCAGAACTCATCTTCTTTGCTCGAAACCTGGCGCCAAGTTGTTGCCG GAGCCAGAACTCATCTTCTTTGCTCGAAACCTGGCGCCAAGTTGTTGCCGA AGCCAGAACTCATCTTCTTTGCTCGAAACCTGGCGCCAAGTTGTTGCCGAT GCCAGAACTCATCTTCTTTGCTCGAAACCTGGCGCCAAGTTGTTGCCGATC CCAGAACTCATCTTCTTTGCTCGAAACCTGGCGCCAAGTTGTTGCCGATCT CAGAACTCATCTTCTTTGCTCGAAACCTGGCGCCAAGTTGTTGCCGATCTC [/CODE] Below is my script …

Member Avatar for d5e5
0
201
Member Avatar for blacknred

I got a file: [CODE]I wake up in the morning What time? Always wakeup at 6am.[/CODE] what would be an easy way to determine the number of white spaces between each word? Thanks in advance David

Member Avatar for k_manimuthu
0
274
Member Avatar for perlnoob

Please Help me to extract the inner table to the outer table so that it will not have table within table because it is not good data.. thank you Raw Data [CODE]<item> <pre> <table width="100%" border="0" cellpadding="2" cellspacing="2" bgcolor="#eeeeee"> <tr> <td><p>"Gratitude for the abundance you have received is the best …

Member Avatar for k_manimuthu
0
136
Member Avatar for bilal.farooq

What is map doing below? [CODE] my @aFN = (); #------------------------------------------------------------------------------- # get the nodes #------------------------------------------------------------------------------- if (-e $fConfFN) { open CONF,$fConfFN; while(<CONF>) { chomp; if( /.*=(.*)/ ) { my @A = split /\s+/, $1; [COLOR="Red"][B]map{push(@aFN,$_)}@A;[/B][/COLOR] } } close CONF; [/CODE]

Member Avatar for bilal.farooq
0
77
Member Avatar for senthilamp4

Hi Experts, Here i am trying to create a script for Auto Back up script to Back up files. files are taking a back up with help of archive zip module along with mentioned the date in corresponding Folder name. Here i am create one xml file for daily updation. …

Member Avatar for k_manimuthu
0
231
Member Avatar for boshu

Hi all, Once again I am here with a simple problem which is hard enough to solve by myself: I got the following keys in an array: [CODE] 20110225104849 20110225104833 20110225104848 [/CODE] And following files in a folder: [CODE] google_20110225091600.7z google_20110225091622.7z google_20110225100306.7z google_20110225100410.7z google_20110225104833.7z google_ready_20110225100410.txt google_ready_20110225104833.txt Yahoo_20110225091639.7z Yahoo_20110225100320.7z Yahoo_20110225100424.7z Yahoo_20110225104849.7z …

Member Avatar for boshu
0
168
Member Avatar for boshu

Hi all, Once again I would like to seek your help. I got one file (test.hrh) with a number of flags. Some falgs are defined (#define), some not (#undef). I got another file which a flag list which should be added to the file if not there, and if exists …

Member Avatar for k_manimuthu
0
991
Member Avatar for senthilamp4

Hello Friends, i am new bee of Perl developemnt., can you pls give regular expression for this number., input: (232,45,3434,535.56) like wise (\()([0-9.,]+)(\)) output: -232,45,3434,535.56 Thanks Advance.., Senthil. V

Member Avatar for senthilamp4
0
96
Member Avatar for k_manimuthu

I derived Datatable in one class(DataTableEx), then i created one property(TotalRecordCount), then i assigned 5000 to that new property(TotalRecordCount), then i convert this datatable into xml, so it's created.Now i try to convert xml to Datatable, i am not able to get 5000 value to TotalRecordCount Property. so how i …

0
91
Member Avatar for rgpii

Hi, I have been reading "Learning Perl the Hard Way" and I was trying to complete one of the exercises which involved the use of regular expressions. I could get all of the anchors working except for "$". I have my code below with errors. I was just curious if …

Member Avatar for deepakkrish
0
515
Member Avatar for boshu

Hi all, I am using a script which takes various command line options, does some zipping activities and publish a log file of what is has zipped. arguments: [CODE]zip_contents.pl -u content_name -s c:\contetn_path -u content_flag -m content.sender@mail[/CODE] When the log file is created I want that the given command line …

Member Avatar for boshu
0
230
Member Avatar for singhabsk

Hi I am ABHI i want to substitute `19-13-10-456765` to `19*10 + 13*5 + 10` is equal to `(265)` in file i want to know the exact code to do that this is the file content xyz.txt 19-10-13-400922 TID1-3039 1RequestREGISTER 19-10-13-405432 TID1-3039 1Response100 19-10-13-410015 TID1-3039 1Response401 19-10-13-415481 TID1-3039 2RequestREGISTER 19-10-13-419800 …

Member Avatar for k_manimuthu
0
106
Member Avatar for boshu

I got an array of email addresses: [CODE]@emails = ("sam\@email.com", "john\@email.com", "jenifer\@email.com");[/CODE] There are 20 txt files wherefrom email addresses are being parsed. The parsed email addresses should be added to the @emails array only if they are not in it. Example txt file contents: =========================== Zip_Name: [email]jenni@email.com[/email] Zip_Name: [email]sam@email.com[/email] …

Member Avatar for boshu
0
170
Member Avatar for boshu

Hi all, I am in fruit industry and dealing with stock inventory of fruits. I got 2 files, one file got fruit names (fruit.txt) and other file got the inventory status (status.txt). Task for me was to check the fruit list and update the inventory status: Contents of the files: …

Member Avatar for boshu
0
389
Member Avatar for gutchi

Hi everyone! Is there a function in Perl which is similar to the following [CODE]getServletContext().getRealPath("/filepathInContext")[/CODE] which is in Java? The getRealPath method returns a String containing the real path for a given virtual path . I can't seem to find one. Any help would be much appreciated. TIA.

Member Avatar for k_manimuthu
0
218
Member Avatar for realoneomer

Hi Perl guru's My name is Omer and i am almost new on perl i need help for below mentioned issue. Well, I have two files file A & file B file A have two columns and it looks like ColumnA ColumnB A 01 B 02 C 03 and File …

Member Avatar for realoneomer
0
1K
Member Avatar for boshu

Hi I am a PERL novice. Currently dealing with a problem and wondering whether it can be solved using PERL? I got a folder containing a number of text files. Every time a file is created a timestamp is added at the end followed by an "_". for example "apple_20101210091255.txt". …

Member Avatar for k_manimuthu
0
202
Member Avatar for fredfletcher

Hello, I was wondering if anyone could help me with something. I am not a programmer yet I am able to modify scripts to a certain extent. I recently downloaded a script to read an existing CSV file and output via an SSI call. What I would like to do …

Member Avatar for fredfletcher
0
176