Replace bad items in list

Hei there!

I'm reading external data from a txt file. The problem is that the String (GPS latitude) does not only contain numbers but somtimes an "X". (if it is not connected)

Can anybody think of a way to replace all the "X"s with the value of the prior item?

The problem is that it kills the String to Number function and the lines generated are very buggy.

Thanks everybody!

mias

Attachments:

screen.JPG, 80 KB

Replies to This Discussion

Permalink Reply by Mateusz Zwierzycki on February 15, 2011 at 11:39am

Replace branch component ?

Permalink Reply by mias saim on February 15, 2011 at 12:49pm

yes exactly! i attached a screenshot and in the branch the "X" should be replaced by the previous entry. is "repace branch component" a function? I don't know that one!

Permalink Reply by David Rutten on February 15, 2011 at 12:58pm

David Rutten

david@mcneel.com

Poprad, Slovakia

Permalink Reply by mias saim on February 15, 2011 at 2:02pm

Hei David!

This works great! Thanks for the help. One problem remains: sometimes there are two or more "X"s in the list next to each other - and it is not replacing all of them, but only the last of the series. Can you help again?

Thank you so much!

Permalink Reply by David Rutten on February 15, 2011 at 3:20pm

Ouch, if you need this to work on an indefinite sequence of potential X's, I fear you might need some form of scripting. I attached a ghx file with two scripts. One (the upper one) repeats the last string literal that doesn't match "X".

The lower one works on numbers only (though it requires Text strings as input) and it will actually interpolate the numbers at X based on the surrounding valid numbers.

David Rutten

david@mcneel.com

Poprad, Slovakia

Attachments:

gaposis.ghx, 45 KB

Permalink Reply by mias saim on February 16, 2011 at 8:32am

Hei David!

This works great!!! Thank you so much for the help!

Permalink Reply by mias saim on February 16, 2011 at 9:01am

Hallo again!

this - i guess - is the simplest question but still I can't figure it out. How can I replace - or create a list - the has the items index as value. (for the entire lenght of the list)

Thank you - & sorry!

mias

Permalink Reply by David Rutten on February 16, 2011 at 10:24am

"items index as value" ?

David Rutten

david@mcneel.com

Poprad, Slovakia

Permalink Reply by Danny Boyes on February 16, 2011 at 10:37am

Series Component set to List Length - 1.

(sorry cannot show example at the moment.)

Permalink Reply by mias saim on February 16, 2011 at 11:11am

Thank you!

Permalink Reply by mias saim on February 17, 2011 at 11:31am

Hei there!

Another thing that I cannot work out: In the file David provided (the script) I try to add a "else if" clause...

I cannot figure out what I'm doing wrong there.

Here's the code:

    For i As Int32 = 0 To data.Count - 1
      If (data(i) = "X") Then
        data(i) = lastKnownGoodValue
      Else If (data(i) > 600) Then
        data(i) = lastKnownGoodValue
        Else
        lastKnownGoodValue = data(i)
      End If
    Next

Thank you so much!

mias

Permalink Reply by Danny Boyes on February 17, 2011 at 12:58pm

I think the problem might be that data(i) has been converted to a string to compare to the "X" value and therefore will not work as a value to be greater than 600. Try CInt(data(i)) > 600.

Someone else jump in here if I'm wrong with the data type mismatch as I don't do VB script components much

RSS