regular expression problem

Can't you use  split function ?

javascript

function SplitDemo(){
   var s, ss;
var s = "01:09:2003~20:00~36~~Tour De France, Highlights 2001~~Laurent Jalabert 2001 - 1st Victory~133951~"
   // Split at each space character.
   ss = s.split("~");
   return(ss);
}

VBScript also has split

Hi jitganguly,

How do you want it parsed?

Cheers!

How do you want the information splitted?

Hi all,
Splitting it is not the question. That is easy enough!
Plus this is all done in vbscript, so yes I can use the split funtion.

The problem is to be able to get each line as an "individual line" so that it can be split.

I previously did this using a regular expression to parse a whole text string, read from a text file. the are about 500 lines in each file.

Once I had parsed it with regexp then I had a collection of matches. Each match could be split and then inserted into the database.

I guess I could read the file line by line, analyse the line contents and do it that way, but some of the text between the dd:mm:yyyy and (END) has line breaks so is on a new line.

Any further clues? Thanks!

so as i said, the data is read in from a text file into strLinetext and then...


            Set objRegExpr = New regexp
            objRegExpr.Pattern = "[0-9][0-9]\:[0-9][0-9]\:[0-9][0-9][0-9][0-9](.|\n)*\(END\)"
            objRegExpr.Global = True
            objRegExpr.IgnoreCase = True                  
            
            'Declare a variable to hold our collection of Matches
            Dim colMatches
            'Now, Execute the regular expression search
            Set colMatches = objRegExpr.Execute(strLineText)
            count = colMatches.Count
            Dim objMatch
            For Each objMatch in colMatches
                  str = objMatch.Value
                  arr = split(str,"~")

then the database happens in this loop!

<SCRIPT language="JavaScript">
 <!--
  str = "01:09:2003~13:00~52~~Serie A, 1997/98~~Roma - Lazio, 01/11/1997~129501~La Juventus di Zinedine Zidane scende in campo contro l'Atalanta. Per I bergamaschi sara' vita dura.(END)01:09:2003~17:00~52~~Serie A, 1991/92~~Lazio - Roma, 01/03/1992~129963~(END)"

  var sents = str.split("(END)")
  document.write(sents[0]+"<br>"+sents[1]+"<br>")

 //-->
 </SCRIPT>

<SCRIPT language="JavaScript">
<!--

 str = "01:09:2003~13:00~52~~Serie A, 1997/98~~Roma - Lazio, 01/11/1997~129501~La Juventus di Zinedine Zidane scende in campo contro l'Atalanta. Per I bergamaschi sara' vita dura.(END)\
\
01:09:2003~15:00~44~~1999 X Games Classix~~Wrecked~127893~Un concentrato di X Games: sfide rocambolesche di Street Luge, BMX, e rollerblade seguiti da gare mozzafiato di skateboard e Moto-cross(END)\
\
01:09:2003~15:30~44~~2000 X Games Classix~~Discesa BMX~127885~Una puntata sugli X Games del 2000, con i massimi interpreti della BMX.(END)\
\
01:09:2003~16:00~123~~Mondiale di tennis a inviti~~Semifinale 1974, Singolari Maschili: Arthur Ashe - Stan Smith~130267~(END)\
\
01:09:2003~16:30~123~~Mondiale di tennis a inviti~~1974, Doppio Maschile: Ashe/Laver - Newcombe/Smith~130269~(END)\
\
01:09:2003~17:00~52~~Serie A, 1991/92~~Lazio - Roma, 01/03/1992~129963~(END)\
\
01:09:2003~19:00~44~~Extreme Specials~~Coppa del Mondo Jet Set '95~130185~(END)\
\
01:09:2003~19:30~44~~Extreme Specials~~I 4 Assi - 1996~130198~(END)\
\
01:09:2003~20:00~36~~Tour De France, Highlights 2001~~Laurent Jalabert 2001 - 1st Victory~133951~(END)\
"

  var sents = str.split("(END)")
  document.write(sents[0]+"<br>"+sents[1]+"<br>")

  for ( i = 0; i < sents.length; i++ )
  {
    document.write("line["+(i+1)+"]: "+sents[i]+"<br>")
  }
   

 //-->
 </SCRIPT>