Sponsored Content
Top Forums Shell Programming and Scripting Column to row and position data in a text file Post 303004297 by manihi on Friday 29th of September 2017 05:17:46 AM
Old 09-29-2017
"ZZZZ" is a fixed text to insert
the file is always 7 lines and the rule is to move line 7 to the top and then print lines 1 and 4, 2 and 5 and 3 and 6 comma-separated without space. No text or numeric controls are required

RudiC thanks for your time
 

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... (9 Replies)
Discussion started by: aYankeeFan
9 Replies

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 Replies)
Discussion started by: npatwardhan
3 Replies

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 Replies)
Discussion started by: baluchen
4 Replies

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... (2 Replies)
Discussion started by: jl487
2 Replies

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! (5 Replies)
Discussion started by: evelibertine
5 Replies

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 Replies)
Discussion started by: ckaramsetty
7 Replies

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. (4 Replies)
Discussion started by: sktkpl
4 Replies

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 (5 Replies)
Discussion started by: evelibertine
5 Replies

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 (4 Replies)
Discussion started by: cdfd123
4 Replies

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 (3 Replies)
Discussion started by: Lini
3 Replies
Mined  is a simple screen editor.  At any instant, a window of 24
lines is visible on the screen.  The current position in the file
is shown by the cursor.  Ordinary characters typed in are insert-
ed at the cursor.  Control characters and  keys  on  the  numeric
keypad	(at the right-hand side of the keyboard) are used to move
the cursor and perform other functions.  Commands exist  to  move
forward  and backward a word, and delete words either in front of
the cursor or behind it.  A word in this context is a sequence of
characters  delimited  on  both  ends by white space (space, tab,
line feed, start of file, or end  of  file).   The  commands  for
deleting  characters and words also work on line feeds, making it
possible to join two consecutive lines by deleting the line  feed
between  them.	 The  editor  maintains one save buffer (not dis-
played).  Commands are present to move text from the file to  the
buffer, from the buffer to the file, and to write the buffer onto
a new file.  If the edited text cannot be written out  due  to	a
full disk, it may still be possible to copy the whole text to the
save buffer and then write it to a different file on a	different
disk with CTRL-Q.  It may also be possible to escape from the ed-
itor with CTRL-S and remove some files.   Some	of  the  commands
prompt	for  arguments	(file names, search patterns, etc.).  All
commands that might result in  loss  of  the  file  being  edited
prompt to ask for confirmation.  A key (command or ordinary char-
acter) can be repeated times by typing where is the  escape  key.
Forward  and  backward searching requires a regular expression as
the search pattern.  Regular expressions follow the same rules as
in  the  editor,  These  rules	can be stated as: Any displayable
character matches itself.  . (period) matches any  character  ex-
cept line feed.  ^ (circumflex) matches the start of the line.	$
(dollar sign) matches the end of the line.  c matches the  char-
acter  c  (including  period, circumflex, etc).  [string] matches
any of the characters in the string.  [^string]  matches  any  of
the  characters  except  those	in the string.	[x-y] matches any
characters between x and y (e.g., [a-z]).  Pattern*  matches  any
number	of  occurrences of pattern.  Some examples of regular ex-
pressions are:
  The boy   matches the string The boy
  ^$	    matches any empty line.
  ^.$	    matches any line containing exactly 1 character
  ^A.*.$   matches any line starting with an A,  ending  with	a
	    period.
  ^[A-Z]*$  matches  any line containing only capital letters (or
	    empty).
  [A-Z0-9]  matches any line containing either a  capital  letter
	    or a digit.
  .*X$	    matches any line ending in X
  A.*B	    matches any line containing an A and then a B

Control characters cannot be entered into a file simply by typing
them because all of them are editor commands.  To enter a control
character,  depress  the ALT key, and then while holding it down,
hit the ESC key.  Release both ALT and ESC and type  the  control
character.   Control  characters  are displayed in reverse video.
The commands are as follows.

CURSOR MOTION
arrows Move the cursor in the indicated direction CTRL-A Move cursor to start of current line CTRL-Z Move cursor to end of current line CTRL-^ Move cursor to top of screen CTRL-_ Move cursor to end of screen CTRL-F Move cursor forward to start of next word CTRL-B Move cursor backward to start of previous word SCREEN MOTION
Home key Move to first character of the file End key Move to last character of the file PgUp key Scroll window up 23 lines (closer to start of the file) PgDn key Scroll window down 23 lines (closer to end of the file) CTRL-U Scroll window up 1 line CTRL-D Scroll window down 1 line MODIFYING TEXT
Del key Delete the character under the cursor Backspace Delete the character to left of the cursor CTRL-N Delete the next word CTRL-P Delete the previous word CTRL-T Delete tail of line (all characters from cursor to end of line) CTRL-O Open up the line (insert line feed and back up) CTRL-G Get and insert a file at the cursor position BUFFER OPERATIONS
CTRL-@ Set mark at current position for use with CTRL-C and CTRL-K CTRL-C Copy the text between the mark and the cursor into the buffer CTRL-K Delete text between mark and cursor; also copy it to the buffer CTRL-Y Yank contents of the buffer out and insert it at the cursor CTRL-Q Write the contents of the buffer onto a file MISCELLANEOUS
numeric + Search forward (prompts for regular expression) numeric - Search backward (prompts for regular expression) numeric 5 Display the file status CTRL-] Go to specific line CTRL-R Global replace pattern with string (from cursor to end) CTRL-L Line replace pattern with string CTRL-W Write the edited file back to the disk CTRL-X Exit the editor CTRL-S Fork off a shell (use CTRL-D to get back to the edi- tor) CTRL- Abort whatever the editor was doing and wait for com- mand CTRL-E Erase screen and redraw it CTRL-V Visit (edit) a new file Mined was designed by Andy Tanenbaum and written by Michiel Huis- jes.
All times are GMT -4. The time now is 02:30 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy