Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Help! output format from vertical to horizontal

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help! output format from vertical to horizontal
# 15  
Old 08-09-2013
Alister - Executed the givne code, below is the output
Code:
awk ' !f{ff=$0; f=1} !x && NR%2 { if(!(f>1 && $0 ~ ff)){printf "%s\t", $0} if(f==1){f++;next}}
!(NR%2) { d=d" "$0 } $0 ~ ff {print "\n"d; x=1;d=""} END{print d} ' < $TEMP/$SCRIPT.emp > $TEMP/$SCRIPT.out8
output: 
awk: syntax error near line 1
awk: bailing out near line 1

2) Rudic - Executed the code given, below is the output
Output:
Code:
awk: syntax error near line 4
awk: bailing out near line 4

3) Ahamed,
Code:
awk ' !f{ff=$0; f=1} !x && NR%2 { if(!(f>1 && $0 ~ ff)){printf "%s\t", $0} if(f==1){f++;next}}
!(NR%2) { d=d" "$0 } $0 ~ ff {print "\n"d; x=1;d=""} END{print d} ' < $TEMP/$SCRIPT.emp 
output :
awk: syntax error near line 1
awk: bailing out near line 1

kinldy help.
Last edited by Scott; 08-09-2013 at 03:33 PM.. Reason: Code tags
# 16  
Old 08-09-2013
Please use code tags...

On Solaris, use nawk or /usr/xpg4/bin/awk
This User Gave Thanks to Scott For This Post:
rocky2013
# 17  
Old 08-09-2013
Quote:
Originally Posted by rocky2013
Alister - Executed the givne code, below is the output
Code:
awk ' !f{ff=$0; f=1} !x && NR%2 { if(!(f>1 && $0 ~ ff)){printf "%s\t", $0} if(f==1){f++;next}}
!(NR%2) { d=d" "$0 } $0 ~ ff {print "\n"d; x=1;d=""} END{print d} ' < $TEMP/$SCRIPT.emp > $TEMP/$SCRIPT.out8
output: 
awk: syntax error near line 1
awk: bailing out near line 1

That's not my code.

Mine works fine with your most recent data.
Code:
$ n=7 file=data

$ { awk 'NR==n*2 {exit} NR%2' n=$n "$file"; awk '!(NR%2)' "$file"; } | paste -d ' ' $(yes - | head -n $n)
name svc isCached isPrefetched sAccessLast sAccessTotal sRunning
COM.WM.ISEXTDC.PKGINIT:INIT init N N 2013-07-13 00:39:10 MEST 1 5
DSM_APPS_MANAGEMENT.BROKERCLIENTQUEUE_CLEANUP:CLEANUP cleanup N N 2013-08-03 16:14:19 MEST 1041 1

$ cat "$file"
name
COM.WM.ISEXTDC.PKGINIT:INIT
svc
init
isCached
N
isPrefetched
N
sAccessLast
2013-07-13 00:39:10 MEST
sAccessTotal
1
sRunning
5
name
DSM_APPS_MANAGEMENT.BROKERCLIENTQUEUE_CLEANUP:CLEANUP
svc
cleanup
isCached
N
isPrefetched
N
sAccessLast
2013-08-03 16:14:19 MEST
sAccessTotal
1041
sRunning
1

Regards,
Alister
Last edited by alister; 08-09-2013 at 03:58 PM..
# 18  
Old 08-09-2013
Scott - It worked for me

Alister - Am just checking what's wrong with the given code am unable to locate where the problem lies.

Code:
file=data
n=7
{ awk 'NR==n*2 {exit} NR%2' n=$n "$file"; awk '!(NR%2)' $file; } | paste -d ' ' $(yes - | head -n $n)
cat "$file"

Output:
Code:
awk: syntax error near line 1
awk: bailing out near line 1
awk: syntax error near line 1
awk: bailing out near line 1
name
COM.WM.ISEXTDC.PKGINIT:INIT
svc
init
isCached
N
isPrefetched
N
sAccessLast
2013-07-13 00:39:10 MEST
sAccessTotal
1
sRunning
5
name
DSM_APPS_MANAGEMENT.BROKERCLIENTQUEUE_CLEANUP:CLEANUP
svc
cleanup
isCached
N
isPrefetched
N
sAccessLast
2013-08-03 16:14:19 MEST
sAccessTotal
1041
sRunning
1

Last edited by Scott; 08-10-2013 at 02:15 AM.. Reason: Code tags
# 19  
Old 09-17-2013
Hi, Jotne, RudiC & alister
Am sorry for re-opening this thread again.
Am in need of your help to get the desired output.

Code:
name
SECURITY.SERVICES.CONFIG:GETVALUE
isPrefetched
N
sAccessLast
2013-09-13 10:50:13 MEST
sAccessTotal
1
sRunning
cHitLast
name
PUBLIC.SERVER:INVOKE
isPrefetched
N
sAccessLast
2013-09-17 15:02:05 MEST
sAccessTotal
713991
sRunning
1
name
PUBLIC.STRING:CONVERTTOSTRING
isPrefetched
N
sAccessLast
2013-09-17 03:01:54 MEST
sAccessTotal
961
sRunning
cHitLast

1) I have data which has more thand 10,000 lines with the above same pattern.
2) I was checking the value of parameter 'sRunning' which should be a numerical value ( i.e, greater than 0 )
3) Here in the above live data the parameter(sRunning) is 'cHitLast and in the second case it is 1
4) I need to print the above 4 + 1(including sRunning ) values whereever the sRunning has a value greater than 0 ( zero) example shown below
5) Need to ignore if the value of sRunning which is other than numerical.
For the above code the output should be as below
Code:
name     isPrefetched   sAccessLast      sAccessTotal  sRunning
PUBLIC.SERVER:INVOKE  N       2013-09-17 15:02:05 MEST                    713991 1

This was code given by jote and it worked for some part but latter am not able to get the desired output.
Code:
nawk ' !f{ff=$0; f=1} !x && NR%2 { if(!(f>1 && $0 ~ ff)){printf "%s\t" "\t", $0} if(f==1){f++;next}}
  !(NR%2) { d=d" "$0 } $0 ~ ff {print "\n"d; x=1;d=""} END{print d} '

Thanks a lot for your support.
Last edited by Scott; 09-17-2013 at 11:29 AM.. Reason: Use CODE tags for code blocks, not ICODE tags
# 20  
Old 09-20-2013
Hi.

Comments:

1) The post # 19 although seeming to be similar is really a different topic. If so, then it should be in a different (new) thread. That may be why there have been no responses for 2 days.

2) I strongly agree with alister in post 13 about posted data needing to be a representative sample, and not some simplified form.

3) For the question on general, the utility pr can generally handle such tasks. For example, given that the data would be on a file data1, the command on Debian GNU/Linux 5.0.8 (lenny):
Code:
pr -3 -l2 -T -s" " data1

produces
Code:
empname empid design
robert 787 consultant
empname empid design
alex 898 advocate

The idea being that columns can be specified as well as the length of a page (in this case 2 lines, no titles, no headers, no footers). See man pr for details.

Best wishes ... cheers, drl
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Print vertical to horizontal

Hi Masters, I need help to change my vertical data to horisontal input 2015-04-13|JS|741667 2015-04-13|JSJ|2272 2015-04-13|TMS|107099 2015-04-12|JMD|47945 2015-04-13|TM|760024 2015-04-13|JM|484508 2015-04-14|JMJ|318 2015-04-14|JSD|54436 2015-04-13|JM|15410 Output... (2 Replies)
Discussion started by: radius
2 Replies

2. UNIX for Dummies Questions & Answers

Change Vertical to Horizontal

I need to change data from vertical to horizontal but with condition input USA|80 AUS|40 BRA|33 VEGAS|40 KENTUCKY|50 NEWYORK|21 DARWIN|33 ADELAIDE|21 SAOPAOLO|44 RIO|89 GAPIZA|44 BENFLEX|32 AXIS|44 ACRE|56 HEIGHT|22 (5 Replies)
Discussion started by: radius
5 Replies

3. Shell Programming and Scripting

How do i do the vertical to horizontal??

51009 8746 8912 17986 20315 24998 5368 38934 7805 8566 (4 Replies)
Discussion started by: nikhil jain
4 Replies

4. Shell Programming and Scripting

awk in horizontal and vertical math

Based on input ail,UTT,id1_0,COMBO,21,24,21,19,85 al,UTHAST,id1_0,COMBO,342,390,361,361,1454 and awk code as awk -F, '{ K=0; for(i=NF; i>=(NF-4); i--) { K=K+$i; J=J+$i;} { print K } } END { for ( l in J ) printf("%s ",J); }' I'm trying to add columns and lines in single line. line... (6 Replies)
Discussion started by: busyboy
6 Replies

5. Shell Programming and Scripting

Need perl or shell script to sort vertical lines to horizontal line in csv format

Need perl or shell script to sort vertical lines to horizontal line in csv format My file like below ------------------------- ================================================================================ PATH PINKY1000#I1-1-ZENTA1000-2#I7-1-ASON-SBR-UP-943113845 ... (4 Replies)
Discussion started by: sreedhargouda.h
4 Replies

6. Shell Programming and Scripting

Vertical And Horizontal Pivoting

Hi All, My Input data is: A=1 B=2 My desired Output should be: A|B 1|2 Thanks in advance... (3 Replies)
Discussion started by: kmsekhar
3 Replies

7. UNIX for Dummies Questions & Answers

vertical to horizontal

dear all, i'm new to unix and i try to figure out the best case for making list of vertical text to become horizontal and skip the line 1 and 2. example text : Data DATE XXXXX MAX 47 53 49 51 48 48 7 46 51 8 25 (6 Replies)
Discussion started by: andrisetia
6 Replies

8. UNIX for Dummies Questions & Answers

Horizontal to vertical

Hi, Silly question, if I have an excel file that looks something like this: ................. Subject 1 Subject 2 Subject 3 Subject 4 Fever..............13...........9.............23..........14 Headache.........2............12...........18..........23... (3 Replies)
Discussion started by: Xterra
3 Replies

9. Shell Programming and Scripting

Formatting isql output to horizontal format

Hi I am formatting informix isql output(vertical) to horizontal format. Suppose I have the following content in the flat file from isql output - item_nbr 0 usfn_label Subscriber Class usfn_name SBCLASS usfn_value bl5 item_nbr 1 usfn_label Switch Name usfn_name switchName... (2 Replies)
Discussion started by: nsinha
2 Replies

10. Shell Programming and Scripting

combine files in horizontal way, not vertical.

Hi Everyone, I have three files. FileA: aaaa aaaa bb ccc FileB: 21 2 FileC: eeeeeee e eee ee Would like to combine three of them, not like cat, to cat three files, but the output should be like: (3 Replies)
Discussion started by: jimmy_y
3 Replies
Login or Register to Ask a Question