Hi,I have a single sql file containing many create table ddl's.Example:
CREATE TABLE sec_afs
(
rpt_per_typ_c char(1) NOT NULL,
rpt_per_typ_t varchar(20) NULL,
LOCK ALLPAGES
go
EXEC sp_primarykey 'sec_afs', rpt_per_typ_c
go
GRANT SELECT ON sec_afs TO developer_read_only... (5 Replies)
Dear All,
I would like to split a file of the following format into multiple files based on the number in the 6th column (numbers 1, 2, 3...):
ATOM 1 N GLY A 1 -3.198 27.537 -5.958 1.00 0.00 N
ATOM 2 CA GLY A 1 -2.199 28.399 -6.617 1.00 0.00 ... (3 Replies)
Hi folks,
Happy new year.
I have a file 'filename' that i wd like to split basing on the contents in the last column.
The 'filename' content looks like
256772744788,9,11
256772744805,9,11
256772744792,9,11
256775543055,10,12
256782625357,9,12
256772368953,10,13
256772627735,10,13... (3 Replies)
Let's assume that I have a file name called ‘A' and it has 100 lines in it and would like to split these 100 lines into 4 files as specified bellow.
INPUT: Input file name A
1
2
3
4
5
6
7
8
9
........100
Output: 4 output files (x,y,z,w)
File x should contains (Skip 4 lines)... (15 Replies)
Hi,
I am new to unix. we have a requirement here to split a single file into multiples files based on the number of people available for processing. So i tried my hand at writing some code as below.
#!/bin/bash
var1=`wc -l $filename`
var2=$var1/$splitno
split -l $var2 $1
Please help me... (6 Replies)
I have one single shown below and I need to break each ST|850 & SE to separate file using unix script. Below example should create 3 files. We can use ST & SE to filter as these field names will remain same.
Please advice with the unix code.
ST|850
BEG|PO|1234
LIN|1|23
SE|4
ST|850... (3 Replies)
Hi All,
I have the sales_data.csv file in the directory as below.
SDDCCR; SOM ; MD6546474777 ;05-JAN-16
ABC ; KIRAN ; CB789 ;04-JAN-16
ABC ; RAMANA; KS566767477747 ;06-JAN-16
ABC ; KAMESH; A33535335 ;04-JAN-16
SDDCCR; DINESH; GD6674474747 ;08-JAN-16... (4 Replies)
I have a variable that contains the following string:
FPATH=-rw-rw-r-- 1 user1 dba 0 Aug 7 13:14 /app/F11.3/app/cust/exe/filename1.exe' -rw-rw-r-- 1 user1 dba 0 Aug 19 10:09 /app/app/F11.3/app/cust/sql/33211.sql' -rw-r--r-- 1 user1 dba 0 Aug 6 17:20 /app/F11.2/app/01/mrt/file1.mrt'
I... (7 Replies)
Discussion started by: mohtashims
7 Replies
LEARN ABOUT BSD
man
MAN(7) Miscellaneous Information Manual MAN(7)NAME
man - macros to typeset manual
SYNOPSIS
nroff -man file ...
troff -man file ...
DESCRIPTION
These macros are used to lay out pages of this manual. A skeleton page may be found in the file /usr/man/man.template.
Any text argument t may be zero to six words. Quotes may be used to include blanks in a `word'. If text is empty, special treatment is
applied to the next input line with text to be printed. In this way .I may be used to italicize a whole line, or .SM may be followed by .B
to make small bold letters.
A prevailing indent distance is remembered between successive indented paragraphs, and is reset to default value upon reaching a non-
indented paragraph. Default units for indents i are ens.
Type font and size are reset to default values before each paragraph, and after processing font and size setting macros.
These strings are predefined by -man:
*R `(Reg)', trademark symbol in troff.
*S Change to default type size.
FILES
/usr/share/tmac/tmac.an
/usr/man/man.template
SEE ALSO troff(1), man(1)BUGS
Relative indents don't nest.
REQUESTS
Request Cause If no Explanation Break Argument .B t no t=n.t.l.*Text t is bold. .BI
t no t=n.t.l. Join words of t alternating bold and italic. .BR t no t=n.t.l. Join words of t
alternating bold and Roman. .DT no .5i 1i...Restore default tabs. .HP i yes i=p.i.* Set pre-
vailing indent to i. Begin paragraph with hanging indent. .I t no t=n.t.l. Text t is italic. .IB
t no t=n.t.l. Join words of t alternating italic and bold. .IP x i yes x="" Same as .TP with tag
x. .IR t no t=n.t.l. Join words of t alternating italic and Roman. .LP yes - Same as
.PP. .PD d no d=.4v Interparagraph distance is d. .PP yes - Begin paragraph. Set
prevailing indent to .5i. .RE yes - End of relative indent. Set prevailing indent to amount of
starting .RS. .RB t no t=n.t.l. Join words of t alternating Roman and bold. .RI
t no t=n.t.l. Join words of t alternating Roman and italic. .RS i yes i=p.i. Start relative
indent, move left margin in distance i. Set prevailing indent to .5i for nested indents. .SH
t yes t=n.t.l. Subhead. .SM t no t=n.t.l. Text t is small. .TH n c x v m yes -Begin
page named n of chapter c; x is extra commentary, e.g. `local', for page foot center; v alters page foot left, e.g.
`4th Berkeley Distribution'; m alters page head center, e.g. `Brand X Programmer's Manual'. Set prevailing indent and
tabs to .5i. .TP i yes i=p.i. Set prevailing indent to i. Begin indented paragraph with hanging tag given
by next text line. If tag doesn't fit, place it on separate line.
* n.t.l. = next text line; p.i. = prevailing indent
7th Edition October 22, 1996 MAN(7)