Number of columns in xml file | Unix Linux Forums | Shell Programming and Scripting

  Go Back    


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

Number of columns in xml file

Shell Programming and Scripting


Closed Thread    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 01-08-2013
victory victory is offline
Registered User
 
Join Date: Jan 2012
Last Activity: 17 June 2014, 9:39 PM EDT
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Number of columns in xml file

How to find the number of columns in xml file.

i tried following command.

Code:
#!bin/ksh
cat $1 | grep -c "</mdm:attribute>"
exit 0

but i am not getting accurate result which is not matching with the manual count.
data format :

Code:
<mdm:attribute> value </mdm:attribute>


Last edited by Franklin52; 01-08-2013 at 08:36 AM.. Reason: Please use code tags for data and code samples
Sponsored Links
    #2  
Old 01-08-2013
pravin27 pravin27 is offline Forum Advisor  
Advisor
 
Join Date: Sep 2009
Last Activity: 18 December 2014, 7:06 AM EST
Location: ./India/Banglore
Posts: 1,213
Thanks: 54
Thanked 272 Times in 265 Posts
Hope this will help you ..


Code:
perl -nle 'print $1 if /<\/(.+?)\>/g' file.xml | wc -l

Sponsored Links
    #3  
Old 01-08-2013
victory victory is offline
Registered User
 
Join Date: Jan 2012
Last Activity: 17 June 2014, 9:39 PM EDT
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
It's not perl script it is UNIX ibm aix.
    #4  
Old 01-08-2013
radoulov's Avatar
radoulov radoulov is offline Forum Staff  
Moderator
 
Join Date: Jan 2007
Last Activity: 19 December 2014, 9:35 AM EST
Location: Варна, България / Milano, Italia
Posts: 5,675
Thanks: 184
Thanked 620 Times in 578 Posts
Quote:
Originally Posted by victory View Post
... it is UNIX ibm aix.
Did you try to execute the above command?
Sponsored Links
    #5  
Old 01-08-2013
Corona688 Corona688 is offline Forum Staff  
Mead Rotor
 
Join Date: Aug 2005
Last Activity: 21 December 2014, 8:10 PM EST
Location: Saskatchewan
Posts: 20,041
Thanks: 856
Thanked 3,459 Times in 3,230 Posts
xml doesn't have "columns" per se so I'm not really sure what you want. Could you show a more complete input file and what you're expecting to get from it?
Sponsored Links
    #6  
Old 01-08-2013
rdrtx1 rdrtx1 is offline
Registered User
 
Join Date: Sep 2012
Last Activity: 16 December 2014, 11:19 AM EST
Location: Houston, Texas, USA
Posts: 676
Thanks: 0
Thanked 203 Times in 195 Posts
try also:

Code:
awk '{c+=gsub("</mdm:attribute>","&")} END {print c}' file.xml

Sponsored Links
    #7  
Old 01-08-2013
DGPickett DGPickett is offline Forum Advisor  
Registered User
 
Join Date: Oct 2010
Last Activity: 18 December 2014, 4:59 PM EST
Location: Southern NJ, USA (Nord)
Posts: 4,560
Thanks: 8
Thanked 562 Times in 537 Posts
The grep counts lines with matches, not matches. Preprocess the file so every > becomes a line feed and grep for "</mdm:attribute$".
Sponsored Links
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
concatenate 'n' number of columns in a file mlpathir Shell Programming and Scripting 3 10-06-2010 08:24 PM
Find number of columns in a file rahul26 UNIX for Dummies Questions & Answers 13 05-08-2009 06:11 AM
Counting number of columns in a delimited file net Shell Programming and Scripting 4 03-05-2009 04:56 AM
extract a number within an xml file tret Shell Programming and Scripting 10 10-07-2008 08:10 PM
Cutting number from range in xml file nir_s Shell Programming and Scripting 4 07-25-2005 03:38 AM



All times are GMT -4. The time now is 10:43 PM.