02-27-2012
missing coma delimeter in columns
hi
if coma delimeter missing in columns treat them as bad file and if it is not then gudfiles. just checking columns not data.
id,name,sal,deptno
1,awa,200,10
2,aba,100,20
3,cdc,300,30 this is gudfile
idname,sal,deptno
1,awa,200,10
2,aba,100,20
3,cdc,300,30 this is badfile since its missing the coma(,)
thanks.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Gurus,
I have a requirement like this and have to create a UX shell scripts. Thanks in advance.
File-in:
------
Header2007-12-012007-11-21
100|xyz|was
101|wsa|qws
......
.......
Output should be:
-------------------
2007-12-01|100|xyz|was
2007-12-01|101|wsa|qws
......
.......... (7 Replies)
Discussion started by: vsubbu1000
7 Replies
2. Shell Programming and Scripting
Dear Experts,
My file contains below-
GET:SUB:ISI,432350414557432;
RESP:0:MD,019352020633:ISI,432350414557432:T11,1:T21,1:T22,1:B16,1:T62,1:BAIC,0:BAOC,1:BOIC,0:BIRO,0:BORO,0:PAID,1;
GET:SUB:ISI,432350414581060;... (2 Replies)
Discussion started by: thepurple
2 Replies
3. Shell Programming and Scripting
Hi all,
I will have to check a directory which is full of files. If any file more than 5 MB of space exists, write on it's head "Checked". Please help me.
Thanks in advance!
Deepak (5 Replies)
Discussion started by: naw_deepak
5 Replies
4. Shell Programming and Scripting
Hi All,
I need to BCP out a table into a text file along with the table headers. Normal BCP out command only bulk copies the data, and not the headers.
I am using the following command: bcp database1..table1 out file1.dat -c -t\| -b1000 -A8192 -Uuser -Ppassword -efile.dat.err
Regards,... (0 Replies)
Discussion started by: shilpa_acc
0 Replies
5. Shell Programming and Scripting
I have 2 files that I would need from one file the 3rd column and put into the second file. Preferably in KSH . For example file one has
file1:
Column 1 Column 2 Column 3 Column 4 Column 5
file2:
Column 1 Column 2 Column 3 Column 4 Column 5
So take Column 3 and put into file1 making it... (4 Replies)
Discussion started by: bombcan1
4 Replies
6. Shell Programming and Scripting
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (4 Replies)
Discussion started by: Vavad
4 Replies
7. UNIX for Dummies Questions & Answers
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (1 Reply)
Discussion started by: Vavad
1 Replies
8. UNIX for Dummies Questions & Answers
Hi All,
I have a problem with the column heading while spooling the data from the database. Since i want the column header, therefore i am not using SET HEADING OFF, and i am getting the header, but for the longer column name, some of the character from the column name is missing.
for... (7 Replies)
Discussion started by: Pramod_009
7 Replies
9. Shell Programming and Scripting
Hello all,
I have a csv with with different testcase values in column 5.
year,min,max,Instrument,Testcase
2016,201,1003,GEOTROPH-02116,TATA7980
2016,53,1011,GEOTROPH-01963,TATA7980
2016,3,1024,GEOTROPH-02067,TATA7980
2016,203,1027,GEOTROPH-02011,TATA7980... (16 Replies)
Discussion started by: senhia83
16 Replies
10. Shell Programming and Scripting
I've been struggling with this one for quite a while and cannot seem to find a solution for this find/replace scenario. Perhaps I'm getting rusty.
I have a file that contains a number of metrics (exactly 3 fields per line) from a few appliances that are collected in parallel. To identify the... (3 Replies)
Discussion started by: verdepollo
3 Replies
LEARN ABOUT OPENSOLARIS
cdc
sccs-cdc(1) User Commands sccs-cdc(1)
NAME
sccs-cdc, cdc - change the delta commentary of an SCCS delta
SYNOPSIS
cdc -rsid [-mmr-list] [-y [comment]] s.filename...
DESCRIPTION
cdc annotates the delta commentary for the SCCS delta ID (SID) specified by the -r option in each named s.file.
If the v flag is set in the s.file, you can also use cdc to update the Modification Request (MR) list.
If you checked in the delta, or, if you own the file and directory and have write permission, you can use cdc to annotate the commentary.
Rather than replacing the existing commentary, cdc inserts the new comment you supply, followed by a line of the form:
*** CHANGED *** yy/mm/dd hh/mm/ss username
above the existing commentary.
If a directory is named as the s.filename argument, the cdc command applies to all s.files in that directory. Unreadable s.files produce an
error; processing continues with the next file (if any). If `-' is given as the s.filename argument, each line of the standard input is
taken as the name of an SCCS history file to be processed, and the -m and -y options must be used.
OPTIONS
-rsid Specify the SID of the delta to change.
-mmr-list Specify one or more MR numbers to add or delete. When specifying more than one MR on the command line, mr-list takes the
form of a quoted, space-separated list. To delete an MR number, precede it with a ! character (an empty MR list has no
effect). A list of deleted MRs is placed in the comment section of the delta commentary. If -m is not used and the standard
input is a terminal, cdc prompts with MRs? for the list (before issuing the comments? prompt). -m is only useful when the v
flag is set in the s.file. If that flag has a value, it is taken to be the name of a program to validate the MR numbers. If
that validation program returns a non-zero exit status, cdc terminates and the delta commentary remains unchanged.
-y[comment] Use comment as the annotation in the delta commentary. The previous comments are retained; the comment is added along with a
notation that the commentary was changed. A null comment leaves the commentary unaffected. If -y is not specified and the
standard input is a terminal, cdc prompts with comments? for the text of the notation to be added. An unescaped NEWLINE
character terminates the annotation text.
EXAMPLES
Example 1 Changing the annotated commentary
The following command:
example% cdc -r1.6 -y"corrected commentary" s.program.c
produces the following annotated commentary for delta 1.6 in s.program.c:
D 1.6 88/07/05 23:21:07 username 9 0 00001/00000/00000
MRs:
COMMENTS:
corrected commentary
*** CHANGED *** 88/07/07 14:09:41 username
performance enhancements in main()
FILES
z.file temporary lock file
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWsprot |
+-----------------------------+-----------------------------+
SEE ALSO
sccs(1), sccs-admin(1), sccs-comb(1), sccs-delta(1), sccs-help(1), sccs-prs(1), sccs-prt(1), sccs-rmdel(1), what(1), sccsfile(4),
attributes(5)
DIAGNOSTICS
Use the SCCS help command for explanations (see sccs-help(1)).
SunOS 5.11 30 Jun 2007 sccs-cdc(1)