Unix/Linux Go Back    


Shell Programming and Scripting BSD, Linux, and UNIX shell scripting — Post awk, bash, csh, ksh, perl, php, python, sed, sh, shell scripts, and other shell scripting languages questions here.

Number of columns in xml file

Shell Programming and Scripting


Closed    
 
Thread Tools Search this Thread Display Modes
    #1  
Old Unix and Linux 01-08-2013
victory victory is offline
Registered User
 
Join Date: Jan 2012
Last Activity: 19 August 2016, 9:07 AM EDT
Posts: 29
Thanks: 1
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 Unix and Linux 01-08-2013
pravin27 pravin27 is offline Forum Advisor  
Advisor
 
Join Date: Sep 2009
Last Activity: 7 September 2016, 8:47 AM EDT
Location: ./India/Bangalore
Posts: 1,271
Thanks: 70
Thanked 299 Times in 290 Posts
Hope this will help you ..


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

Sponsored Links
    #3  
Old Unix and Linux 01-08-2013
victory victory is offline
Registered User
 
Join Date: Jan 2012
Last Activity: 19 August 2016, 9:07 AM EDT
Posts: 29
Thanks: 1
Thanked 0 Times in 0 Posts
It's not perl script it is UNIX ibm aix.
    #4  
Old Unix and Linux 01-08-2013
radoulov's Unix or Linux Image
radoulov radoulov is offline Forum Advisor  
Forum Adviser
 
Join Date: Jan 2007
Last Activity: 16 December 2015, 5:59 AM EST
Location: Варна, България / Milano, Italia
Posts: 5,690
Thanks: 184
Thanked 629 Times in 586 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 Unix and Linux 01-08-2013
Corona688 Corona688 is offline Forum Staff  
Mead Rotor
 
Join Date: Aug 2005
Last Activity: 7 December 2016, 4:50 PM EST
Location: Saskatchewan
Posts: 21,664
Thanks: 1,010
Thanked 3,983 Times in 3,700 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 Unix and Linux 01-08-2013
rdrtx1 rdrtx1 is offline
Registered User
 
Join Date: Sep 2012
Last Activity: 7 December 2016, 9:36 PM EST
Location: Houston, Texas, USA
Posts: 873
Thanks: 0
Thanked 299 Times in 286 Posts
try also:

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

Sponsored Links
    #7  
Old Unix and Linux 01-08-2013
DGPickett DGPickett is offline Forum Advisor  
Registered User
 
Join Date: Oct 2010
Last Activity: 1 February 2016, 3:35 PM EST
Location: Southern NJ, USA (Nord)
Posts: 4,673
Thanks: 8
Thanked 587 Times in 560 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 Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux 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
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 07:54 AM.