12-24-2015
Any possibility that out of that latest sample log, you could manually, create an example of the output you would like to show and how it would have to be formatted?
Just looking at your lines of code, it is not clear what you want, since it is no even doing what you wish, at this moment. And your request specification is no help clarifying.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All ,
I am trying to build a script using awk that checks columns of the înput file and displays message if the column length exceeds 35 char.
i have tried the below code but it does not work properly (2 Replies)
Discussion started by: amit1_x
2 Replies
2. Shell Programming and Scripting
Hi guys,
I have tried to find a solution for this problem but couln't. If anyone of you have an Idea do help me.
INPUT_FILE
with three columns shown to be separated by - sign
A5BNK723NVI - 1 - 294
A7QZM0VIT - 251 - 537
A7NU3411V - 245 - 527
I want an output file in which First column... (2 Replies)
Discussion started by: smriti_shridhar
2 Replies
3. Shell Programming and Scripting
For example, if I have the file whose content are:
>HWI-EAS382_30FC7AAXX:7:1:927:1368
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
>HWI-EAS382_30FC7AAXX:7:1:924:1373
ACGAACTTTAAAGCACCTCTTGGCTCGTATGCCGTC
I want my output calculate the total length of nucleotide. So my output should look like this:... (1 Reply)
Discussion started by: patrick chia
1 Replies
4. Shell Programming and Scripting
Hi Friends,
I have .txt file which has 13000 records.
Each record is 278 character long.
I am using below code to extract the string and it takes almost 10 minutes.
Any suggestion please.
cat filename.txt|while read line
do
f1=`echo $line|awk '{print substr($1,1,9)}'`
f2=`echo... (6 Replies)
Discussion started by: ppat7046
6 Replies
5. Shell Programming and Scripting
All,
I can't seem to find exactly what I'm looking for, and haven't had any luck patching things together.
I need to look through a file, and if the record length is not 874, then add 'E' in position 778.
Your help is greatly appreciated. (4 Replies)
Discussion started by: CutNPaste
4 Replies
6. Shell Programming and Scripting
Hi ,
I need to extract data from below mentioned data, having no delimiter and havin no fixed column length.
For example:
Member nbr Ref no date
10000 1000 10202012
200000 2000 11202012
Output:
to update DB with memeber nbr on basis of ref no.
... (6 Replies)
Discussion started by: ns64110
6 Replies
7. Shell Programming and Scripting
How to find total number of special character in a column?
I am using awk -f "," '$col_number "*$" {print $col_number}' file.csv|wc -l but its not giving correct output. It's giving output as 1 even though i give no special character?
Please use code tags next time for your code and... (4 Replies)
Discussion started by: AjitKumar
4 Replies
8. Shell Programming and Scripting
Hi,
I need help with one problem, I came across recently.
I have one input file which I need to delimit based on character length.
$ cat Input.txt
12345sda231453
asd760kjol62569
sdasw4g76gdf57
And, There is one comma separated file which mentions "start of the field" and "length... (6 Replies)
Discussion started by: Prathmesh
6 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I've got a file like this:
22 22:35645163:T:<CN0>:0 0 35645163 T <CN0>
22 rs140738445:20902439:TTTTTTTG:T 0 20902439 T TTTTTTTG
22 rs149602065:40537763:TTTTTTG:T 0 40537763 T TTTTTTG
22 rs71670155:50538408:TTTTTTG:T 0 50538408 T TTTTTTG... (3 Replies)
Discussion started by: zajtat
3 Replies
10. Shell Programming and Scripting
Good day, I am a newbie here and thanks for accepting me
I have a task to modify input data where my input data looks like
123|34567|CHINE
1|23|INDIA
34512|21|USA
104|901|INDIASee that my input has two columns with different character length but max length is 5 and minimum length is 0 which... (1 Reply)
Discussion started by: fastlearner
1 Replies
LEARN ABOUT PHP
cubrid_column_names
CUBRID_COLUMN_NAMES(3) 1 CUBRID_COLUMN_NAMES(3)
cubrid_column_names - Get the column names in result
SYNOPSIS
array cubrid_column_names (resource $req_identifier)
DESCRIPTION
The cubrid_column_names(3) function is used to get the column names of the query result by using $req_identifier.
PARAMETERS
o $req_identifier
-Request identifier.
RETURN VALUES
Array of string values containing the column names, when process is successful.
FALSE, when process is unsuccessful.
EXAMPLES
Example #1
cubrid_column_names(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb", "dba");
$result = cubrid_execute($conn, "SELECT * FROM game WHERE host_year=2004 AND nation_code='AUS' AND medal='G'");
$column_names = cubrid_column_names($result);
$column_types = cubrid_column_types($result);
printf("%-30s %-30s %-15s
", "Column Names", "Column Types", "Column Maxlen");
for($i = 0, $size = count($column_names); $i < $size; $i++) {
$column_len = cubrid_field_len($result, $i);
printf("%-30s %-30s %-15s
", $column_names[$i], $column_types[$i], $column_len);
}
cubrid_disconnect($conn);
?>
The above example will output:
Column Names Column Types Column Maxlen
host_year integer 11
event_code integer 11
athlete_code integer 11
stadium_code integer 11
nation_code char 3
medal char 1
game_date date 10
SEE ALSO
cubrid_prepare(3), cubrid_execute(3), cubrid_column_types(3).
PHP Documentation Group CUBRID_COLUMN_NAMES(3)