+ Reply to Thread
Results 1 to 2 of 2

Comparing slightly different strings

  1. #1
    Registered User
    Join Date
    10-13-2004
    Posts
    26

    Unhappy Comparing slightly different strings

    Hi folks, I've been busting my brain on this one for a little while now. Lets say I have two strings, 12341234123 and 1234.123.4123, assigned to two variables, Nums1 and Nums2 respectively. As you can see, the only difference between the strings is the periods in the second string.

    I tried using the Like operator to see if I can match them, with no luck:

    Please Login or Register  to view this content.
    I tried formatting Nums1, since I had tested formatting and saw it doesn't just format a cell, it formats the string itself:

    Please Login or Register  to view this content.
    I tried using format on both variables, I tried using = instead of Like, and I even tried making a new variable where I forced Nums1 into Nums2's format using LEFT, RIGHT, and concatenations with the periods. All with no luck. I'm out of ideas, can anyone give me a hand?

  2. #2
    Forum Contributor
    Join Date
    11-16-2004
    Posts
    282
    If the variables are actually dimensioned as String type, it should work:
    Please Login or Register  to view this content.
    Hope this helps,
    theDude

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1