Sponsored Content
Top Forums Shell Programming and Scripting Copy and Paste Columns in a Tab-Limited Text file Post 302525478 by evelibertine on Thursday 26th of May 2011 07:58:30 PM
Old 05-26-2011
Copy and Paste Columns in a Tab-Limited Text file

I have this text file with a very large number of columns (10,000+) and I want to move the first column to the position of the six column so that the text file looks like this:

Before cutting and pasting
ID Family Mother Father Trait Phenotype
aaa bbb ccc ddd eee ddd
fff ggg hhh iii jjj ggg


Family Mother Father Trait ID Phenotype
bbb ccc ddd eee aaa ddd
ggg hhh iii jjj fff ggg

It is a tab-limited text file. How do I achieve this? Thank you!
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Copy/Paste text as commands in AIX

Hello, I'm absolutely new to this world... but I've a problem with a terminal connected via PuTTY (or Termlite) to an AIX 5.1 application. The problem: I need to paste from clipboard a text containing both input text strings and special keys as ESC, Arrows and so on, to execute in the AIX... (1 Reply)
Discussion started by: Daniele11
1 Replies

2. Shell Programming and Scripting

Copy Limited rows from one file to another

Hi, The file contains 1000 of rows can you please let me know How to copy 1-10 and 30-40 rows from one file to another. thanks :) (3 Replies)
Discussion started by: ravi214u
3 Replies

3. Solaris

Copy and paste text from a word document into a txt file in vi

Hello, Can anybody please tell me how we can copy and paste text from a word document into a text file that we are editing in vi? Is it possible to do that while we are editing the text file in vi in insert mode? Thanks, (3 Replies)
Discussion started by: Pouchie1
3 Replies

4. Shell Programming and Scripting

to parse (or grep) a number from a datafile and write it to tab limited file

Hi All, I have a folder that contain 100's of subfolders namely: Main folder -> GHFG - Subfoders ->10 100 234 102 345 .. .. ... (2 Replies)
Discussion started by: Lucky Ali
2 Replies

5. UNIX for Dummies Questions & Answers

How to convert text to columns in tab delimited text file

Hello Gurus, I have a text file containing nearly 12,000 tab delimited characters with 4000 rows. If the file size is small, excel can convert the text into coloumns. However, the file that I have is very big. Can some body help me in solving this problem? The input file example, ... (6 Replies)
Discussion started by: Unilearn
6 Replies

6. 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

7. 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

8. Shell Programming and Scripting

Make copy of text file with columns removed (based on header)

Hello, I have some tab delimited text files with a three header rows. The headers look like, (sorry the tabs look so messy). index group Name input input input input input input input input input input input... (9 Replies)
Discussion started by: LMHmedchem
9 Replies

9. Shell Programming and Scripting

Copy and paste text inside a xml file

I have a really big XML file. I need copy the value of one tag inside another one tag. I try to publish one example. <channel update="i" site="merge-xmltv" site_id="" xmltv_id="Rai 1">Rai 1</channel> <channel update="i" site="merge-xmltv" site_id="" xmltv_id="Rai 1 +2HD">Rai 1... (6 Replies)
Discussion started by: Tapiocapioca
6 Replies

10. Shell Programming and Scripting

Bash copy and paste text in file from one position to another

Hi I have a text file with lines beginning with 71303, 71403, 71602, I need to copy the 10 digit text at position 30 on lines beginning with 71303 (5500011446) to position 99 on every line beginning with 71602 (see example below), There may be many 71303 lines but I need the text copying to... (2 Replies)
Discussion started by: firefox2k2
2 Replies
PMNUMBERSTR(3)						     Library Functions Manual						    PMNUMBERSTR(3)

NAME
pmNumberStr, pmNumberStr_r - fixed width output format for numbers C SYNOPSIS
#include <pcp/pmapi.h> const char *pmNumberStr(double value); char *pmNumberStr_r(double value, char *buf, int buflen); cc ... -lpcp DESCRIPTION
pmNumberStr returns the address of a 8-byte buffer that holds a null-byte terminated representation of value suitable for output with fixed width fields. The pmNumberStr_r function does the same, but stores the result in a user-supplied buffer buf of length buflen, which should have room for at least 8 bytes. The value is scaled using multipliers in powers of ``one thousand'' (the decimal ``kilo'') and has a bias that provides greater precision for positive numbers as opposed to negative numbers. The format depends on the sign and magnitude of value as follows (d represents a decimal digit): +----------------------------------+---------+ | value range | format | +----------------------------------+---------+ | > 999995000000000 | inf? | |999995000000000 - 999995000000 | ddd.ddT | | 999995000000 - 999995000 | ddd.ddG | | 999995000 - 999995 | ddd.ddM | | 999995 - 999.995 | ddd.ddK | | 999.995 - 0.005 | ddd.dd | | 0.005 - -0.005 | 0.00 | | -0.005 - -99.95 | -dd.dd | | -99.995 - -99995 | -dd.ddK | | -99995 - -99995000 | -dd.ddM | | -99995000 - -99995000000 | -dd.ddG | | -99995000000 - -99995000000000 | -dd.ddT | | < -99995000000000 | -inf? | +----------------------------------+---------+ At the boundary points of the ranges, the chosen format will retain the maximum number of significant digits. NOTES
pmNumberStr returns a pointer to a static buffer and hence is not thread-safe. Multi-threaded applications should use pmNumberStr_r instead. SEE ALSO
printf(3) Performance Co-Pilot PCP PMNUMBERSTR(3)
All times are GMT -4. The time now is 09:44 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy