Aug 28, 2001 #1 AgentM MIS Jun 6, 2001 387 US What if the string contains a null value; How Do I capture it in the array using Split..
Aug 28, 2001 #2 JoliM Programmer Jun 25, 2001 20 US You can check for a value like if arySplit(i) = "" then arySplit(i) = "Null" end if Joli Upvote 0 Downvote
You can check for a value like if arySplit(i) = "" then arySplit(i) = "Null" end if Joli
Aug 28, 2001 1 #3 JohnYingling Programmer Mar 24, 2001 3,742 US Try it. Dim arySplit arySplit = Split("","," arySplit = Split("1,,3","," http://www.VBCompare.comhttp://www.VBSortGen.com Upvote 0 Downvote
Try it. Dim arySplit arySplit = Split("","," arySplit = Split("1,,3","," http://www.VBCompare.comhttp://www.VBSortGen.com