Hey all,
Am using Reflection for Unix and OpenVMS 14.1.83
My screen looks something like this....
Screen 1 of 35
*> 1. Field1 Value1
2. Field2LongName Value2
3. Field3 Value3
4. Field4LongName Value4
etc..
I'm using GetText to grab a rectangle on each page containing all of the field data. There may be 4 spaces between fields 1&3 and their values and 20 spaces between fields 2&4 and their values. Having some troubles gracefully parsing this rectangle. Code looks something like this.
For Page = 1 To pageCount
myScreen = .GetText(.FoundTextRow + 3, 4, .FoundTextRow + 19, 80, rcRectRegion)
rowData = Split(myScreen, vbCr) 'This is working fine - splitting rectangle into rows
For Row = 0 To UBound(rowData)
Dim temp() As String, j As Integer
temp = Split(rowData(Row)) 'This is where I'm having problems
j = 1
For i = 1 To UBound(temp) 'Want to get rid of this
If Not temp(i) = "" Then
fieldData(fieldCount, j) = temp(i)
j = j + 1
End If
Next i
fieldCount = fieldCount + 1
Next Row
.Transmit Page + 1, rcIgnoreBlockMode
.TransmitTerminalKey rcVtEnterKey
Next Page
The only character or char constant I can find to successfully split each row into its #, name, value set is the space key. Since there are a varying number of spaces between the name value sets, I have to loop through the spaces in the temp array to find my value. I have tried vbTAB, and a bunch of reflection constants (both alone and with Chr$(rcHT)) but I'm getting no where. Anybody up on a graceful way to split up my line data? By spaces works but it just annoys me!
Also...how the heck to you get this app to consider the spacing you put in your orig post...left justifies and takes away add whitespace everywhere?
Am using Reflection for Unix and OpenVMS 14.1.83
My screen looks something like this....
Screen 1 of 35
*> 1. Field1 Value1
2. Field2LongName Value2
3. Field3 Value3
4. Field4LongName Value4
etc..
I'm using GetText to grab a rectangle on each page containing all of the field data. There may be 4 spaces between fields 1&3 and their values and 20 spaces between fields 2&4 and their values. Having some troubles gracefully parsing this rectangle. Code looks something like this.
For Page = 1 To pageCount
myScreen = .GetText(.FoundTextRow + 3, 4, .FoundTextRow + 19, 80, rcRectRegion)
rowData = Split(myScreen, vbCr) 'This is working fine - splitting rectangle into rows
For Row = 0 To UBound(rowData)
Dim temp() As String, j As Integer
temp = Split(rowData(Row)) 'This is where I'm having problems
j = 1
For i = 1 To UBound(temp) 'Want to get rid of this
If Not temp(i) = "" Then
fieldData(fieldCount, j) = temp(i)
j = j + 1
End If
Next i
fieldCount = fieldCount + 1
Next Row
.Transmit Page + 1, rcIgnoreBlockMode
.TransmitTerminalKey rcVtEnterKey
Next Page
The only character or char constant I can find to successfully split each row into its #, name, value set is the space key. Since there are a varying number of spaces between the name value sets, I have to loop through the spaces in the temp array to find my value. I have tried vbTAB, and a bunch of reflection constants (both alone and with Chr$(rcHT)) but I'm getting no where. Anybody up on a graceful way to split up my line data? By spaces works but it just annoys me!
Also...how the heck to you get this app to consider the spacing you put in your orig post...left justifies and takes away add whitespace everywhere?