12-29-2016
unexpand -a will do that for you. Check your system if it is available. In my system (Debian 8) it is part of coreutils.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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... (1 Reply)
Discussion started by: Jae
1 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
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
4. Shell Programming and Scripting
Hi,
We have a couple of ms excel files in unix server.We need convert the excel files to files TAB limiter format file with using unix script.
Could you please advise on this (2 Replies)
Discussion started by: koti_rama
2 Replies
5. Shell Programming and Scripting
Dear all,
I have a file in this format (like a matrix)
- A B C .. X
A 1 4 2 .. 2
B 2 6 4 .. 8
C 3 5 5 .. 4
. . . ... .
X . . ... .
and want to convert it into a file with this format:
A A = 1
A B = 4
A C = 2
...
A X = 2
B A = 2
B B = 6
etc (2 Replies)
Discussion started by: TheTransporter
2 Replies
6. UNIX for Dummies Questions & Answers
I have a text file that made using text editor in Ubuntu. However the text file is not being recognized as space or tab delimited, the formatting seems to be messed up. How can I convert the text file into tab delimited format? (3 Replies)
Discussion started by: evelibertine
3 Replies
7. Shell Programming and Scripting
Hi all,
How can i convert comma delimited .csv file to tab separate using sed command or script.
Thanks,
Krupa (4 Replies)
Discussion started by: krupasindhu18
4 Replies
8. Shell Programming and Scripting
Hi all,
I have a 3 columns input file like this:
CPLX9PC-4943 CPLX9PC-4943 1
CPLX9PC-4943 CpxID123 0
CPLX9PC-4943 CpxID126 0
CPLX9PC-4943 CPLX9PC-5763 0.5
CPLX9PC-4943 CpxID13 0
CPLX9PC-4943 CPLX9PC-6163 0
CPLX9PC-4943 CPLX9PC-6164 0.04... (7 Replies)
Discussion started by: AshwaniSharma09
7 Replies
9. UNIX for Beginners Questions & Answers
Hi
i have a problem in my job
i try to convert an excel file (xls extention) to text file (tab delimited), but no result with this comand
cat xxx.xls > xxx.txt
Do you have eny idea?
PS: sorry for my english
Thanks!! (4 Replies)
Discussion started by: frisso
4 Replies
10. Shell Programming and Scripting
Hello,
I wrote several scripts that work with job arrays (sbatch) that look like this:
#!/bin/bash
#SBATCH --partition=carl.p
#SBATCH --ntasks=4
#SBATCH --time=0-10:00
#SBATCH --mem-per-cpu=48G
#SBATCH --job-name=basic_test
#SBATCH --mail-type=END,FAIL
#SBATCH --mail-user=
#SBATCH... (2 Replies)
Discussion started by: idbemad
2 Replies
LEARN ABOUT MOJAVE
unexpand
EXPAND(1) BSD General Commands Manual EXPAND(1)
NAME
expand, unexpand -- expand tabs to spaces, and vice versa
SYNOPSIS
expand [-t tab1,tab2,...,tabn] [file ...]
unexpand [-a | -t tab1,tab2,...,tabn] [file ...]
DESCRIPTION
The expand utility processes the named files or the standard input writing the standard output with tabs changed into blanks. Backspace
characters are preserved into the output and decrement the column count for tab calculations. The expand utility is useful for pre-process-
ing character files (before sorting, looking at specific columns, etc.) that contain tabs.
The unexpand utility puts tabs back into the data from the standard input or the named files and writes the result on the standard output.
The following options are available:
-a (unexpand only.) By default, only leading blanks and tabs are reconverted to maximal strings of tabs. If the -a option is given,
then tabs are inserted whenever they would compress the resultant file by replacing two or more characters.
-t tab1,tab2,...,tabn
Set tab stops at column positions tab1, tab2, ..., tabn. If only a single number is given, tab stops are set that number of column
positions apart instead of the default number of 8.
ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of expand and unexpand as described in environ(7).
EXIT STATUS
The expand and unexpand utilities exit 0 on success, and >0 if an error occurs.
STANDARDS
The expand and unexpand utilities conform to IEEE Std 1003.1-2001 (``POSIX.1'').
HISTORY
The expand command appeared in 3.0BSD.
BSD
October 13, 2006 BSD