NI TestStand

cancel
Showing results for 
Search instead for 
Did you mean: 

Spreadsheet String to array

Hello everyone.  I need advice from all you TestStand champions out there

 

I want to convert spreadsheet string to array dynamically.

My entry point are strings i receive from LabVIEW (0.060000    0.000000    0.000000    0.000000    0.000000    0.000000 ... ....)

I want to fill in my 1D array teststand in number (DBL) or labVIEW Dynamics data...

I can add in a previous step a statement step.

Any idea how to do this ? insert elements function ?

 

BR,

Vincent

Download All
0 Kudos
Message 1 of 4
(4,951 Views)

Since it looks like you are getting this data from a VI, I say make that VI do the work for you.  There is a very simple Spreadsheet String To Array function in LabVIEW.


GCentral
There are only two ways to tell somebody thanks: Kudos and Marked Solutions
Unofficial Forum Rules and Guidelines
"Not that we are sufficient in ourselves to claim anything as coming from us, but our sufficiency is from God" - 2 Corinthians 3:5
0 Kudos
Message 2 of 4
(4,942 Views)

Hello crossrulz,

 

Thanks for your reply

Indeed i get my string from this labVIEW function but I am using a VI to fill in all my TestStand parameters...

 

Here is an example of what kind of command i send :

AgilentB2901A ; SET_ARBRITARY_WAVEFORM ; PATTERN_MODE ; PATTERN ; DEVICEACTION ; DT ; NB_PATTERN_LOOP ...

I won't explain all command detail but for instance :

PatternMode means Voltage or Current

Dt means width signal sourced... etc...

Pattern represents the array of data i have already converted to string (0.060000    0.000000    0.000000    0.000000    0.000000    0.000000)

 

Now i want to find a teststand function which can have the same behaviour as the LabVIEW's spreadsheet string to array... to fill in my TestStand parameters...

Hope this bring light on my issue...

 

BR,

Vincent

 

0 Kudos
Message 3 of 4
(4,935 Views)

In other words,

 

With that string : (0.060000    0.000000    0.000000    0.000000    0.000000    0.000000)

I have to fill in an array of number teststand. (called "pattern")

 

I already set  "pattern" dimmension.

In another statement step i tried function "InsertElements" but the equality is false...

Locals.Pattern= InsertElements(Locals.Pattern,"[0]",Val(Parameters.SplittedCommandArray[8]))

 

Any lead will be appreciated !

 

NB : Parameters.SplittedCommandArray[8]) = (0.060000    0.000000    0.000000    0.000000    0.000000    0.000000)

I think my topic title is wrong ; should be : "Teststand create array from string" Any admin could modify this ?!


BR,

Vincent

0 Kudos
Message 4 of 4
(4,913 Views)