The Daily CLAD

Community Browser
cancel
Showing results for 
Search instead for 
Did you mean: 

Re: Spreadsheet String to Array

SercoSteveB
Active Participant

What is the value of Numeric Value Out following execution of the VI?

SpreadsheetStringToArray.png

a) 17

b) 18

c) 19

d) 20

Comments
Ajay_MV
Active Participant

Answer is a) 17

--
Ajay MV


mini09
Active Participant

In this Program the For Loop with auto Index enables shows that the loop will run for array no`s bcz the N terminal is not connected.

So the spreadsheet string to array reads the value of the string. here %s is a function which converts the spreadsheet string to array of Strings.

the output of Spreadsheet string to array converts the 1x3 or 3x1 array as output.

Each time when the loop is executed the executes it calculates the value of string.

Steve=5

Likes=5

LabVIEW= 7

here the shift register helps to add the previous value so the value of Numeric Value ot is 17 and option A is correct.

SercoSteveB
Active Participant

Answer: A.  Nice one AjayvigneshMV & gnshmrthy.  Nice explanation gnshmrthy.

RAMESHB
Member

Ans is A)17

manolito
Member

does it mean that element of the string needs to be "," delimmited?

crossrulz
Knight of NI

See that comma constant being wired into the Spreadsheet String to Array function?  That is setting the delimiter.  It can be whatever you want.  In this case, it is a comma.  So the string is comma delimited.


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
manolito
Member

thank you crossRuiz.

Coul you explain to mee in a simple example how the for loop works?

thank you again.

manolo

ashwinilele
Member

A

skian
Member

A