grep is not the right tool for the job for loading XML. XML is a data structure that is tag oriented, so anything line oriented (like grep) will only work for a subset. Sometimes you get away with that, but you always create code that's brittle and prone to exploding messily, when someone 'upstream' generates perfectly valid XML which doesn't work because you haven't followed the spec.
So aside from 'LOAD XML' which is referenced in the comments: http://stackoverflow.com/questions/13833568/automated-way-to-convert-xml-files-to-sql-database
I will offer a Perl solution to extract data from your XML.
#!/usr/bin/env perl
use strict;
use warnings;
use XML::Twig;
my @ID_list;
sub extract_provider_ID {
my ( $twig, $provider ) = @_;
push ( @ID_list, $provider -> text );
}
my $twig = XML::Twig->new(
'twig_handlers' => { 'ProviderID' => \&extract_provider_ID },
);
$twig->parsefile( 'your_file.xml' );
print join ("\n", @ID_list );
I'm sure you can figure out the appropriate insert now that @ID_list is populated with every 'ProviderID'. Note - it ignores hierarchy - any ProviderID element is found and returned. You can require that hierarchy if you wish, by for example:
'twig_handlers' => { 'Record/RecordMain/ProviderID' => \&extract_provider_ID },
