Sponsored Content
Top Forums Shell Programming and Scripting how to extract columns from a text file Post 302192004 by ihot on Monday 5th of May 2008 06:40:02 PM
Old 05-05-2008
cut -c14-17,48-55,61-70 works great

Hi,
cut -c14-17,48-55,61-70 works the way I wanted it.
I will try some of the others as well - just to educate myself.
Thanks again wizards. It is great to know that there are champs out there taking their valuable time to help others. This encourages me to do likewise.
Smilie
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extract text in 2 columns of output file.

Hello!! I have the text file with following format... --SubTotal-----------------------------------0--161---------------44---13739369-67--- --SubTotal-----------------------------------0--147---------------0----49643---1----... (2 Replies)
Discussion started by: Danish Shakil
2 Replies

2. Shell Programming and Scripting

Help, need to extract columns from file

I have huge fixed width, text file in unix box and I need to extract columns found between the width 105 and 200 and output it to a new file. Can anyone tell me how to extract it? Thanks for your help. (1 Reply)
Discussion started by: kiran2k
1 Replies

3. Shell Programming and Scripting

Extract Columns from file

Hi All, Could you please help me with following: I have to parse a .csv file. For example: If the csv file contains 3 columns, then i have to print the column names. The field separator is (comma). example.csv (contains 2 lines as follows) This is,a test file, for validation... (2 Replies)
Discussion started by: vfrg
2 Replies

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

5. UNIX for Dummies Questions & Answers

Removing columns from a text file that do not have any values in second and third columns

I have a text file that has three columns. But at the end of the text file, there are trailing lines that have missing second and third columns: 4 0.04972604 KLHL28 4 0.0497332 CSTB 4 0.04979822 AIF1 4 0.04983331 DECR2 4 0.04990344 KATNB1 4 4 4 4 How can I remove the trailing... (3 Replies)
Discussion started by: evelibertine
3 Replies

6. Shell Programming and Scripting

Command to extract all columns except the last few from a txt file

hello, i have publicly available txt file with little less than 300000 rows. i want to extract from column 1 to column 218 and save it in another text file. i use the cut command but the file is saved with multiple rows from the source file onto a single row in the destination. basically it is... (6 Replies)
Discussion started by: madrazzii
6 Replies

7. Shell Programming and Scripting

How to concatenate 2-columns by 2 -columns for a text file?

Hello, I want to concatenate 2-columns by 2-columns separated by colon. How can I do so? For example, I have a text file containing 6 columns separated by tab. I want to concatenate column 1 and 2; column 3 and 4; column 5 and 6, respectively, and put a colon in between. input file: 1 0 0 1... (10 Replies)
Discussion started by: huiyee1
10 Replies

8. UNIX for Dummies Questions & Answers

Extract spread columns from large file

Dear all, I want to extract around 300 columns from a very large file with almost 2million columns. There are no headers, but I can find out which column numbers I want. I know I can extract with the function 'cut -f2' for example just the second column but how do I do this for such a large... (1 Reply)
Discussion started by: fndijk
1 Replies

9. Shell Programming and Scripting

Extract columns into seperate file

I have a comma delimited file as per the one below and I am currently extracting the values in 2 columns (COL1 & COL6) to produce a smaller trimmed down version of the file which only contains the columns we need; COL1,COL2,COL3,COL4,COL5,COL6,COL7,COL8,COL9... (1 Reply)
Discussion started by: Ads89
1 Replies

10. Shell Programming and Scripting

Match Columns in one file and extract columns from another file

Kindly help merging information from two files with the following data structure. I want to match for the CHR-SNP in Foo and get the columns that match from CHROM-rsID Fields 1 & 2 of foo may have duplicates, however, a joint key of Fields $1$2$3$4 is unique. Also would be helpful to clean up... (4 Replies)
Discussion started by: genehunter
4 Replies
FLVTOOL2(1)						      General Commands Manual						       FLVTOOL2(1)

NAME
flvtool2 - a manipulation tool for flash video files SYNOPSIS
flvtool2 [-ACDPUVaciklnoprstvx]...[-key:value]...in-path|stdin[out-path|stdout] DESCRIPTION
If out-path is omitted, in-path will be overwritten. In-path can be a single file, or a directory. If in-path is a directory, out-path has to be likewise, or can be omitted. Directory recursion is controlled by the -r switch. You can use stdin and stdout keywords as in- and out-path for piping or redirecting. Chain commands like that: -UP (updates FLV file than prints out meta data) COMMANDS
-A Adds tags from -t tags-file -C Cuts file using -i inpoint and -o outpoint -D Debugs file (writes a lot to stdout) -H Helpscreen will be shown -P Prints out meta data to stdout -U Updates FLV with an onMetaTag event SWITCHES
-a Collapse space between cut regions -c Compatibility mode calculates some onMetaTag values differently -key:value Key-value-pair for onMetaData tag (overwrites generated values) -i timestamp Inpoint for cut command in miliseconds -k Keyframe mode slides onCuePoint(navigation) tags added by the add command to nearest keyframe position -l Logs FLV stream reading to stream.log in current directory -n Number of tag to debug -o timestamp Outpoint for cut command in miliseconds -p Preserve mode only updates FLVs that have not been processed before -r Recursion for directory processing -s Simulation mode never writes FLV data to out-path -t path Tagfile (MetaTags written in XML) -v Verbose mode -x XML mode instead of YAML mode SEE ALSO
/usr/share/doc/flvtool2/examples/tags.xml http://www.inlet-media.de/flvtool2 AUTHOR
flvtool2 was written by Norman Timmler <norman.timmler@inlet-media.de> This manual page was written by Todd Troxell <ttroxell@debian.org>, for the Debian project (but may be used by others). August 24, 2007 FLVTOOL2(1)
All times are GMT -4. The time now is 10:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy