Skip to main content
1-Visitor
July 12, 2013
Solved

Help turning textbox inputs into matrix

  • July 12, 2013
  • 35 replies
  • 12059 views

Hello,

I am trying to create a matrix of numbers from a textbox and having a little trouble doing it. I would appreciate any help I can get. I have attached a sheet with my problem.

Thank you!

Best answer by Werner_E

I wonder why you would go through all the hassle of using a scripted component and converting its output to a vector instead of inserting the vector directly or via table input. Its more complicated and far more failure prone in my opinion.

Best approach possibly would be to let the VBasic script do the parsing and return of a vector.

Nevertheless find attached yet another solution using Mathcads programming facilities.

BTW, its not adviseable to mark the question as "assumed answered" from the very beginning as people might overlook it that way.

35 replies

24-Ruby IV
July 12, 2013

See the attach please

19-Tanzanite
July 12, 2013

Valery beat me to it, but here's an alternative version.

Alan

Werner_E
Werner_E25-Diamond IAnswer
25-Diamond I
July 12, 2013

I wonder why you would go through all the hassle of using a scripted component and converting its output to a vector instead of inserting the vector directly or via table input. Its more complicated and far more failure prone in my opinion.

Best approach possibly would be to let the VBasic script do the parsing and return of a vector.

Nevertheless find attached yet another solution using Mathcads programming facilities.

BTW, its not adviseable to mark the question as "assumed answered" from the very beginning as people might overlook it that way.

19-Tanzanite
July 12, 2013

Best approach possibly would be to let the VBasic script do the parsing and return of a vector.

Yes. This requires very little code in VBscript.

Werner_E
25-Diamond I
July 12, 2013

There is a problem with localized Windows versions like the German one I am

working with - the decimal point is ignored here (our versions use the comma

instead of the decimal point.

I cannot insert a pic at the moment (don't know why it doesn't work) but I get "54" instead of "5.4".