I think awk can do this. Set the record separator as form-feed, and set the field separator as newline, so every 'line' is an entire page, and every 'field' is an entire line.
NF thus becomes the count of lines. And you can just set NF, then print. It will happily fill linefeeds between blank fields.
Requires nawk or gawk unless you're on Linux.
Code:
# Proof of principle. Each 'block' separated by form-feed(\014)
# gets stretched to 5 lines. Form-feed is not printed so the terminal doesn't erase itself.
printf "a\n\014b\n\014c\nd\ne\n\014" | awk -v RS="\014" -v FS="\n" -v OFS="\n" -v ORS="\n" '{ NF=5 } 1'
a
b
c
d
e
# Command you'd actually run:
$ awk -v RS="\014" -v FS="\n" -v OFS="\n" -v ORS="\n\014" '{ NF=65 } 1' input > output
If your document uses carriage returns, change FS, OFS, and ORS so \n is \r\n.
ladies, gents..
say i have a file that should have 10 fields... (9 delimiters)
some records have 10 fields, some have 5 some have 8, etc.. nothing consistent, but i need my file to have 9 delimiters on each line, even if its null fields..
how can i go line by line and add the correct... (2 Replies)
Not sure about the title if someone has a better name for it please lemme know and I will edit the title.
I have several (10+ files) which look something like:
File 1:
12/28/2009 04:0 8
12/28/2009 04:4 4
12/28/2009 05:0 4
.
.
.
File 2:
12/28/2009 04:1 7
12/28/2009 04:2 3... (2 Replies)
Greetings all,
i have csv file with pipe separated columns
SSN|NAME|ADDRESS|FILLER
123|abc|myaddress|xxx
234|BBB|my
add
ress
broken up|yyy
In the example above, the second record is broken into multiple lines. I need to keep going until I find a "|" since this issue is with the... (14 Replies)
hello all,
I have files that have a specific way for naming the first column
they are make of five names in Pattern of 3
Y = (no case sensitive)
so the files are names $Y-$Y-$Y or $X-$Y-$Z depending how we look
they only exist of the pattern exist
now I want to create a file from them that... (9 Replies)
Issue resolved by upgrading from solaris 11 to solaris 11.1
I would like to enable network mapping.
While using instructions from:
https://blogs.oracle.com/VDIpier/entry/solaris_11_changing_the_hostname
To change my hostname I noticed I am missing the enable mapping bool.
What it should... (0 Replies)
Hello,
This is a programming question as well as a suse question, so let me know if you think I should post this in programming.
I have an application that I compiled under opensuse 12.2 using g77-3.3/g++3.3. The program compiles and runs just fine. I gave the application to a colleague who... (2 Replies)
I am doing FTP from a server and getting below ERROR:WARNING! 16126 bare linefeeds received in ASCII mode
File may not have transferred correctly.
I looked into web and found that I may need to change the mode to binary, but when I do so the records are not in readable format...So need the file... (10 Replies)
Hi Gurus,
I have a txt file. some record missed 2nd colum value, I need put default value into the file.
ex: below file, first 4 records, missed one column (only 4 columns. it should be 5)
$cat missedfield
aaa,bbb,ccc,fff
aaa,bbb,ccc,ddd
111,222,333,444
111,222,333,444... (3 Replies)
Hi team...
I need some help/advise on adding a word for a missing column.
I have a file as below.
Rep N1
Forever
Limited
2015
Rep N2
Limited
2016
since 2nd content is 3 lines missing one line so i need to make this like
Rep N1
Forever (3 Replies)
Hi Again,
I have a file that contains date and time for the past 2 hours. What i need is add missing date and time in a file.
INPUT
2016-01-13 01:33 10
2016-01-13 01:31 10
2016-01-13 01:30 10
2016-01-13 01:29 10
2016-01-13 01:28 10
2016-01-13 01:27 10
2016-01-13 01:26 10
2016-01-13... (14 Replies)
Discussion started by: ernesto
14 Replies
LEARN ABOUT BSD
col
COL(1) General Commands Manual COL(1)NAME
col - filter reverse line feeds
SYNOPSIS
col [ -bfh ]
DESCRIPTION
Col reads the standard input and writes the standard output. It performs the line overlays implied by reverse line feeds (ESC-7 in ASCII)
and by forward and reverse half line feeds (ESC-9 and ESC-8). Col is particularly useful for filtering multicolumn output made with the
`.rt' command of nroff and output resulting from use of the tbl(1) preprocessor.
Although col accepts half line motions in its input, it normally does not emit them on output. Instead, text that would appear between
lines is moved to the next lower full line boundary. This treatment can be suppressed by the -f (fine) option; in this case the output
from col may contain forward half line feeds (ESC-9), but will still never contain either kind of reverse line motion.
If the -b option is given, col assumes that the output device in use is not capable of backspacing. In this case, if several characters
are to appear in the same place, only the last one read will be taken.
The control characters SO (ASCII code 017), and SI (016) are assumed to start and end text in an alternate character set. The character
set (primary or alternate) associated with each printing character read is remembered; on output, SO and SI characters are generated where
necessary to maintain the correct treatment of each character.
If the -h option is given, col converts white space to tabs to shorten printing time.
All control characters are removed from the input except space, backspace, tab, return, newline, ESC (033) followed by one of 7, 8, 9, SI,
SO, and VT (013). This last character is an alternate form of full reverse line feed, for compatibility with some other hardware conven-
tions. All other non-printing characters are ignored.
SEE ALSO troff(1), tbl(1)BUGS
Can't back up more than 128 lines.
No more than 800 characters, including backspaces, on a line.
7th Edition May 16, 1986 COL(1)