Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 90
  • Last Modified:

VBA double quote escaping question

How do you compare two strings when one is
3"
and the other is "3"""
which is the same 3 inches but with the double quote within the string escaped.
I want to do a straight "is string equal"
0
Silas2
Asked:
Silas2
  • 3
  • 2
  • 2
  • +1
3 Solutions
 
Martin LissRetired ProgrammerCommented:
You could do

 If Val(first string) = Val(second string) Then
0
 
Martin LissRetired ProgrammerCommented:
Or in a formula, something like

=IF(SUBSTITUTE(A1,CHAR(34),"")=SUBSTITUTE(B1,CHAR(34),""),"Equal","Not equal")
0
 
Silas2Author Commented:
I was thinking along those lines, and stripping all the quotes out, but that's a bit crude and wouldn't catch quite a few possibilities, (although I have to think quite hard to come up with any but in large(ish) volumes there might be some)
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
If Replace(<SomeVar1>,Chr(34),"") = Replace (<SomeVar2>, Chr(34),"") then
 'whatever
Else
'whateverelse
Endif
0
 
Martin LissRetired ProgrammerCommented:
I was thinking along those lines, and stripping all the quotes out, but that's a bit crude and wouldn't catch quite a few possibilities, (although I have to think quite hard to come up with any but in large(ish) volumes there might be some)
If you think of a possibility, let me know.
0
 
PatHartmanCommented:
That's just one of the many problems that mushing multiple attributes into a single field causes.  Use one field for just the number and the second for the unit of measure.  EVERY field should be atomic.  That's what first normal form specifies.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
If only it were a perfect world :-)
0
 
PatHartmanCommented:
I can't tell you how many of these situations I have fixed over the years.  It's almost always better to simply resolve the data problem by splitting the mushed field once.  Then everything else just works better.  Of course if you have no control over the table schema you're SOL.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now