08-08-2007
Replace blank spaces by single tab, and right alignment
Folks, I am wondering if anyone solve this problem.
What I want to know is,
1. Delete all white spaces including leading blank space in each line (e.g. line 2), and replace such spaces by single tab except leading blank space
2. Then, align all columns to the right. But, output white space between columns should be identified by single tab, not white space, not multiple tab.
<input>
1990 8 9 2.31 3.12 4.343 112.113 0.123
1992 9 10 1.11 3.33 2.12 1.23 0.11
2011 10 11 2.56 7.23 3.11 2.33 0.1
Thanks,
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am searching while I await a response to this so if it has been asked already I apologize.
I have a file with lines in it that look like:
bob johnson email@email.org
I need it to look like:
bob:johnson:email@email.org
I am trying to use sed like this:
sed -e 's/ /:/g' file >... (5 Replies)
Discussion started by: NewSolarisAdmin
5 Replies
2. Shell Programming and Scripting
I'm new to bash and want to know a simple sed, awk, or grep script that will find all instances of 2 or more spaces and convert them to a single tab. Thanks for the help in advance. (1 Reply)
Discussion started by: jkandel
1 Replies
3. Shell Programming and Scripting
Hi All
I am having problem in substitution of any number of spaces, or a combination of space and tab in between strings in the lines of text file. Is there any way out in Perl? Please help me.
e.g.,
Say the input is in the following format:-
XX yyy zzz... (1 Reply)
Discussion started by: my_Perl
1 Replies
4. Shell Programming and Scripting
Hello All,
I am trying to remove all tabspaces and all blankspaces from my file using sed & awk, but not getting proper code. Please help me out.
My file is like this (<b> means one blank space, <t> means one tab space)-
$ cat file
NARESH<b><b><b>KUMAR<t><t>PRADHAN... (3 Replies)
Discussion started by: NARESH1302
3 Replies
5. Shell Programming and Scripting
Hi all,
Been trying to find a solution to this, I'm sure its a sed 1 liner, but I don't know sed well enough to work it out...
I have a text file in the following format:
431 666 1332 2665 0.24395
432 670 ... (3 Replies)
Discussion started by: mpcengineering
3 Replies
6. UNIX for Dummies Questions & Answers
my content:
samaccountname employeeid useraccountcontrol description
i want it to look like this:
"samaccountname","employeeid","useraccountcontrol","description" (2 Replies)
Discussion started by: tjmannonline
2 Replies
7. AIX
Dear Gurus
Can you please advise me on how to Replace all TAB characters with white spaces in a text file in AIX?
Either using vi or any utilities (2 Replies)
Discussion started by: tenderfoot
2 Replies
8. Shell Programming and Scripting
hi,
i need to replace a blank tab output in a file to zero.
input file:
2015/08/04 00:00:00 171 730579 27088 <blank> 3823 30273 1621778 ... (6 Replies)
Discussion started by: amyt1234
6 Replies
9. Shell Programming and Scripting
Hi Guru,
I need some advice on how to add blank spaces to the code, rather than me just adding <space-bar spaces> which does not work.
Current output of the code
File System Backed Up - ALL_LOCAL_DRIVES
Daily - Incremental Backup Schedule - 1 Month Retention
• 7pm - PRD... (2 Replies)
Discussion started by: Junes
2 Replies
10. Shell Programming and Scripting
I have the following file I wanted to convert mutiple spaces to tab:
I tried cat filename | tr ' ' '\t' or sed 's/ */ /' FILE
but it looses the format
5557263102 5557263102 5552074858 5726310211 5557263102 5557263102
5557263103 5557263103 2142406768 ... (2 Replies)
Discussion started by: amir07
2 Replies
PR(1) General Commands Manual PR(1)
NAME
pr - print file
SYNOPSIS
pr [ option ... ] [ file ... ]
DESCRIPTION
Pr produces a printed listing of one or more files on its standard output. The output is separated into pages headed by a date, the name
of the file or a specified header, and the page number. With no file arguments, pr prints its standard input.
Options apply to all following files but may be reset between files:
-n Produce n-column output.
+n Begin printing with page n.
-b Balance columns on last page, in case of multi-column output.
-d Double space.
-en Set the tab stops for input text every n spaces.
-h Take the next argument as a page header (file by default).
-in Replace sequences of blanks in the output by tabs, using tab stops set every n spaces.
-f Use formfeeds to separate pages.
-ln Take the length of the page to be n lines instead of the default 66.
-m Print all files simultaneously, each in one column.
-n Number the lines of each file.
-on Offset the left margin n character positions.
-sc Separate columns by the single character c instead of aligning them with white space. A missing c is taken to be a tab.
-t Do not print the 5-line header or the 5-line trailer normally supplied for each page.
-wn For multi-column output, take the width of the page to be n characters instead of the default 72.
SOURCE
/sys/src/cmd/pr.c
SEE ALSO
cat(1), lp(1)
PR(1)