(beginner) How can I convert a binary array into a DBL string that can be read into a spreadsheet application?

[Laura 436]

I only have one day of experience with Labview and I am not even sure if Labview can do what I want. I have binary data in array format and I need to convert it into a DBL string that is in a format that can be read by Excel. I noticed the Unflatten from String option and wondered if that is what I should use to convert a binary string into a DBL string, having previously transformed the binary array into a binary string (via typecase maybe?). I am really confused and I would appreciate any help!

[CraigGraham]

When you say "binary array", what precisely do you mean?

Is the array an array of strings that represent the binary data? Does each
element represent a single number? Or do you simply have one large string
with a header and then n encoded numbers each a certain number of bytes
long?

You need to know precisely how the data is encoded; hopefully it is in an
IEEE standard, but that leaves you needing to know whether it's big or
little endian and 32 or 64 bit- you specify DBL which implies 64 bit.

If the array does have one element representing one number then feeding the
array into a FOR loop, where the array will turn into a single element,
feeding that element to an "unflatten from string" with an arbitrary DBL
constant wired to the "type" node (it only needs the
type, the data is
irrelevant) and then feeding a wire from the output of that function to a
DBL array indicator outside the FOR loop should give you numbers. If it
gives garbage, try putting a "reverse string" node inside the FOR loop and
before the "unflatten from string" and see if it helps. If neither of these
works, then more information is required.

Laura wrote in message
news:50650000000800000020200000-991728092000@quiq.com...
> (beginner) How can I convert a binary array into a DBL string that can
> be read into a spreadsheet application?
>
> I only have one day of experience with Labview and I am not even sure
> if Labview can do what I want. I have binary data in array format and
> I need to convert it into a DBL string that is in a format that can be
> read by Excel. I noticed the Unflatten from String option and wondered
> if that is what I should use to convert a binary string into a DBL
> string, having previously transformed the binary array into a binary
>
string (via typecase maybe?). I am really confused and I would
> appreciate any help!

[mike23303]

I have a similar problem, with a little more information to start with. I'm
trying to decode a binary stream with a frame length of 240bits (not BYTES).
the synch word is 16bits (easy enough) however, the remaining 36 words in
the frame are anywhere in length from 3bits to 24. I've tried splitting the
data into boolean arrays but i can't seem to truncate or pad the words that
fall outside the 8bit/16bit length that labview seems to be comfortable
with.

any help is appreciated.

thanks in advance
Laura wrote in message
news:50650000000800000020200000-991728092000@quiq.com...
> (beginner) How can I convert a binary array into a DBL string that can
> be read into a spreadsheet application?
>
> I only have one day of experience with Labview and I am not even
sure
> if Labview can do what I want. I have binary data in array format and
> I need to convert it into a DBL string that is in a format that can be
> read by Excel. I noticed the Unflatten from String option and wondered
> if that is what I should use to convert a binary string into a DBL
> string, having previously transformed the binary array into a binary
> string (via typecase maybe?). I am really confused and I would
> appreciate any help!