vbTab in regEx

whyulil · June 11th, 2004, 11:07 AM

I have a word document that needs to be turned into a database for a telephone directory everything is tab delimited but with lots of tabs used to line things up. so I need a regular expression that will search for 2 or more tabs so that i can use the replace function to change then to a single tab.

in other words

<%
dim regTooManyTabs
regTooManyTabs = new regExp
regTooManyTabs = "[\t+]"

replace(text, regTooManyTabs, vbTab)
%>
is this going to work?

happygv · June 12th, 2004, 02:15 AM

Done something similar using Javascript.

Code:

<script language="javascript">
String.prototype.fullTrim = function(){
 theString = this.replace(/\t+/g,"\t");
 theString = theString.replace(/^\t*([\S\s]*\S+)\s*$/,"$1");
 document.frm.txt2.value=(theString==" ")?"":theString;
}
</script>

<form name="frm">
<textarea name="txt1" onBlur="this.value.fullTrim()" rows=5 cols=100>This text has a <tab>(    )here, 2(        )here, and 4(                )here</textarea>
<br>
<textarea name="txt2" rows=5 cols=100></textarea>
</form>

Try to initiate onblur event on TEXTAREA 1 to see the effect.
Let me find you out that in ASP.
Cheers!

_________________________
-Vijay G

Strive for Perfection