Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Text order

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Text order
# 1  
Old 10-12-2011
Text order
Hello unix.com

I have a large text file in this format:

Code:
merali  guzman  34 vernon st 304        hartford        CT      Connecticut     6106  012-233-232 Working 13/14 100$
Morgan  Dvorak  5670 Echo Road  Excelsior       MN      Minnesota       5331 000-000-123 Sleeping 15/17 220$

How can I sort it like this:

Code:
Working|1314|100$|34 vernon st 304|hartford|Connecticut|6106|merali  guzman|012-233-232|
Sleeping|1517|220$|5670 Echo Road|Excelsior|Minnesota|5331|Morgan  Dvorak|000-000-123

Thanks.
Last edited by radoulov; 10-12-2011 at 10:47 AM.. Reason: Code tags!
# 2  
Old 10-12-2011
With difficultly, because there is not a fixed number of fields per line. First line have 14 fields, second line has 13 fields.

If you provide an algorithm on how to split the lines into the set of delimited fields that you want, that would help.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Order by 1

select to_char(cre_on, 'ddmm hh24'), proc_flg, count(*) from ib_prd.tb_ibmh_msg_log where message_type = 'DECHECK_OUT' and cre_on > to_date('27/08/2016 00:00:00', 'dd/MM/yyyy hh24:mi:ss') group by to_char(cre_on, 'ddmm hh24'), proc_flg order by 1; 1) what does order by 1 means 2) group by... (1 Reply)
Discussion started by: houmingc
1 Replies

2. Shell Programming and Scripting

Reversing text order of each line of a file in UNIX

My input is: hello how are you my chemistry book is lost what is up etc... And I want the output to be: you are how hello lost is book chemistry my up is what .... I found an earlier response to a similar question but it was not accurate as it required a certain string length for each line (2 Replies)
Discussion started by: Heidi Heweidy
2 Replies

3. UNIX for Dummies Questions & Answers

Appending a column of numbers in ascending order to a text file

I have a text file where I want to append a column of numbers in ascending orders. Input: 57 abc 25 def 32 ghi 54 jkl Output:57 abc 57 abc 1 25 def 2 32 ghi 3 54 jkl 4 How do I go about doing that? Thanks! (11 Replies)
Discussion started by: evelibertine
11 Replies

4. Shell Programming and Scripting

Column not in order

Hi, I was trying to have an output as below : 1 | 2 | 3 aaa | bbb | ccc | ccc | ccc ... (2 Replies)
Discussion started by: scottralf
2 Replies

5. UNIX for Dummies Questions & Answers

Merging all text files in the order which they recieved

Hi guru's :) I am new to UNIX. requirement is merging all text files from one folder in the order which they have received. EX: under /Test folder files received in certain intervals. abc.txt @ 1:00 AM 123.txt @ 2:00 AM xyz.txt @ 4:00 AM . . . 456.txt @ 10:00 PM ... (4 Replies)
Discussion started by: arund_01
4 Replies

6. Shell Programming and Scripting

Merging all text files in the order which they recieved

Hi There, I am new to UNIX. requirement is merging all text files from one folder in the order which they have received. EX: under /Test folder files received in certain intervals. abc.txt @ 1:00 AM 123.txt @ 2:00 AM xyz.txt @ 4:00 AM . . . 456.txt @ 10:00 PM so need to develop a... (3 Replies)
Discussion started by: arund_01
3 Replies

7. Shell Programming and Scripting

Order text by delimiters

I try order the content from file by delimiters. This is the text: interface Loopback0 description !!!RID RR_SLT ip address 172.31.128.19 255.255.255.255 interface GigabitEthernet0 description !!!P_SLT GI0/0/9 ip address 172.31.130.246 255.255.255.252 and the result that I need... (11 Replies)
Discussion started by: bobbasystem
11 Replies

8. Shell Programming and Scripting

Ascending order within text

I appreciate all the help that I've already received but am running into one problem. I can find how to add something before a file with ascending numbers but not like this. I basically have a file that looks like this: 100 101 102 103 104 I need to add the following before each line with... (5 Replies)
Discussion started by: kerpm
5 Replies

9. Shell Programming and Scripting

Order text display not correct.

My shell script below for import data to Oracle it run okay. but the text display not correct follow order command executed. =========================Shell Script code================= #!/bin/sh #directory = ${1-'pwd'} #run import data with SQLLoader runSQLLoader() { ... (2 Replies)
Discussion started by: raccsdl
2 Replies

10. UNIX for Dummies Questions & Answers

order by size

Hi all, I want to do a command that list all files from a directory e subdirectories order by size (MAX to MIN) Can you help me? Tkz (2 Replies)
Discussion started by: sliver
2 Replies
Login or Register to Ask a Question