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 DEBIAN
elvfmt
ELVFMT(1) User commands ELVFMT(1)NAME
elvfmt - adjust line-length for paragraphs of text
SYNOPSIS
elvfmt [-w width | -width] [-s] [-c] [-i chars] [-C] [-M] [file]...
VERSION
This page describes the Elvis 2.2_0 version of elvfmt. See elvis(1).
DESCRIPTION
elvfmt is a simple text formatter. It inserts or deletes newlines, as necessary, to make all lines in a paragraph be approximately the
same width. It preserves indentation and word spacing.
If you don't name any files on the command line, then elvfmt will read from stdin.
It is typically used from within vi(1) or elvis(1) to adjust the line breaks in a single paragraph. To do this, move the cursor to the top
of the paragraph, type "!}elvfmt", and hit <Return>.
OPTIONS -w width or -width
Use a line width of width characters instead of the default of 72 characters.
-s Don't join lines shorter than the line width to fill paragraphs.
-c Try to be smarter about crown margins. Specifically, this tells elvfmt to expect the first line of each paragraph to have a differ-
ent indentation than subsequent lines. If text from the first input line is wrapped onto the second output line, then elvfmt will
scan ahead to figure out what indentation it should use for the second output line, instead of reusing the first line's indentation.
-i chars
Allow the indentation text to include any character from chars, in addition to spaces and tabs. You should quote the chars list to
protect it from the shell.
-C and -M
These are shortcuts for combinations of other flags. is short for and is useful for reformatting C/C++ comments. is short for
and is useful for reformatting email messages.
SEE ALSO vi(1), elvis(1)AUTHOR
Steve Kirkendall
kirkenda@cs.pdx.edu
ELVFMT(1)