Transposing a huge space delimited file Post: 302765377

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Searching for text in a Space delimited File

Hi I am trying to search a firewall syslog space delimeted file for all of the different tcp and udp destination ports. I know that grep will find lines that contain specific text. And I have tried using the the the cut command to cut out of the file certain colums. However the test I am...

2. UNIX for Dummies Questions & Answers

Converting Space delimited file to Tab delimited file

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

3. UNIX for Dummies Questions & Answers

Deleting columns from a space delimited text file

I have a space delimited text file with 1,000,000+ columns and 100 rows. I want to delete columns 2 through 5 (2 and 5) included from the text file. How do I do that? Thanks.

4. Shell Programming and Scripting

How to convert a space delimited file into a pipe delimited file using shellscript?

Hi All, I have space delimited file similar to the one as shown below.. I need to convert it as a pipe delimited, the values inside the pipe delimited file should be as highlighted... AA ATIU2345098809 009697 005374 BB ATIU2345097809 005445 006518 CC ATIU9685098809 003215 003571 DD...

5. UNIX for Dummies Questions & Answers

Changing only the first space to a tab in a space delimited text file

Hi, I have a space delimited text file but I only want to change the first space to a tab and keep the rest of the spaces intact. How do I go about doing that? Thanks!

6. Shell Programming and Scripting

How to make tab delimited file to space delimited?

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.

7. Shell Programming and Scripting

Converting varied space delimited file to Pipedemilited

Hi all, I have source file, data looks like 12345 abc def 01 / 001200 C 2000 12345 abc def 01 / 001200 C 2500 12345 abcd def 01 / 001200 C 3500 18945 xyz pqr 01 / 009900 D 4000 5000 2800 9900 Expected ouput...

8. Shell Programming and Scripting

Remove space before numbers in delimited file

Hi, I have a file which looks like this FORD|1333-1| 10000100010203| 100040507697|0002|356.45|5555| SSSSY|KKKKM|1000005|10| N096|10043| C987 I need the output to look like this FORD|1333-1|10000100010203|100040507697|0002|356.45|5555| SSSSY|KKKKM|1000005|10| N096|10043| C987 The leading...

9. Shell Programming and Scripting

Output file with <Tab> or <Space> Delimited

Input file: xyz,pqrs.lmno,NA,NA,NA,NA,NA,NA,NA abcd,pqrs.xyz,NA,NA,NA,NA,NA,NA,NA Expected Output: xyz pqrs.lmno NA NA NA NA NA NA NA abcd pqrs.xyz NA NA NA NA NA NA NA Command Tried so far: awk -F"," 'BEGIN{OFS=" ";} {print}' $File_Path/File_Name.csv Issue:...

10. Shell Programming and Scripting

Help/Advise please for converting space delimited string variable to comma delimited with quote

Hi, I am wanting to create a script that will construct a SQL statement based on a a space delimited string that it read from a config file. Example of the SQL will be For example, it will read a string like "AAA BBB CCC" and assign to a variable named IN_STRING. I then concatenate...

LEARN ABOUT DEBIAN

cdbsplit

COOKIETOOL(6)							   Games Manual 						     COOKIETOOL(6)

NAME

       cdbsplit - program to operate cookie (fortune) database

SYNOPSIS

       cdbsplit [options] <cookie-database> <hitfile>

DESCRIPTION

       This manual page documents briefly the cdbsplit command.

       This  manual  page  was written for the Debian GNU/Linux distribution because the original program does not have a manual page. Instead, it
       has some plain text documentation, see below.

       cdbsplit is a program that can be used to operate cookie database in various formats, the default is standard fortune(6) format, i.e.  list
       of  'cookies'  delimited with line containing a single percent ('%') char . With 'cdbsplit' you can split cookie database, or extract parts
       of it depending on various criteria.

OPTIONS

       A summary of options is included below. For a complete description, see the documentation in  /usr/share/doc/cookietool	directory.   NOTE,
       that  default  behaviour  is  to  overwrite existing database with its reduced version, so the cookies are MOVED to hitfile. The hitfile is
       never overwritten, but may be appended to.

       [nothing]
	      Shows summary of options.

       -c     case-sensitive comparisons (for both keywords and groups)

       -d[0-3]
	      how fussy about word delimiters? (default: 2)

       -k<keyword>
	      optional keyword

       -K<keyword>
	      mandatory keyword (use both of them to form boolean expressions)

       -l<min_lines>
	      minimal cookie length (in lines)

       -L<max_lines>
	      maximal cookie length (in lines)

       -w<chars>
	      minimal line width (in chars)

       -W<chars>
	      maximal line width (in chars)

       -n<min_number>
	      start at cookie <min_number>

       -N<max_number>
	      stop after <max_number> cookie

       -m<chars>
	      find groups of cookies starting with <n> matching characters (database must be sorted for this to make sense!)

       -x     extract only, don't modify <cookie-database>

       -a     append, don't overwrite <hitfile> if such a filename exists

       -f[0-3]
	      input file format - -f3: cookies are separated by '%%' lines; -f2: cookies are separated by '%' lines (DEFAULT); -f1: each line is a
	      cookie; -f0: each word is a cookie.

SEE ALSO

       cookietool(6), cdbdiff(6)

BUGS

       None known.

AUTHOR

       Upstream  author  and  Aminet cookietool.lha package with AmigaOS binaries uploader is Wilhelm Noeker, <wnoeker@t-online.de>. Unix manpages
       (including this one) and makefile are maintained by Miros/law L. Baran <baran@debian.org>. This manual page uses  many  excerpts  from  the
       original README file.

								   May 19, 2001 						     COOKIETOOL(6)