excel file to text in hex format 16 places per row

[GerdW]

Hi R,

---

@RHutchings wrote:
I started, but something has changed on the website and I need to get used to the new format. That said. I have these numbers in Excel, let's just say 60 40 0 60 0 0 40 60 40 0 60 0 0 40 60 40 0 60 0 0 40 60 40 0 60 0 0 40 60 40 0 60 0 0 40. I want them to be like this. 60 40 00 60 00 00 40 60 40 00 60 00 00 40 60 40 00 60 00 00 40 60 40 00 60 00 00 40 60 40 00 60 00 00 40

---

Just set the cell format to "00" in Excel, so it will show numbers using two digits with leading zeros...

[altenbach]

---

@GerdW wrote:

Just set the cell format to "00" in Excel, so it will show numbers using two digits with leading zeros...

---

Yes, if this were an Excel forum, that would be the solution. 😄

[GerdW]

Hi Christian,

---

@altenbach wrote:

---

@GerdW wrote:

Just set the cell format to "00" in Excel, so it will show numbers using two digits with leading zeros...

---

Yes, if this were an Excel forum, that would be the solution. 😄

---

Well, the requirement was "Which ever is easier I guess."... 😄

[altenbach]

---

@GerdW wrote:

Hi Christian,

---

@altenbach wrote:

---

@GerdW wrote:

Just set the cell format to "00" in Excel, so it will show numbers using two digits with leading zeros...

---

Yes, if this were an Excel forum, that would be the solution. 😄

---

Well, the requirement was "Which ever is easier I guess."... 😄

---

Well, sparse question are ambiguous and we don't really know the backstory. If (big if!) the data originated in LabVIEW and a LabVIEW program is used to write that malformatted excel file, it would be a detour to even use excel. 😄

[RHutchings]

That got me part way there, thank you. Now to arrange them into 16 columns.

[altenbach]

---

@RHutchings wrote:
That got me part way there, thank you. Now to arrange them into 16 columns.

---

What was "that" that got you part way there? (I recommend to quote relevant section of the post you are replying to as I just did above!)

I already showed you how to reshape the data into 16 columns. Have you tried?

This will fill rows first. If you want to fill columns first, a little bit mode code is needed. (e.g. Swap the size inputs to "reshape array" and transpose afterwards)

(I am not sure if there is an easy solution within excel. Never use it. 😉 )

[RHutchings]

Sorry, no I didn't see that. Now we're getting somewhere.

[RHutchings]

What are the vis you are using?

[altenbach · Accepted solution]

1. spreadsheet string to array (type=1D U8 array, format=%d, delimiter <space>)
2. array size, quotient&remainder, sign, add, I32 diagram constant of "16"
3. reshape array
4. spreadsheet string to array

[RHutchings]

In the end none of this was used but I did learn a bit from all the posts.