10-16-2008
i suggest you change your excel delimiter to something else when you export it.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi there
Just wondered if someone could help me out
I have a file that has been delimited by tabs, ie
field1<tab>fiield2<tab>field3
Does anybody know a command that will convert tabs to commas throughout the entire file?
Note: there are a number of unpopulated fields in the file so... (6 Replies)
Discussion started by: hcclnoodles
6 Replies
2. Shell Programming and Scripting
Hi,
Can anyone let me know on how to convert a Tab delimited file to Comma delimited file in Unix
Thanks!! (22 Replies)
Discussion started by: charan81
22 Replies
3. UNIX for Dummies Questions & Answers
Hi all,
I have a file with single white space delimited values, I want to convert them to a tab delimited file.
I tried sed, tr ... but nothing is working.
Thanks,
Rajeevan D (16 Replies)
Discussion started by: jeevs81
16 Replies
4. UNIX for Dummies Questions & Answers
Hi Forum
I have a tab delimited file that opens well in Openoffice calc (excel). But when I perform any operation in command line, it reads the file incorrectly. When I 'save As' the same file in office as tab delimited then it works fine.
The file that I think is tab delimited is actually... (8 Replies)
Discussion started by: imlearning
8 Replies
5. Shell Programming and Scripting
I have a file which was pipe delimited, I need to make it tab delimited. I tried with sed but no use
cat file | sed 's/|//t/g'
The above command substituted "/t" not tab in the place of pipe.
Sample file:
abc|123|2012-01-30|2012-04-28|xyz
have to convert to:
abc 123... (6 Replies)
Discussion started by: karumudi7
6 Replies
6. Homework & Coursework Questions
1. The problem statement, all variables and given/known data:
Hello!
I need help with this problem bash shell scripting that basically just reads the data in a tab delimited file and does the following below
1. Read in the data file Survey.txt and assign the column values to variables of... (6 Replies)
Discussion started by: jsmith6932
6 Replies
7. Shell Programming and Scripting
Hi How to make tab delimited file to space delimited?
in put file:
ABC kgy
jkh ghj
ash kjl
o/p file:
ABC kgy
jkh ghj
ash kjl
Use code tags, thanks. (1 Reply)
Discussion started by: jagdishrout
1 Replies
8. Shell Programming and Scripting
Hi Experts,
I have a tab deliminated file as below
myfile.txt
Local Group Memberships *Administrators *Guests
I need data in below format starting from 4th position.
myfile1.txt
Administrators Guests
the above one is just an example and there could... (15 Replies)
Discussion started by: Litu1988
15 Replies
9. UNIX for Dummies Questions & Answers
Hi, I have a rquirement in unix as below .
I have a text file with me seperated by | symbol and i need to generate a excel file through unix commands/script so that each value will go to each column.
ex:
Input Text file:
1|A|apple
2|B|bottle
excel file to be generated as output as... (9 Replies)
Discussion started by: raja kakitapall
9 Replies
10. UNIX for Beginners Questions & Answers
Hello Everyone..
I want to replace the retail col from FileI with cstp1 col from FileP if the strpno matches in both files
FileP.txt
... (2 Replies)
Discussion started by: YogeshG
2 Replies
TABS(1) BSD General Commands Manual TABS(1)
NAME
tabs -- set terminal tabs
SYNOPSIS
tabs [-n|-a|-a2|-c|-c2|-c3|-f|-p|-s|-u] [+m[n]] [-T type]
tabs [-T type] [+[n]] n1[,n2,...]
DESCRIPTION
The tabs utility displays a series of characters that first clears the hardware terminal tab settings and then initializes the tab stops at
the specified positions and optionally adjusts the margin.
The phrase "tab-stop position N" means that, from the start of a line of output, tabbing to position N shall cause the next character output
to be in the (N+1)th column on that line.
The following options are supported:
-n Specifies repetitive tab stops separated by a uniform number of columns, n, where n is a single digit decimal number. The
default usage of tabs with no arguments is equivalent to tabs -8. When -0 is used, the tab stops are cleared and no new ones
set.
-a Assembler, applicable to some mainframes. Equivalent to tabs 1,10,16,36,72 .
-a2 Assembler, applicable to some mainframes. Equivalent to tabs 1,10,16,40,72
-c COBOL, normal format. Equivalent to tabs 1,8,12,16,20,55
-c2 COBOL, compact format (columns 1 to 6 omitted). Equivalent to tabs 1,6,10,14,49
-c3 COBOL, compact format (columns 1 to 6 omitted), with more tabs than -c2. Equivalent to tabs
1,6,10,14,18,22,26,30,34,38,42,46,50,54,58,62,67
-f FORTRAN. Equivalent to tabs 1,7,11,15,19,23
-p PL/1. Equivalent to tabs 1,5,9,13,17,21,25,29,33,37,41,45,49,53,57,61
-s SNOBOL. Equivalent to tabs 1,10,55
-T type Indicates the type of terminal.
-u Assembler, applicable to some mainframes. Equivalent to tabs 1,12,20,44
EXIT STATUS
The tabs utility exits 0 on success, and >0 if an error occurs.
ENVIRONMENT
The COLUMNS and TERM environment variables affect the execution of tabs as described in environ(7).
The -T option overrides TERM. If neither TERM nor the -T option are present, tabs will fail.
SEE ALSO
expand(1), stty(1), tput(1), unexpand(1), termcap(5)
STANDARDS
The tabs utility conforms to IEEE Std 1003.1 (``POSIX.1'').
HISTORY
A tabs utility first appeared in PWB UNIX. This implementation was introduced in NetBSD 6.0.
AUTHORS
Roy Marples <roy@NetBSD.org>
BUGS
The current termcap(5) database does not define the set left soft margin 'ML' capability for any terminals.
BSD
December 9, 2008 BSD