Sponsored Content
Top Forums Shell Programming and Scripting how to parse this file and obtain a .csv or .xls Post 302509982 by Ant-one on Friday 1st of April 2011 09:21:33 AM
Old 04-01-2011
Hi,
I received the following error:

Quote:
awk: The string THRESHOLD cannot contain a newline character.
The source line is 2.
The error context is
;next} if(/HELP/){flg=0;print;next}if(/THRESHOLD / || /RESET /){gsub("THRESHOLD >>>
<<<
syntax error The source line is 3.
awk: The statement cannot be correctly parsed.
The source line is 3.
awk: There are 2 missing } characters.
awk: There is a missing ) character.
Thanks,
Ant-one

---------- Post updated at 08:21 AM ---------- Previous update was at 07:44 AM ----------

Hi,
first of all many thanks.
It worked fine for the major part, this is the ouput of your command:

Quote:
SYNTAX_VERSION 5,
,
,
,
MONITOR ,NAME_TEMPLATES
DESCRIPTION ,Monitors for contents of error
INTERVAL ,1m
MONPROG ,script.sh NAME_TEMPLATES
MAXTHRESHOLD,
GEN_BELOW_RESET,
SEVERITY Major,
APPLICATION ,script.sh
MSGGRP ,MSG
MSGCONDITIONS,
DESCRIPTION ,Has NEW errors
CONDITION_ID ,00000-34dc-25e0-1cfe-0a088b060000
CONDITION,
OBJECT ,<#>diff<*.folder>
THRESHOLD,0.500000
RESET,0.500000
SET,
OBJECT ,<$OPTION(area)>
TEXT ,There have been new failures Processing the <$OPTION(area)>
,
file on Central.,
AUTOACTION ,ls <folder>
HELPTEXT "OPS========= Please call support team" HELP "0d152f3c-59dc-71e0-1cfe-0a034b060000"
DESCRIPTION ,Has ANY errors
CONDITION_ID ,d26dda06-55f2-71e0-0025-0a034b060000
CONDITION,
OBJECT ,<*.folder>
THRESHOLD,0.500000
RESET,0.500000
SET,
OBJECT ,<$OPTION(area)>
TEXT ,There has been a failure Processing the <$OPTION(area)> file
,
HELPTEXT "OPS========= Please call out the support team" others instruction others instruction
Is it possible to split SEVERITY Major in 2 fields, please?

Quote:
SEVERITY Major,
The text shoul be in 2 part:

TEXT ,There have been new failures Processing the <$OPTION(area)> file on Central.

Instead:

Quote:
TEXT ,There have been new failures Processing the <$OPTION(area)>
,
file on Central.,
And the last part
Quote:

HELPTEXT "OPS========= Please call support team" HELP "0d152f3c-59dc-71e0-1cfe-0a034b060000"
Should be without the part HELP "0d152f3c-59dc-71e0-1cfe-0a034b060000" as follow:


Quote:
HELPTEXT "OPS========= Please call support team"
Thanks in advance for any suggestion.

Ant-one
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

copying the csv file into different worksheets of xls file

Hi, I have a script which will generate three csv files. i want to copy the contents of these csv files into a .XLS file but in different worksheets. Can a this be done in the same script? :confused: Can Perl come to my help in coping the csv files into different worksheets of .XLS file ?... (0 Replies)
Discussion started by: nimish
0 Replies

2. Shell Programming and Scripting

From xls to csv file

Can we convert an xls file into csv format in Unix Thanks Suresh (1 Reply)
Discussion started by: sureshg_sampat
1 Replies

3. UNIX for Advanced & Expert Users

obtain duplicate keys in csv file

Hi, having two csv files, both sorted, by key (column1), f1 containing duplicate keys and f2 containing no duplicate keys, how can I obtain all rows from f1 with the keys listed in file2? Example: f1 is: k1,gsj01fd k2,vi982cj k2,1fjk01e k3,81kjfds k4,sd9dasi f2 is: k2 k3 and I... (3 Replies)
Discussion started by: oscarmon
3 Replies

4. Shell Programming and Scripting

Convert a csv file to an xls format

Hi, I have a file coming in xxx.txt(csv format) i do some work on it and i need to send out as a .xls format. Is there any way there is some code i can use in my script to convert this? I'm struggling on this. Thanks (11 Replies)
Discussion started by: Pablo_beezo
11 Replies

5. UNIX for Dummies Questions & Answers

Unix script to convert .csv file to.xls format

I have a .csv file in Unix box i need a UNIX script to convert the.csv files to.xls format. Its very urgent please help me. (1 Reply)
Discussion started by: moon_friend
1 Replies

6. Shell Programming and Scripting

converting xls file to txt file and xls to csv

I need to convert an excel file into a text file and an excel file into a CSV file.. any code to do that is appreciated thanks (6 Replies)
Discussion started by: bandar007
6 Replies

7. UNIX for Advanced & Expert Users

Converting .csv file into .xls file and send it to inbox

Hi All, I wrote a script to extract data from Oracle DB and place it in a text file , and I have coverted .txt file into comma seperated .csv file and I sent it to my mail box . I can get .xls file in my inbox.I am getting all data in same column and in different rows , without column... (1 Reply)
Discussion started by: krthkmuthu
1 Replies

8. Shell Programming and Scripting

How to convert a xls file to csv?

Hi, My requirement is to convert the xls to csv file with utf-8 conversion. Is there any way please suggest me. Thanks, Raja (4 Replies)
Discussion started by: cnraja
4 Replies

9. Shell Programming and Scripting

Perl script to Convert XLSX or XLS files to CSV file

Hi All, I've got in a situation where I need to convert .xlsx or .xls formatted files into simple text file or .csv file. I've found many options but doing this using PERL script is the best way I believe.I'm in AIX box. Perl code should have 2 params while running. i.e perl... (1 Reply)
Discussion started by: manab86
1 Replies

10. Shell Programming and Scripting

Generate .csv/ xls file report

There can be thousand of .ksh in a specific directory where sql files are called from ksh. Requirement is to loop through all the files content and generate a report like below: Jobname Type type sqlname gemd1970 sql daily tran01 gemw1971 sql weekly ... (6 Replies)
Discussion started by: vedanta
6 Replies
Bio::Tools::Sigcleave(3pm)				User Contributed Perl Documentation				Bio::Tools::Sigcleave(3pm)

NAME
Bio::Tools::Sigcleave - Bioperl object for sigcleave analysis SYNOPSIS
Object Creation use Bio::Tools::Sigcleave (); # to keep the module backwar compatible, you can pass it a sequence string, but # there recommended say is to pass it a Seq object # this works $seq = "MVLLLILSVLLLKEDVRGSAQSSERRVVAHMPGDIIIGALFSVHHQPTVDKVHERKCGAVREQYGI"; $sig = Bio::Tools::Sigcleave->new(-seq => $seq, -type => 'protein', -threshold=>'3.5', ); # but you do: $seqobj = Bio::PrimarySeq->new(-seq => $seq); $sig = Bio::Tools::Sigcleave->new(-seq => $seqobj, -threshold=>'3.5', ); # now you can detect procaryotic signal sequences as well as eucaryotic $sig->matrix('eucaryotic'); # or 'procaryotic' Object Methods & Accessors # you can use this method to fine tune the threshod before printing out the results $sig->result_count: %raw_results = $sig->signals; $formatted_output = $sig->pretty_print; DESCRIPTION
"Sigcleave" was a program distributed as part of the free EGCG add-on to earlier versions of the GCG Sequence Analysis package. A new implementation of the algorithm is now part of EMBOSS package. From the EGCG documentation: SigCleave uses the von Heijne method to locate signal sequences, and to identify the cleavage site. The method is 95% accurate in resolving signal sequences from non-signal sequences with a cutoff score of 3.5, and 75-80% accurate in identifying the cleavage site. The program reports all hits above a minimum value. The EGCG Sigcleave program was written by Peter Rice (E-mail: pmr@sanger.ac.uk Post: Informatics Division, The Sanger Centre, Wellcome Trust Genome Campus, Hinxton, Cambs, CB10 1SA, UK). Since EGCG is no longer distributed for the latest versions of GCG, this code was developed to emulate the output of the original program as much as possible for those who lost access to sigcleave when upgrading to newer versions of GCG. There are 2 accessor methods for this object. "signals" will return a perl associative array containing the sigcleave scores keyed by amino acid position. "pretty_print" returns a formatted string similar to the output of the original sigcleave utility. In both cases, the "threshold" setting controls the score reporting level. If no value for threshold is passed in by the user, the code defaults to a reporting value of 3.5. In this implemntation the accessor will never return any score/position pair which does not meet the threshold limit. This is the slightly different from the behaviour of the 8.1 EGCG sigcleave program which will report the highest of the under-threshold results if nothing else is found. Example of pretty_print output: SIGCLEAVE of sigtest from: 1 to 146 Report scores over 3.5 Maximum score 4.9 at residue 131 Sequence: FVILAAMSIQGSA-NLQTQWKSTASLALET | (signal) | (mature peptide) 118 131 Other entries above 3.5 Maximum score 3.7 at residue 112 Sequence: CSRQLFGWLFCKV-HPGAIVFVILAAMSIQGSANLQTQWKSTASLALET | (signal) | (mature peptide) 99 112 FEEDBACK
When updating and maintaining a module, it helps to know that people are actually using it. Let us know if you find a bug, think this code is useful or have any improvements/features to suggest. Support Please direct usage questions or support issues to the mailing list: bioperl-l@bioperl.org rather than to the module maintainer directly. Many experienced and reponsive experts will be able look at the problem and quickly address it. Please include a thorough description of the problem with code and data examples if at all possible. Reporting Bugs Report bugs to the Bioperl bug tracking system to help us keep track the bugs and their resolution. Bug reports can be submitted via the web: https://redmine.open-bio.org/projects/bioperl/ AUTHOR
Chris Dagdigian, dag-at-sonsorol.org & others CONTRIBUTORS
Heikki Lehvaslaiho, heikki-at-bioperl-dot-org VERSION
Bio::Tools::Sigcleave, $Id$ COPYRIGHT
Copyright (c) 1999 Chris Dagdigian & others. All Rights Reserved. This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. REFERENCES
/ SEE ALSO von Heijne G.(1986) "A new method for predicting signal sequences cleavage sites." Nucleic Acids Res. 14, 4683-4690. von Heijne G.(1987) in "Sequence Analysis in Molecular Biology: Treasure Trove or Trivial Pursuit" (Acad. Press, (1987), 113-117). APPENDIX
The following documentation describes the various functions contained in this module. Some functions are for internal use and are not meant to be called by the user; they are preceded by an underscore ("_"). threshold Title : threshold Usage : $value = $self->threshold Purpose : Read/write method sigcleave score reporting threshold. Returns : float. Argument : new value, float Throws : on non-number argument Comments : defaults to 3.5 See Also : n/a matrix Title : matrix Usage : $value = $self->matrix('procaryotic') Purpose : Read/write method sigcleave matrix. Returns : float. Argument : new value: 'eucaryotic' or 'procaryotic' Throws : on non-number argument Comments : defaults to 3.5 See Also : n/a seq Title : seq Usage : $value = $self->seq($seq_object) Purpose : set the Seq object to be used Returns : Seq object Argument : protein sequence or Seq object See Also : n/a _Analyze Title : _Analyze Usage : N/A This is an internal method. Not meant to be called from outside : the package : Purpose : calculates sigcleave score and amino acid position for the : given protein sequence. The score reporting threshold can : be adjusted by passing in the "threshold" parameter during : object construction. If no threshold is passed in, the code : defaults to reporting any scores equal to or above 3.5 : Returns : nothing. results are added to the object Argument : none. Throws : nothing. Comments : nothing. See Also : n/a signals Title : signals Usage : %sigcleave_results = $sig->signals; : Purpose : Accessor method for sigcleave results : Returns : Associative array. The key value represents the amino acid position : and the value represents the score. Only scores that : are greater than or equal to the THRESHOLD value are reported. : Argument : none. Throws : none. Comments : none. See Also : THRESHOLD result_count Title : result_count Usage : $count = $sig->result_count; : Purpose : Accessor method for sigcleave results : Returns : Integer, number of results above the threshold : Argument : none. Throws : none. Comments : none. See Also : THRESHOLD pretty_print Title : pretty_print Usage : $output = $sig->pretty_print; : print $sig->pretty_print; : Purpose : Emulates the output of the EGCG Sigcleave : utility. : Returns : A formatted string. Argument : none. Throws : none. Comments : none. See Also : n/a perl v5.14.2 2012-03-02 Bio::Tools::Sigcleave(3pm)
All times are GMT -4. The time now is 04:47 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy