Re : Transpose a 1D string array

[smercurio_fc]

---

@MJ40 wrote:

Thanks! I was able to fix the transpose problem.

However when my data is collected I have a strange offset. I tinkered with it and got some different excel output formats but not the one I want. Any ideas?

Code1 is the Code that gives the output to excel1.

Thanks.

---

It would be easier if you posted actual code. Can't debug pictures. What version of LabVIEW are you using? That function you have between Build Array and Array to Spreadsheet String is not the Transpose 2D Array function. At least not one that I've ever seen.

[johnsold]

It is the Transpose Matrix function.

Lynn

[smercurio_fc]

---

@johnsold wrote:

It is the Transpose Matrix function.

Lynn

---

I thought of that (which is one of the reasons why I asked what LabVIEW version was being used). But...  What does your Transpose Matrix look like? Mine (8.2) looks like this:

And the LabVIEW 2009 Help shows the same icon.

I don't think I need glasses that badly.

[MJ40]

Hi,

The code may not be much help because I am running three data instruments on a data acquisisiton system. However, the error is coming from the array to spreadsheet string step for the header. Before this step the probes read " A B C". After they read

"A B C

"

Not sure if this is inherent in the array to spreadsheet array function or if there is a way to correct that.

[MJ40]

I have LabVIEW 2009. I have changed the icon to Transpose 2D Array but it doesn't change anything (also still does not look like that one!)

[johnsold]

It is the Transpose Matrix FUNCTION, not VI.  It is in the Matrix subpalette of the Mathematics >> Linear Algebra palette.

Lynn

[johnsold]

The Array to Spreadsheet string function does put an End of Line character at the end of the string.  That is why you get the extra line.

Did you try aeastet's or tbob's code?  They should do what you want.

Lynn

[smercurio_fc]

---

@johnsold wrote:

It is the Transpose Matrix FUNCTION, not VI.  It is in the Matrix subpalette of the Mathematics >> Linear Algebra palette

---

Well, that explains it. Don't have that in 8.2, which is why I asked for the LabVIEW version.

To MJ40: how did you end up in that palette? That's more of a curiosity question.

[MJ40]

I have but they but I am not able to follow them exactly because wirings do not match up (e.g. aeastet has a pink wire coming out of his spreadsheet string to array but my code only allows a double(orange wire) coming out of there) thus I cannot append the header array to the data array.

I just searched transpose and that is how I found that pallette.

[tbob]

You can change the orange wire to pink by using the Number to Fractional String function found in the String - String/Number Conversion palette.