Split() question 1

[kencat742]

Each line of my textbox is an array which is read from an excel file. In the text box it looks somewhat like this where all the pump commands are in one column and the different valve commands are in their columns:

Pump /Z Valve /Y Valve
SLEW = 5000 GO5 GO15
VM = 5000 GO9 GO16
MOVR = -5000 GO6 GO12
SSTP GO8 GO15
SLEW = 50 GO5 GO16

What I want to do is go through the array to get each value seprarately using the Split function at chr(9) which I used for spacing in the txtbox. Some of the lines have more than one chr(9) between the columns (such as between SSTP and GO8). In this case what will happen with the split? will it have an element in the array which is blank or will it skip over both chr(9)? Thanks

You've heard about the computer programmer that died while washing his hair in the shower. The instructions said, 'Lather, rinse, repeat.'

 

[Golom]

It will have a blank entry. You could

myArray = Replace ( myArray, Chr(9) & Chr(9), Chr(9))

Then do the split. That should replace double occurrences of chr(9) with a single occurrence. You could get a little fancier with

nLen = 0
Do Until nLen = Len(myArray(n))
    nLen = Len(myArray(n))
    myArray(n) = Replace ( myArray(n), Chr(9) & Chr(9), Chr(9))
Loop

which should remove all multiple occurrences.

 

[kencat742]

Thanks, the replace works great
This makes my for/next loop look a lot prettier (and my code a lot less complicated)

You've heard about the computer programmer that died while washing his hair in the shower. The instructions said, 'Lather, rinse, repeat.'