9 More Discussions You Might Find Interesting
1. 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
2. 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
3. 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
4. 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
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 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
7. 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
8. 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
9. 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