|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Field value check
Post 302902292 by Aia on Tuesday 20th of May 2014 12:15:41 AM
05-20-2014
|
|
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
In awk, I'd like to check if a field is blank.
And by blank I mean, the field could be "" or " "
In other words, the field could either be empty, or be filled with spaces.
Would the regex look like this?
$5 ~ // { Action }?
What other ways are there?
Hmm.. in any case I think... (7 Replies)
Discussion started by: yongho
7 Replies
2. Shell Programming and Scripting
hi
i need to check for the value of one particular field : in the output file. the file may contain many such records as below
how to ????
*** Throttled with base name + key params!
:
: -518594328
: les.alarm.LBS12005
: les.alarm.LBS12005
: les
: lessrv1
: les
: 2328
: 0... (7 Replies)
Discussion started by: aemunathan
7 Replies
3. Shell Programming and Scripting
Hi Everyone,
# cat a.txt
94,aqqc,62345907,
5,aeec,77,
# cat 1.pl
#!/usr/bin/perl
use strict;
use warnings;
use Date::Manip;
open(my $FA, "/root/a.txt") or die "$!";
while(<$FA>) {
chomp;
my @tmp=split(/\,/, $_);
if (index($tmp, "qq") ne -1) {
... (4 Replies)
Discussion started by: jimmy_y
4 Replies
4. Shell Programming and Scripting
Hi Everyone,
Below is the script, i feel there should be more simple way to do the same output, my one works, but feel not nice. like using index i feel it is slow (image my file is very large), maybe awk can do one line code?
Please advice.
# cat 1.txt
1 a
2 b
3 cc
4 d
# cat 1.pl... (6 Replies)
Discussion started by: jimmy_y
6 Replies
5. Shell Programming and Scripting
Hi Everyone,
1.txt
a;1234;134;1111111
b;123;123;1111111
c;123;1334;1111111
d;1234;1234;1111111
output
a;1234;134;1111111
c;123;1334;1111111
d;1234;1234;1111111
if field2 legth>3 or field3 length >3, then output. Please advice.
Thanks (4 Replies)
Discussion started by: jimmy_y
4 Replies
6. Shell Programming and Scripting
Hi,
I had input file with below data,
abcdefghij;20100903040607;1234567891;GLOBAL;
Having values of fields with seperated by semi-colon (;) and ended with line feed (\n).
Through shell script, how can I check the field formatting?
Thanks in advance. (18 Replies)
Discussion started by: Poonamol
18 Replies
7. Shell Programming and Scripting
I have made a table PRD_WORK_LM.test and it contains one field, ctrl_test. This field contains a 0 or a 1. I want to write a unix script that goes like this:
IF ctrl_test = 1 THEN ... ELSE exit FI
How can I write this in a script? Do I have to do this within bteq? or outside bteq? can... (5 Replies)
Discussion started by: katled
5 Replies
8. Shell Programming and Scripting
Hello,
For work i am trying to generate a combined csv file excisting out of 2 other csv files.
The problem i am facing is that the first field on both files have multiple values in there which arent always the same. This first field is also the joining part.
The layout of the files is as... (16 Replies)
Discussion started by: SDohmen
16 Replies
9. Shell Programming and Scripting
I need a script to check the records in a file , if any value match transfer the record in error.txt file.
1- If any of the any field value is NULL(nothing in this field)
Record1|Record2|Record3|Record4|Record5|DATE1|DATE2
Example:
11111111|22222222|NULL|12|444|27042018|27042018... (8 Replies)
Discussion started by: vivekn
8 Replies
LEARN ABOUT PHP
db2_field_type
DB2_FIELD_TYPE(3) 1 DB2_FIELD_TYPE(3) db2_field_type - Returns the data type of the indicated column in a result set SYNOPSIS
string db2_field_type (resource $stmt, mixed $column) DESCRIPTION
Returns the data type of the indicated column in a result set. PARAMETERS
o $stmt - Specifies a statement resource containing a result set. o $column - Specifies the column in the result set. This can either be an integer representing the 0-indexed position of the column, or a string containing the name of the column. RETURN VALUES
Returns a string containing the defined data type of the specified column. If the specified column does not exist in the result set, db2_field_type(3) returns FALSE. SEE ALSO
db2_field_display_size(3), db2_field_name(3), db2_field_num(3), db2_field_precision(3), db2_field_scale(3), db2_field_width(3). PHP Documentation Group DB2_FIELD_TYPE(3)