Text file arrangement


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Text file arrangement
# 1  
Old 06-16-2005
Power Text file arrangement

Dear UNIX experts:

Hi, I have a text file which the contents are arranged vertically down, line by line.
How do use a loop (I think) to make it arrange in vertical arrangement with a tab delimitated and write to a new file?

Eg: of source file
Hello World
Good-day
Thanks
Welcome

The expected output :-
Hello World Good-day Thanks Welcome



Thanks in advance.
# 2  
Old 06-17-2005
Bug See this

Try this :

cat file.txt | sed 's/$/ /g' | tr -d "\n"


Cheers
Rahul
# 3  
Old 06-17-2005
How about

Code:
tr '\n' '\t' <inputfile >outputfile

Vino
# 4  
Old 06-17-2005
thanks for sharing... it don't even need a loop! Smilie
# 5  
Old 06-17-2005
I hv another question... if I want to seperate the data by two "**" in between, why the below don't work? Hv I miss out something? the output only has one '*' in between which I expect two Smilie


tr '\n' '**' < inputfile > outputfile


thanks
# 6  
Old 06-17-2005
Try this. I just escaped the *'s

Code:
tr '\n' '\*\*' <inputfile>outputfile


Havnt tested it tho'.

vino
# 7  
Old 06-17-2005
Quote:
Originally Posted by vino
Try this. I just escaped the *'s

Code:
tr '\n' '\*\*' <inputfile>outputfile


Havnt tested it tho'.

vino

They will not work. tr stands for translate a character. You can translate a character into another character. But not into 2 characters. (Am i wrong ?)

Reason for the above not working, the \n is replaced with the first * only. If there is another character in SET1, then it will be replaced with the corresponsing character in SET2.

Here is a sed solution will convert your outputfile from the tr command into the pattern you need.

Code:
sed -e 's/\(\*\)/\1\1/g' outputfile

Vino

Last edited by vino; 06-17-2005 at 05:54 AM..
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Match text to lines in a file, iterate backwards until text or text substring matches, print to file

hi all, trying this using shell/bash with sed/awk/grep I have two files, one containing one column, the other containing multiple columns (comma delimited). file1.txt abc12345 def12345 ghi54321 ... file2.txt abc1,text1,texta abc,text2,textb def123,text3,textc gh,text4,textd... (6 Replies)
Discussion started by: shogun1970
6 Replies

2. Shell Programming and Scripting

Retreive data with arrangement

Hi all I have following part of a big file TTDS00002 Synonyms M1 receptor TTDS00002 Disease Alzheimer's disease TTDS00002 Disease Bronchospasm (histamine induced) TTDS00002 Disease Cognitive deficits TTDS00002 Disease Schizophrenia TTDS00002 Function The muscarinic acetylcholine... (2 Replies)
Discussion started by: kareena
2 Replies

3. UNIX for Dummies Questions & Answers

Tar command to preserve the folder/file arrangement

Hi, I do have question for un tar a file. I have several 'tar'ed files. For example: SRS.tar.bz2. I was trying to untar them in a linux server using the command: tar xvjf SRS.tar.bz2 It worked perfectly. but when I open this file in my mac computer all the files are extracted into a... (7 Replies)
Discussion started by: Lucky Ali
7 Replies

4. UNIX for Advanced & Expert Users

Data re-arrangement

Hi I have a huge problem to solve ASAP. Can someone please help!!! My format is arranged in this format: It has three columns. LOGIN ALIAS REC_ID A BB1 0 A ... (1 Reply)
Discussion started by: Mapilo
1 Replies

5. Shell Programming and Scripting

directories and file arrangement in bash

im trying to write a script that will put files with different extensions into their specified directories In the directory are files of various types, i want to arrange the files on individual directories under their type. There are three distinct types of files: 1) Text documents - files with... (2 Replies)
Discussion started by: elginmulizwa
2 Replies

6. Shell Programming and Scripting

Re-arrangement of data

Dear Frineds, I have a flat file as follows ABCD ABDCWQE POIERAS ADSGASGFG GHJKFHD XBDFGHFGDH POIU IJPFG AFGJFPGOU A;DGUPGU SFSDFDSDFHDSF SDFGHSFDH I want this column to be converted into row like follows ABCD, ABDCWQE, POIERAS, ADSGASGFG, GHJKFHD, XBDFGHFGDH (6 Replies)
Discussion started by: anushree.a
6 Replies

7. UNIX for Dummies Questions & Answers

Help on file arrangement

Can anyone help me on this. I have a file that looks like this: color red green blue color pink yellow number one two gender male gender female The output would look like this: color red green blue pink yellow number one two gender male female I have over 5000 rows and i dont want... (5 Replies)
Discussion started by: kharen11
5 Replies

8. UNIX for Dummies Questions & Answers

Data arrangement

10 2 1 2 3 4 5 6 7 8 20 3 2 1 3 2 9 8 2 1 Need the data to be arranged: 10 2 1 5 2 6 3 7 4 8 20 3 2 1 1 2 3 8 2 9 please help! (6 Replies)
Discussion started by: bobo
6 Replies

9. UNIX for Dummies Questions & Answers

Cell arrangement

I have a data file with hundreds of lines: I want to place a YES right below the line that say mydata....can someone please help! on the left is my the original data on the right the data format need to be: left > Right mydata > mydata yes > yesno > no mydata > mydata... (12 Replies)
Discussion started by: bobo
12 Replies

10. UNIX for Dummies Questions & Answers

Data arrangement

I have these following data: Home Tom Member List 100 Yes 200 No Home Tom Member List 1 No 2 Yes Home Tome Member List 3 No 400 Yes I want my data to be consistants like this: (4 Replies)
Discussion started by: bobo
4 Replies
Login or Register to Ask a Question