Hi, gurus,
I need remove lines in a file which contains null value in certain column
eg.
in this file I need remove lines which second column contains null.
expected result:
Hi All,
I have a table with 10 columns. Some columns(2nd,4th,5th,7th,8th and 10th) are Not Null columns. I'll get a tab-delimited file and want to check col by col and generate seperate error code for each col eg:102 if 2nd col value is NULL and 104 if 4th col value is NULL so on... I am a... (7 Replies)
I'm trying to remove the null characters from a file and copy it to std output.
I'm using emacs and I create the following one line bash file (followed by the error messages):
sed -e 's/^@//' <ConfigItemReplicator.install.log
/usr/bin/bash: -c: line 0: unexpected EOF while looking for... (1 Reply)
Hi All,
I have a file with 10 columns and get the required data for nine columns properly except 8th. In 8th column i have both NULL and NON NULL values...i.e
certain records have values for all the columns including 8th column and certain records have 8th column as NULL.My requisite is,without... (20 Replies)
Hi, everyone
I have a requirement as following:
source file
1, abc, def, caaa
2, , cde, aaa
3, bcd, , adefefg
I need find columns which contains null value, in above example,
I need get two rows
2, , cde, aaa
3, bcd, , adefefg
anybody has idea how to achive this
... (5 Replies)
hi,
I had a small question.I had a file from which i need to extract data.
I have written the below script to check if the file exists and if it exists extract requierd columns from the file.
IFILE=/home/home01/Report_1.csv
OFILE=/home/home01/name.csv.out1
if #Checks if file exists... (1 Reply)
hi Gurus,
I need find the null column in a file.
my file like below
abc, ,cde,def
abc,ded,cdd,def
abc, ,ddd,ccd
aaa,bbb,ccc,ddd
basic, I need to find the lines which second column is null
Thanks in advance (3 Replies)
hi,
Am trying to find a solution for finding a null column value inside a loop using array.
for eg:
two
three
five
From the above array myarray,myarray and myarray having null values. But when am trying to check that space using some condition its not working.
for (( i=0;... (4 Replies)
Hi,
I have a huge list of archives (.gz). Each archive is about 40MB. A file is generated every minute so if I want to analyze the data for 1 hour I get already 60 files for example.
These are text files, ';' separated, each line having about 300 fields (columns).
What I need to do is to... (11 Replies)
We have a flat file with below data :
^@^@^@^@00000305^@^@^@^@^@^@430^@430^@^@^@^@^@^@^@^@^@09079989530As we can see ^@ is Null character in this file
I want to remove only the first few null characters before string 00000305
How can we do that, any idea. I want a new file without first few... (5 Replies)
ECACCESS-EVENT-GRANT(1p) User Contributed Perl Documentation ECACCESS-EVENT-GRANT(1p)NAME
ecaccess-event-grant - Grant usage of an ECaccess Event
SYNOPSIS
ecaccess-event-grant -version|-help|-manual
ecaccess-event-grant [-debug] [-subscribe] [-notify] event-id user-list
DESCRIPTION
Allow managing the Event permissions for a list of user(s).
The permissions can be either subscribe, notify, both or none. In order to remove permissions to an Event for a list of users use this
command with no -subscribe and -notify options.
ARGUMENTS
event-id
The identifier of the Event to grant.
user-list
The user(s) to give/remove the permissions. Multiple users should be separated by a column (e.g. abc,def).
OPTIONS -subscribe
The user(s) specified in the user-list will be allowed to subscribe to the event-id (e.g. with the -eventIds option of the
ecaccess-job-submit command).
-notify The user(s) specified in the user-list will be allowed to send notifications to the event-id (e.g. with the ecaccess-event-send
command).
-version
Display version number and exits.
-help Print a brief help message and exits.
-manual Prints the manual page and exits.
-debug Display the SOAP messages exchanged.
EXAMPLES
ecaccess-event-grant -subscribe 167 abc,def,jhi
Allow the users abc, def and jhi to subscribe to this Event.
ecaccess-event-grant 167 jkl
Remove all rights to the Event for the user jkl.
SEE ALSO
ecaccess-event-clear, ecaccess-event-delete, ecaccess-event-send, ecaccess-event-list, ecaccess-event-create and ecaccess.
perl v5.14.2 2012-04-16 ECACCESS-EVENT-GRANT(1p)