Sponsored Content
Top Forums UNIX for Dummies Questions & Answers How to convert text to columns in tab delimited text file Post 302457824 by kurumi on Tuesday 28th of September 2010 11:00:34 PM
Old 09-29-2010
well, as you can see, my output has no problem. Why don't you show how you do it
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Removing blanks in a text tab delimited file

Hi Experts I am very new to perl and need to make a script using perl. I would like to remove blanks in a text tab delimited file in in a specfic column range ( colum 21 to column 43) sample input and output shown below : Input: 117 102 650 652 654 656 117 93 95... (3 Replies)
Discussion started by: Faisal Riaz
3 Replies

2. Shell Programming and Scripting

Delete first column in tab-delimited text-file

I have a large text-file with tab-delimited genetic data that looks like: KSC112 KSC234 0 0 1 1 A G C T I simply wan to delete the first column, but since the file has 600 000 columns, it is not possible with awk (seems to be limited at 32k columns). Does anyone have an idea how to do this? (2 Replies)
Discussion started by: andmal
2 Replies

3. Shell Programming and Scripting

Extracting a portion of data from a very large tab delimited text file

Hi All I wanted to know how to effectively delete some columns in a large tab delimited file. I have a file that contains 5 columns and almost 100,000 rows 3456 f g t t 3456 g h 456 f h 4567 f g h z 345 f g 567 h j k lThis is a very large data file and tab delimited. I need... (2 Replies)
Discussion started by: Lucky Ali
2 Replies

4. UNIX for Dummies Questions & Answers

Deleting columns from a tab delimited text file?

I have a tab limited text file with 10000+ columns. I want to delete columns 6 through 23, how do I go about doing that? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies

5. UNIX for Dummies Questions & Answers

Add a new column to a tab delimited text file

I want to add a new column to a tab delimited text file. It will be the first column and it will just be 1's. How do I go about doing that? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies

6. UNIX for Dummies Questions & Answers

How to convert a text file into tab delimited format?

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. UNIX for Dummies Questions & Answers

Using awk to log transform a column in a tab-delimited text file?

How do I use awk to log transform the fifth column of a tab-delimited text file? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies

8. Shell Programming and Scripting

Remove blank columns from a tab delimited text file

Hello, I have some tab delimited files that may contain blank columns. I would like to delete the blank columns if they exist. There is no clear pattern for when a blank occurs. I was thinking of using sed to replace instances of double tab with blank, sed 's/\t\t//g' All of the examples... (2 Replies)
Discussion started by: LMHmedchem
2 Replies

9. UNIX for Dummies Questions & Answers

Need to convert a pipe delimited text file to tab delimited

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

Convert Excel File (xls) to tab delimited text file on AIX

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
SHOW(1)                                                              [nmh-1.5]                                                             SHOW(1)

NAME
show - show (display) messages SYNOPSIS
show [+folder] [msgs] [-draft] [-showproc program] [-showmimeproc program] [-header | -noheader] [-checkmime | -nocheckmime] [switches for showproc or showmimeproc] [-version] [-help] DESCRIPTION
Show lists each of the specified messages to the standard output (typically, the terminal). By default, text (non-MIME) messages are filtered and displayed by the nmh command mhl. This command will display text messages in a nice, uniform format. It also allows you to configure the format of the displayed messages and which headers fields are shown. See the mhl(1) manual page for the details about this command. This default can be changed by defining the showproc profile component. Any switches not recognized by show are passed along to that program. To override the default and the showproc profile component, use the -showproc program switch. For example, -showproc more will cause the more program to list the messages with no reformatting. Normally, this program is specified as the showproc in the user's .mh_profile, rather than using a command line switch. By default, non-text messages (MIME messages with multi-media contents) are processed and displayed by the nmh command mhshow. See the mhshow(1) manual page for details about this command. This default can changed by defining the showmimeproc profile component. Any switches not recognized by show are passed along to that program. To override this default and the showmimeproc profile component, use the -showmimeproc program switch. Note that in some cases, show may invoke the showmimeproc even for textual contents. This will happen for text messages that specify a transfer encoding (such as MIME quoted-printable or base64) or specify a character set that show doesn't believe can be displayed natively. The environment variable $MM_CHARSET should be set to the terminal's native character set to avoid gratuitous invocations of the showmime- proc. See the mh-profile(5) man page for details about this environment variable. The option -checkmime (set by default) instructs show to test if any of the messages to be displayed are non-text (MIME) messages. If any are non-text, they are displayed by the program showmimeproc, else they are displayed by the program showproc. The option -nocheckmime disables this test and instructs show to use showproc, regardless of whether any of the messages are non-text (MIME) messages. The -noshowproc switch will disable any formatting or paging of messages. It is equivalent to -nocheckmime -showproc cat. It is still accepted, but should be considered (somewhat) obsolete. If the environment variable $NOMHNPROC is set, the test for non-text (MIME) messages will be disabled. This method is obsolete. Use the -nocheckmime switch instead. The -header switch tells show to display a one-line description of the message being shown. This description includes the folder and the message number. If no `msgs' are specified, the current message is used. Although it depends on the specific showproc or showmimeproc, in the default set- up when more than one message is specified, you will be prompted for a <RETURN> prior to listing each message. Each message will be listed a page at a time, and when the end of page is reached, the program will wait for a <SPACE> or <RETURN>. If a <RETURN> is entered, it will print the next line, whereas <SPACE> will print the next screenful. If the standard output is not a terminal, no queries are made, and each file is listed with a one-line header and two lines of separation. "show -draft" will list the file <mh-dir>/draft if it exists. If the profile entry "Unseen-Sequence" is present and non-empty, then show will remove each of the messages shown from each sequence named by the profile entry. FILES
$HOME/.mh_profile The user profile PROFILE COMPONENTS
Path: To determine the user's nmh directory Current-Folder: To find the default current folder Unseen-Sequence: To name sequences denoting unseen messages showproc: Program to show text (non-MIME) messages showmimeproc: Program to show non-text (MIME) messages SEE ALSO
mhl(1), mhshow(1), more(1), next(1), prev(1), scan(1) DEFAULTS
`+folder' defaults to the current folder `msgs' defaults to cur `-checkmime' `-header' CONTEXT
If a folder is given, it will become the current folder. The last message selected will become the current message. BUGS
The -header switch doesn't work when `msgs' expands to more than one message. If the showproc is mhl, then this problem can be circum- vented by referencing the "messagename" field in the mhl format file. Show updates the user's context before showing the message. Hence show will mark messages as seen prior to the user actually seeing them. This is generally not a problem, unless the user relies on the "unseen" messages mechanism, and interrupts show while it is showing "unseen" messages. If your showproc is mhl (the default), then show uses a built-in mhl: it does not actually run the mhl program. Hence, if you define your own showproc , don't call it mhl since show won't run it. If your showproc is the pager more, then avoid running show in the background with only its standard output piped to another process, as in show | imprint & Due to a bug in more, show will go into a "tty input" state. To avoid this problem, re-direct show's diagnostic output as well. For users of csh: show |& imprint & For users of sh: show 2>&1 | imprint & MH.6.8 11 June 2012 SHOW(1)
All times are GMT -4. The time now is 09:31 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy