Spreadsheet string to array

[Munna232]

Hello All,

Please tell me how can I convert this type strings to array directly?

[GerdW]

Hi Munna,

you need to search/split the groups in quotation marks first. After splitting the string into subsets you can convert each subset on its own and build an array of the results…

SpreadsheetStringToArray will not do what you want.

[Munna232]

Hi GerdW,

Thanks for your help.

I’m just thinking how CSV (if I open same string in csv file) is giving correct result (as I expected).

I thought Spreadsheet string to array also will give same result.

Thanks for your confirmation.

[chembo]

Something like the VI below (LV2013) may work, but it needs for sure some improvements.

[P@Anand]

---

@chembo wrote:

Something like the VI below (LV2013) may work, but it needs for sure some improvements.

---

Can you please attach the VI in 2012 version.

[chembo]

---

P@Anand wrote:

Can you please attach the VI in 2012 version.

---

LV2012