+ Reply to Thread
Results 1 to 2 of 2

question on split

Hybrid View

  1. #1
    Registered User
    Join Date
    04-30-2009
    Location
    tokyo
    MS-Off Ver
    Excel 2016
    Posts
    43

    question on split

    Hello,

    I think I am missing something:
    I have this two lines:

    AA="SetupType=HFSSDriven"
    BB=split(AA,"=")

    when I check BB, I get

    BB(0)="SetupType"
    BB(1)=""
    BB(2)="HFSSDriven"
    BB(3)=""

    I would have expected to see
    BB(0)="SetupType"
    BB(2)="HFSSDriven"

    There are no spaces in AA.
    Why do I have the "" array components?

    Thanks

    Katto01

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887

    Re: question on split

    Hi Katto,

    When I add AA and BB to a new macro and check the LBound and UBound properties of BB I get 0 and 1, only two elements split properly. Not sure why you're seeing anything different there.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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