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)
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)
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)
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)
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)
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)
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)
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)
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_field_len
CUBRID_FIELD_LEN(3) 1 CUBRID_FIELD_LEN(3)cubrid_field_len - Get the maximum length of the specified fieldSYNOPSIS
int cubrid_field_len (resource $result, int $field_offset)
DESCRIPTION
This function returns the maximum length of the specified field on success, or it returns FALSE on failure.
PARAMETERS
o $result
-$result comes from a call to cubrid_execute(3)
o $field_offset
-The numerical field offset. The $field_offset starts at 0. If $field_offset does not exist, an error of level E_WARNING is also
issued.
RETURN VALUES
Maximum length, when process is successful.
FALSE on failure.
EXAMPLES
Example #1
cubrid_field_len(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb");
$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
PHP Documentation Group CUBRID_FIELD_LEN(3)