convert an array of hexadecimal numbers to decimal numbers and write to spreadsheet

[altenbach]

---

@RRRRSSSS wrote:

this may help you out

---

Than entire first loop can be replaced by "spreadsheet string to array" with "\n" as delimiter and a 1D array of strings as type. Keep it simple!

[altenbach]

---

d.jp wrote:

We have another command, "ALLDAT" with 21 sub-commands. The output would look something like the following, in HEX code like the earlier problem :

ENGDT1,0=0,8,7d4,1,17,c,f,32,0,0
ENGDT1,0=8,9,28f,293,291,25c,0,1388,1f9,e228,0
ENGDT2,0=0,4,0,71b,f0,0
...

CHPDAT,0=0,8,0,0,c8,44,43,4e,13,0
CHPDAT,0=9,2,00000041,0

This is one block of data and i need to just separate the necessary values. For eg: the 1st sub-command, ENGDT1 has 8 ARGS (7d4,1,17,c,f,32,0,0) and the last, CHPDAT has 2 ARGS (00000041,0). I just need the ARG's from each sub-command. I was thinking of putting it in a loop, but since this is one single block of output, i'm not sure how well that would work.!

---

Here's what I would do:

(the empty blue array constant is U32)