Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Need help with shell script for chekking a column in txt file - pipe delimited Post 302271013 by ravi0435 on Tuesday 23rd of December 2008 01:32:01 PM
Old 12-23-2008
Thanks VGERSH99.
But could you please tell me how do i test it on the unix command prompt...i mean how do i send in the input file? so that it checks for the null column in all the records?

apreciate it.


thanks,
ravi
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

remove first column of a space delimited txt

how to remove the first column of a space delimited txt file? there are 12+ columns... what is the cleanest way? could use awk and print all but the first, but it looks kinda ugly awk '{print $2" "$3" "$4" "$5" "$6" "$7" "$8" "$9" "$10" "$11" "$12"}' file.txt whats a better way? (1 Reply)
Discussion started by: ajp7701
1 Replies

2. Shell Programming and Scripting

count of null in pipe delimited txt file

Hi, I have a pipe delimited txt file which contains 17 fields per line/row. 16th field contains email id. I want to count the number of lines/rows that contains null in the 16th field. Plz find attached example data file. I'm looking for a command line/script which achieves this. ... (5 Replies)
Discussion started by: Sriranga
5 Replies

3. Shell Programming and Scripting

How to insert a sequence number column inside a pipe delimited csv file using shell scripting?

Hi All, I need a shell script which could insert a sequence number column inside a dat file(pipe delimited). I have the dat file similar to the one as shown below.. |A|B|C||D|E |F|G|H||I|J |K|L|M||N|O |P|Q|R||S|T As shown above, the column 4 is currently blank and i need to insert sequence... (5 Replies)
Discussion started by: nithins007
5 Replies

4. Shell Programming and Scripting

Help with converting Pipe delimited file to Tab Delimited

I have a file which was pipe delimited, I need to make it tab delimited. I tried with sed but no use cat file | sed 's/|//t/g' The above command substituted "/t" not tab in the place of pipe. Sample file: abc|123|2012-01-30|2012-04-28|xyz have to convert to: abc 123... (6 Replies)
Discussion started by: karumudi7
6 Replies

5. Homework & Coursework Questions

how to show particular column from pipe delimited file

hi, I have pipe delimited flat file as below 1|ab|4.5|9| 2|ac|3|12| 3|ac|4.5|8| i want to show (display) only 3rd field between pipes. please help (1 Reply)
Discussion started by: vai15517
1 Replies

6. Shell Programming and Scripting

Replace pipe delimited column string to null

Hi All, I have a large dat file where each lines are pipe delimited values. I need to parse the file depending on the request. For example: sometimes I have told to remove all the values in the 7th column (this case remove values '3333' only from the first line and '3543' from the second line)... (4 Replies)
Discussion started by: express14
4 Replies

7. Shell Programming and Scripting

Replacing a column in a pipe delimited file

Hi, I have a pipe delimited file as below and I need to replace the 2nd column of each line with null values. 1|10/15/2011|fname1|lname1 2|10/15/2012|fname2|lname2 3|10/15/2013|fname3|lname3 Output file: 1||fname1|lname1 2||fname2|lname2 3||fname3|lname3 I tried this ... (2 Replies)
Discussion started by: member2014
2 Replies

8. UNIX for Dummies Questions & Answers

Need to convert a pipe delimited text file to tab delimited

Hi, I have a rquirement in unix as below . I have a text file with me seperated by | symbol and i need to generate a excel file through unix commands/script so that each value will go to each column. ex: Input Text file: 1|A|apple 2|B|bottle excel file to be generated as output as... (9 Replies)
Discussion started by: raja kakitapall
9 Replies

9. UNIX for Dummies Questions & Answers

Check for not null column in a pipe delimited file

Hi, I have a requirement where I have to check whether the mandatory columns in a pipe delimited file is null and print error message. For eg, I have to check if the 3rd,5th,6th,7th and 8th column are null and print the message "<column name> is null". The data file will have aroung 100,000... (6 Replies)
Discussion started by: reshma15193
6 Replies

10. Shell Programming and Scripting

Replace delimiter for a particular column in a pipe delimited file

I have an input file as below Emp1|FirstName|MiddleName|LastName|Address|Pincode|PhoneNumber 1234|FirstName1|MiddleName2|LastName3| Add1 || ADD2|123|000000000 Output : 1234|FirstName1|MiddleName2|LastName3| Add1 ,, ADD2|123|000000000 OR 1234,FirstName1,MiddleName2,LastName3, Add1 ||... (2 Replies)
Discussion started by: styris
2 Replies
cdc(1)							      General Commands Manual							    cdc(1)

Name
       cdc - change delta commentary of an SCCS file

Syntax
       cdc -rSID [-m[mrlist]]  [-y[comment]] files

Description
       The command changes the delta commentary of each named SCCS file, for the SID specified by the -r option.

       The  delta  commentary  is  defined to be the Modification Request (MR) and comment information usually specified by the command (-m and -y
       options).

       The commentary may consist of one or more lines, terminated by a dot in column one of a new line.

       If a directory is named, behaves as though each file in the directory were specified as a named file, except non-SCCS files (last component
       of the path name does not begin with s.)  and unreadable files, which are silently ignored.  If a name of - is given, the standard input is
       read (see RESTRICTIONS).  Each line of the standard input is taken to be the name of an SCCS file to be processed.

       Arguments to which may appear in any order, consist of option arguments, and file names.

       All the described option arguments apply independently to each named file.

Options
       -m[mrlist]     Adds or deletes modification numbers.  If the SCCS file has the v flag set then a list of MR  numbers  to  be  added  and/or
		      deleted  in the delta commentary of the SID specified by the -r option may be supplied.  For further information, see A null
		      MR list has no effect.

		      MR entries are added to the list of MRs in the same manner as that of In order to delete an MR, precede the MR  number  with
		      the  character  ! (see Examples).  If the MR to be deleted is currently in the list of MRs, it is removed and changed into a
		      comment line.  A list of all deleted MRs is placed in the comment section of the delta commentary and is preceded by a  com-
		      ment line stating that they were deleted.

		      If  -m  is not used and the standard input is a terminal, the prompt MRs?  is issued on the standard output before the stan-
		      dard input is read.  If the standard input is not a terminal, no prompt is issued.  The MRs? prompt always precedes the com-
		      ments? prompt (see -y option).
		      MRs in a list are separated by blanks and/or tab characters.  An unescaped new-line character terminates the MR list.

		      Note  that  if  the v flag has a value it is taken to be the name of a program (or shell procedure) which validates the cor-
		      rectness of the MR numbers.  For further information, see If a nonzero exit status is returned from the MR number validation
		      program, terminates and the delta commentary remains unchanged.

       -rSID	      Specifies the SCCS Identification string of a delta for which the delta commentary is to be changed.

       -y[comment]    Replaces	existing  commentary  for  the delta specified by the -r option.  The previous comments are kept and preceded by a
		      comment line stating that they were changed.  A null comment has no effect.

		      If -y is not specified and the standard input is a terminal, the prompt comments? is issued on the  standard  output  before
		      the standard input is read; if the standard input is not a terminal, no prompt is issued.  A dot in column one of a new line
		      terminates the comment text.

       Certain permissions are necessary to modify the SCCS file; generally, however, if you made the delta, you can change its delta  commentary,
       and if you own the file and directory you can modify the delta commentary.

Examples
       This example shows how to add bl78-12345 and bl79-00001 to the MR list, remove bl77-54321 from the MR list, and add the comment ``trouble''
       to delta 1.6 of s.file.
       sccscdc -r1.6 -m"bl78-12345 !bl77-54321 bl79-00001" -ytrouble .file

       This example does the same thing.
       sccscdc -r1.6 .file

       -MRs? !bl77-54321 bl78-12345 bl79-00001

       comments? trouble

Restrictions
       If SCCS file names are supplied to the command via the standard input (- on the command line), then the -m and  -y  options  must  also	be
       used.

Diagnostics
       See for explanations.

Files
       For more information, see

       For more information, see

See Also
       admin(1), delta(1), get(1), help(1), prs(1), sccs(1), sccsfile(5)
       Guide to the Source Code Control System

																	    cdc(1)
All times are GMT -4. The time now is 03:54 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy