Column to row and position data in a text file Post: 303004293

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Changing the column for a row in a text file and adding another row

Hi, I want to write a shell script which increments a particular column in a row from a text file and then adds another row below the current row with the incremented value . For Eg . if the input file has a row : abc xyz lmn 89 lm nk o p I would like the script to create something like...

2. Shell Programming and Scripting

Convert row data to column data

Hi Guys, I have a file as follows: a 1 b 786 c 90709 d 99 a 9875 b 989 c 887 d 111 I want: a 1 9875 b 786 989

3. Shell Programming and Scripting

row to column and position data in to fixed column width

Dear friends, Below is my program and current output. I wish to have 3 or 4 column output in order to accomodate in single page. i do have subsequent command to process after user enter the number. Program COUNT=1 for MYDIR in `ls /` do VOBS=${MYDIR} echo "${COUNT}. ${MYDIR}" ...

4. Shell Programming and Scripting

Moving data from a specified column/row to another column/row

Hello, I have an input file like the following: 11_3_4 2_1_35 3_15__ _16989 Where '_' is a space. The data is in a table. Is there a way for the program to prompt the user for x1,y1 and x2,y2, where x1,y1 is the desired number (for example x=6 y=4 is a value of 4) and move to a desired spot...

5. UNIX for Dummies Questions & Answers

How do you delete cells from a space delimited text file given row and column number?

How do you delete cells from a space delimited text file given row and column number? Letś say the row number is r and the column number is c. Thanks!

6. Shell Programming and Scripting

Sort a the file & refine data column & row format

cat file1.txt field1 "user1": field2:"data-cde" field3:"data-pqr" field4:"data-mno" field1 "user1": field2:"data-dcb" field3:"data-mxz" field4:"data-zul" field1 "user2": field2:"data-cqz" field3:"data-xoq" field4:"data-pos" Now i need to have the date like below. i have just...

7. UNIX for Advanced & Expert Users

Convert column data to row data using shell script

Hi, I want to convert a 3-column data to 3-row data using shell script. Any suggestion in this regard is highly appreciated. Thanks.

8. UNIX for Dummies Questions & Answers

Adding a column to a text file with row numbers

Hi, I would like to add a new column containing the row numbers to a text file. How do I go about doing that? Thanks! Example input: A X B Y C D Output: A X 1 B Y 2 C D 3

9. UNIX for Dummies Questions & Answers

awk to print first row with forth column and last row with fifth column in each file

file with this content awk 'NR==1 {print $4} && NR==2 {print $5}' file The error is shown with syntax error; what can be done

10. Shell Programming and Scripting

Print every alternate column in row in a text file

Hi, I have a comma separated file. I would like to print every alternate columns into a new row. Example input file: Name : John, Age : 30, DOB : 30-Oct-2018 Example output: Name,Age,DOB John,30,30-Oct-2018

LEARN ABOUT REDHAT

prunehistory

PRUNEHISTORY(8) 					      System Manager's Manual						   PRUNEHISTORY(8)

NAME

       prunehistory - remove file names from Usenet history file

SYNOPSIS

       prunehistory [ -f filename ] [ -p ]

DESCRIPTION

       Prunehistory  modifies  the  history(5)	text file to ``remove'' a set of filenames from it.  The filenames are removed by overwriting them
       with spaces, so that the size and position of any following entries does not change.

       Prunehistory reads the standard input.  The input is taken as a set of lines.  Blank lines and lines starting with a  number  sign  (``#'')
       are ignored.  All other lines are should consist of a Message-ID followed by zero or more filenames.

       The  Message-ID	is  used as the dbz(3) key to get an offset into the text file.  If no filenames are mentioned on the input line, then all
       filenames in the text are ``removed.''  If any filenames are mentioned, they are converted into the history file notation.  If they  appear
       in the line for the specified Message-ID then they are removed.

       Since innd(8) only appends to the text file, prunehistory does not need to have any interaction with it.

OPTIONS

       -p     Prunehistory will normally complain about lines that do not follow the correct format.  If the ``-p'' flag is used, then the program
	      will silently print any invalid lines on its standard output.  (Blank lines and comment lines are also passed through.)  This can be
	      useful when prunehistory is used as a filter for other programs such as reap.

       -f     The default name of the history file is <pathdb in inn.conf>/history; to specify a different name, use the ``-f'' flag.

HISTORY

       Written by Rich $alz <rsalz@uunet.uu.net> for InterNetNews.  This is revision 1.7, dated 1998/04/09.

SEE ALSO

       dbz(3), history(5), inn.conf(5), innd(8).

																   PRUNEHISTORY(8)