Re: Trimming special characters in VB 6.0 - Visual Basic Discussion Boards

indian14312-Nov-08 4:33

12-Nov-08 4:33

Hi,

I have a string in which I have to replace all occurances of special characters with null string or character. Trim(Char[]) function is trimming only start and end of the string but I need to Trim the complete string between also.

Can anybody please help me.

Thanks
Aleem Mohammad.

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

Re: Trimming special characters in VB 6.0

Jon_Boy12-Nov-08 6:07

Jon_Boy

12-Nov-08 6:07

Use replace instead of trim.

Dim line As String = "abc#$*xyz"
line = Replace(line, "#$*", "")

Any suggestions, ideas, or 'constructive criticism' are always welcome.

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison

Re: Trimming special characters in VB 6.0

indian14312-Nov-08 6:12

indian143

12-Nov-08 6:12

Hi,

Good Idea but I one problem with this, the sequence of special characters is not known and wherever any special character appears that should be replaced with null string.

string may come like this and even in different way.
"asfgd%dfg&sdfd@#$sfdgfg&fdgfd*fgfdg$%$%$rtee&*were$^&^&dfds43636"

So any idea please will be a great helpfull.

Thanks a Lot,
Aleem Mohammad.

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

Re: Trimming special characters in VB 6.0

sph3rex12-Nov-08 6:35

sph3rex

12-Nov-08 6:35

You could think it a lil bit different ... just a thought

use System.Text.RegularExpressions.Regex with a negated class

something like "[^a-z0-9_]" where the group represents negated valid characters(meaning anything that is not there between those [] brackets will be matched) and use System.Text.RegularExpressions.Regex.Replace("your incoming string","string to replace the occurences of invalid chars");

Re: Trimming special characters in VB 6.0

indian14312-Nov-08 6:56

indian143

12-Nov-08 6:56

Hi,

Good Idear but can u please help me by giving a small code snippet if possible.

And can u please atleast hint me how to show the negation expression in a RegularExpression. That would help me a lot.

Thanks,
Aleem Mohammad.

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

Re: Trimming special characters in VB 6.0

sph3rex12-Nov-08 7:06

sph3rex

12-Nov-08 7:06

dim myString as string = "my incoming string"
Dim reg as new System.Text.RegularExpressions.Regex("[^a-z0-9_]", System.Text.RegularExpressions.RegexOptions.IgnoreCase)
dim resultString as String = reg.replace(myString,"")

Re: Trimming special characters in VB 6.0

indian14312-Nov-08 7:36

indian143

12-Nov-08 7:36

Hi,

Thanks for the help but only one final question I may need to use the special character Space as I am going to use the string for Directory name, can u please give me idea how to mention spaces in regular expression.

Thanks,
Aleem Mohammad.

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

Re: Trimming special characters in VB 6.0

Dave Kreskowiak12-Nov-08 10:33

Dave Kreskowiak

12-Nov-08 10:33

*> SMACK <* That's for writing his code for him. Now he's getting paid to turn in YOUR work.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: Trimming special characters in VB 6.0

sph3rex12-Nov-08 10:57

sph3rex

12-Nov-08 10:57

Look at the bright side ... at least you won't get another regex question ... at least not today :P

Re: Trimming special characters in VB 6.0

Dave Kreskowiak12-Nov-08 6:26

Dave Kreskowiak

12-Nov-08 6:26

Another RegEx would do this easily. All you have to do is match any character that is not acceptable and call the Replace method on the RegEx object. The match would probably be something like "\W" and the replacement string would be an empty string.

Google for "Expresso RegEx" and you'll come up with a very nice tool to help you with this.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: Trimming special characters in VB 6.0

Jon_Boy12-Nov-08 9:49

Jon_Boy

12-Nov-08 9:49

I think we are in standby mode for the next regex question today Smile | :)

Any suggestions, ideas, or 'constructive criticism' are always welcome.

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison

Thanks to all got it

indian14312-Nov-08 7:50

indian143

12-Nov-08 7:50

Hi,

Thanks a lot friends. I got it. It is completed.

Aleem Mohammad.

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

Re: Thanks to all got it

Dave Kreskowiak12-Nov-08 10:31

Dave Kreskowiak

12-Nov-08 10:31

Yes, but is it tested completely?? Did you check all boundry conditions and possible inputs?? $Shucks | :-\$

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Pattern for only numericals

indian14312-Nov-08 1:57

indian143

12-Nov-08 1:57

Hi,

Can anybody please check and clear any problem exists in the below code. My actual requirement is I get values as "900.09" and "90009", but I have return "90009" as numeric and "900.09" as non-numeric.
I am not getting the pattern or may be my testing senario is wrong please clear me this as I am new to VB 6.0.

With objRegExp
        .Pattern = "\d" '"[0-9]"
        .IgnoreCase = True
        .Global = True
    End With
      
    If iLen > 0 Then
         If (objRegExp.Test(sTemp) = True) Then
            IsNumericOnly = True
         End If
    End If

Thanks,

Aleem Mohammad.

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

Re: Pattern for only numericals

Jon_Boy12-Nov-08 2:39

Jon_Boy

12-Nov-08 2:39

Quit spamming the board. You've already asked this question below.

If this vb6 code or .Net?

Any suggestions, ideas, or 'constructive criticism' are always welcome.

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison

Re: Pattern for only numericals

indian14312-Nov-08 3:39

indian143

12-Nov-08 3:39

Hi,

It is VB 6.0 code not .Net.

Thanks,
Aleem Mohammad.

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

Re: Pattern for only numericals

Paul Conrad12-Nov-08 3:40

Paul Conrad

12-Nov-08 3:40

kissdznuts wrote:
this vb6 code or .Net?

He says he is new to vb6. I don't know whether to laugh or feel sorry for him.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

Re: Pattern for only numericals

Dave Kreskowiak12-Nov-08 3:27

Dave Kreskowiak

12-Nov-08 3:27

Judging from your previous posts, why do you even need a RegEx?? Try to convert the string to a Double, or some other appropriate numeric type. If the conversion works, the string was valid, if not, it'll throw up an error, so use an "On Error" to catch this and react appropriately.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: Pattern for only numericals

indian14312-Nov-08 3:42

indian143

12-Nov-08 3:42

Hi,

Will this work, may be not because I have to separate only the integers not even floats or doubles. Thats why choosen Regular expression.

Thanks,
Aleem Mohammad.

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

Re: Pattern for only numericals

Dave Kreskowiak12-Nov-08 4:20

Dave Kreskowiak

12-Nov-08 4:20

You really have a problem with specifying your requirements. As I counted, this is the third time you've changed them.

In that case, since you're need the number to be only integers, it appears that you've already got the RegEx correct, or maybe you need to specify that you're looking for 'x' number of digits in a row. Maybe this field needs to be a 5 digit number at all times?? In that case, the expression would be something like \d{5}. Or, it's the rest of the code that's bad, but since you haven't posted the entire function, nor given a complete description of your requirements and input samples, it's very difficult to say.

Also, you say you're NEW to VB6?? Did you know that VB6 is now a dead technology?? Microsoft stopped supporting it a while ago and there will be no future support for running VB6 apps in Windows 7 and beyond.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Unexpected Error(32810) while compiling a VB 6.0 Project

sivasankar anumula12-Nov-08 1:02

sivasankar anumula

12-Nov-08 1:02

Hi.

I have an issue with VB 6.0 Binary Compatibility. I have one dll (Let's say a.dll which is in VC++) and another VB Activex Dll (Let's say b.dll) is using a.dll. b.dll is binary compatible.

I have made small changes to the a.dll and i have referred to the new version of a.dll in b.dll project. Now when I try to compile I get an error "Unexpected Error (32810)".

I have spent lot of time on this and unable to find out the root cause. Can anybody please explain the issue and solution for this issue.

Best regards
Shankar

Re: Unexpected Error(32810) while compiling a VB 6.0 Project

Rajesh Anuhya12-Nov-08 1:08

Rajesh Anuhya

12-Nov-08 1:08

i think u have to re-register the a.dll
use regsvr32 <dll name="" with="" path="">
before that ensure that your a.dll is successfully compiled in th vc++.

Rajesh B --> A Poor Workman Blames His Tools <--

Re: Unexpected Error(32810) while compiling a VB 6.0 Project

Dave Kreskowiak12-Nov-08 3:19

Dave Kreskowiak

12-Nov-08 3:19