LabVIEW
Split the information within each element of an array in LabVIEW
Solved!
First replace all "\n\s+" with "\n", and all "\s+" with "\s" (use Search and Replace String twice, set it to regular expression). That would simplify using Spreadsheet String To Array. You'll now have a spreadsheet string with "\s" between columns and "\n" between rows. Just as Spreadsheet String To Array likes to have it.
You might remove the comma's with the first replace. So don't replace "\n\s+" with "\n", but replace ",?\n\s+" with "\n".
Spreadsheet String To Array should have a 2D input. Then the separator should be a \s. The second dimension uses \n as separator by default (and can't be changed).
Then use Index Array to get the desired row or column.
Search LabVIEW like a graph! Where do you get stuck?
Post your new attempts.
If we start making code for everyone, this forum would soon change from Q&A to Do This Do That. It would also cost me\us too much time. This is basic stuff, I think we do you a favor when we let you try this yourself. Teach you to fish, not hand over the fish, if you will.
Step 1:
Use Search And Replace String (ctrl+space, enter Search and Replace).
Right click it, select regular expression.
Wire the input, and the reg.ex. and the replacement string.
Post your findings, let us know where you fail.
Step 2:
Do this twice.
Post your findings, let us know where you fail.
Step 3:
Wire the result to Spreadsheet String To Array.
Change the Delimiter to \s.
Wire a 2D string array to it, that's what you want.
Post your findings, let us know where you fail.
Step 4:
Use the resulting 2D array and Index Array to get the result.
Post your findings, let us know where you fail.
It should look like this:
Slight improvement (spaces at the beginning gave error):
Less code, more complex reg.ex.
