sort string with delimiter as string in unix

Question

I have some data in the following format::

Info-programNumber!/TvSource/11100001_233a_32c0/13130^Info-channelName!5 USA^Info-Duration!1575190^Info-programName!CSI: ab cd

Delimiter = Info-

I tried to sort the string based on the delimiter in ascending order. But none of my solutions are working.

Expected Result:

Info-channelName!5 USA^Info-Duration!1575190^Info-programName!CSI: ab cd^Info-programNumber!/TvSource/11100001_233a_32c0/13130

Is there any command that will allow me to do this or do i need to write an awk script to iterate over the string and sort it?

isn't the delimiter ^ ?

Karoly Horvath
– Karoly Horvath

2013-06-28 11:21:43 +00:00
Commented Jun 28, 2013 at 11:21 — Karoly Horvath
– Karoly Horvath, Commented Jun 28, 2013 at 11:21

Karoly Horvath · Accepted Answer · 2013-06-28 11:35:47Z

3

Temporarily split the info into multiple lines so you can sort:

tr ^ \\n | sort | tr \\n ^

Note: if you have multiple entries, you have to write a loop, which processes it per line.. with huge datasets this is probably not a good idea (too slow), in which case pick a programming language.. but you were asking about the shell...

edited Jun 28, 2013 at 11:35

answered Jun 28, 2013 at 11:24

Karoly Horvath

96.7k11 gold badges123 silver badges181 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

anubhava · Accepted Answer · 2013-06-28 11:36:45Z

0

Can be done in awk itself:

awk -F "^" '{OFS="^"; for (i=1; i<=NF; i++) a[i]=$i} 
          END {n=asort(a, b); for(i=1; i<=n; i++) printf("%s%s", b[i], FS); print ""}' file

answered Jun 28, 2013 at 11:36

anubhava

790k67 gold badges603 silver badges671 bronze badges

1 Comment

anubhava Over a year ago

If this answer helped you solve your problem, please consider marking it as "accepted", so users facing a similar problem in the future will be able to see it easily.

Collectives™ on Stack Overflow

sort string with delimiter as string in unix

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related