Vlookup and remove line Post: 303012074

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Remove header(first line) and trailer(last line) in ANY given file

Hi, I need some help in removing the header (first line) and the trailer (last line) in a give file... The data file actually comes in EBCDIC format and I converted it into ASCII.. Now I need to strip off the first line and the last line.. I think we can use sed to do something like this:...

2. Shell Programming and Scripting

SED help (remove line::parse again::add line)

Aloha! I have just over 1k of users that have permissions that they shouldn't under our system. I need to parse a provided list of usernames, check their permissions file, and strip the permissions that they are not allowed to have. If upon the permissions strip they are left with no permissions,...

3. Shell Programming and Scripting

sed remove last 10 characters of a line start from 3rd line

hello experts, I need a sed command that remove last 10 characters of a line start from 3rd line. any suggestions? Thanks you

4. Shell Programming and Scripting

Remove line based on string and put new line with parameter

Hi Folks, I am new to ksh, i have informatica parameter file that i need to update everyday with shell script. i need your help updating this file with new parameters. sample data $$TABLE1_DATE=04-27-2011 $$TABLE2_DATE=04-23-2011 $$TABLE3_DATE=03-19-2011 .......Highligned...

5. Shell Programming and Scripting

Want to remove a line feed depending on number of tabs in a line

Hi! I have been struggling with a large file that has stray end of line characters. I am working on a Mac (Lion). I mention this only because I have been mucking around with fixing my problem using sed, and I have learned far more than I wanted to know about Unix and Mac eol characters. I...

6. UNIX for Dummies Questions & Answers

How to remove fields space and append next line to previous line.?

awk 'BEGIN{FS = "�"} NR == 1 {p = $0; next} NF > 1 {print p; p = $0} NF <= 1 {p = (p " " $0)} END {print p}' input.txt > output.txt This is what the input data file looks like with broken lines Code: 29863 �890000000 �543209911 �CHNGOHG �000000001 �055 ...

7. Shell Programming and Scripting

Ksh: Read line parse characters into variable and remove the line if the date is older than 50 days

I have a test file with the following format, It contains the username_date when the user was locked from the database. $ cat lockedusers.txt TEST1_21062016 TEST2_02122015 TEST3_01032016 TEST4_01042016 I'm writing a ksh script and faced with this difficult scenario for my...

8. Shell Programming and Scripting

Remove new line starting with a numeric value and append it to the previous line

Hi, i have a file with multiple entries. After some tests with sed i managed to get the file output as follows: lsn=X-LINK-IN0,apc=661:0,state=avail,avail/links=1/1, 00,2110597,2094790,0,81,529,75649011,56435363, lsn=TM1ITP1-AM1ITP1-LS,apc=500:0,state=avail,avail/links=1/1,...

9. UNIX for Beginners Questions & Answers

Vlookup on 2 files - inserting vlookup command on another command

Hello, i am trying to print group name column(etc/group) on script (etc/passwd) since group name is not listed on etc/passwd columns. Im trying to do a vlookup. but i cant figure out how i can insert the vlookup command FNR==NR inside the print out command or the output. I also tried exporting...

LEARN ABOUT HPUX

remove_directory

remove directory(1m)													      remove directory(1m)

NAME

       remove directory - Removes a value from a set-valued or single-valued attribute (including application-defined attributes) of a directory

SYNOPSIS

       cdscp remove directory directory-name attribute-name [= attribute-value]

ARGUMENTS

       The  full  name	of the directory.  The name of a particular attribute.	Specify only one attribute at a time.  See the cds_attributes file
       for the list of attributes and corresponding data types that your application uses.  The value of a particular attribute.  The value of	an
       application-defined attribute is dependent on the type of attribute.

DESCRIPTION

       The  remove  directory command removes a value from a set-valued or single-valued attribute (including application-defined attributes) of a
       directory.  If you do not specify a value, the command removes the entire attribute.  This command can delete attributes created by the add
       directory and set directory commands.  Usually this task is performed through the client application.  See the OSF DCE Administration Guide
       for more information about attributes.

   Privilege Required
       You must have write permission to the directory.

NOTE

       This command is replaced at Revision 1.1 by the dcecp command and may not be provided in future releases of DCE.

EXAMPLE

       To remove the value 1 from the user-defined, set-valued attribute dirregion of a directory named  /.:/sales, follow these steps:  Read  the
       cds_attributes file to check that the attribute dirregion is listed, as shown in the following display:

	   OID		  LABEL 	 SYNTAX  1.3.22.1.3.66	  dirregion	  small Enter the following command to remove the value 1 from the
       attribute dirregion.  cdscp> remove directory /.:/sales dirregion = 1

RELATED INFORMATION

       Commands: add directory(1m), list directory(1m), set directory(1m), set directory to skulk(1m), show directory(1m)

       Books: OSF DCE Administration Guide

															      remove directory(1m)