From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
LabVIEW
excel file to text in hex format 16 places per row
Solved!
Hi R,
@RHutchings wrote:
I have some data in an excel file that needs to be converted and arranged into 16 columns of hex text
And what is the problem?
Should we help you on creating some Excel/VBA macros?
What is "hex text"? Very ambiguous and completely uninformative!
So you have an excel file with text formatted cells containing one or two numeric digits (that for all practical purpose could already be hex formatted, who knows!!!) in variable length rows. (but many more that 16 columns!) How should the values be reshaped into 16 columns? What does the problem have to do with LabVIEW?
I have not looked at your file, but there are conversion functions in excel that might help.
Good luck.
@RHutchings wrote:
60 20 00 40 60 60 40 00 20 20 00 00 20 20 00 00 20 20 00 40 60 60 40 00 20 20 00 00 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 40 60 60 40 40 60 60 40 00 20 20 00 40 60 60 40 00 20 20 00 00 20 20 00 00 20 20 00 40 60 60 40 00 20 20 00 00 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 00 00 40 60 60 40 00 20 20 00 00 20 20 00 40 60 60 40 00 20 20 00 00 20 20 00 00 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 40 60 60 40 00 20 20 00 00 20 20 00 00 00 00 40 60 60 40 00 20 20 00 00 00 20 00 00 20 20 00 40 60 60 40 00 20 20 00 00 00 40 60 60 40 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 40 60 60 40 00 20 20 00 00 20 20 00 00 20 20 00 40 60 60 40 00 20 20 00 00 20 20 00 00 20 20 00 40 60 60 40 00 20 20 00 00 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 40 60 60 40 00 20 20 00 00 20 20 00 40 60 60 40 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 40 60 60 40 00 20 20 00 40 60 60 40 00 20 20 00 00 20 20 00 00 20 20 00 40 60 60 40 00 20 20 00 00 00 00 20 20 00 00 00 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 40 60 60 40 40 60 60 40 00 20 20 00 40 60 60 40 00 20 20 00 00 20 20 00 00 20 20 00 40 60 60 40 00 20 20 00 00 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 60 20 00 00 20 20 00 00 20 20 00 40 60 60 40 00 20 20 00 00 20 20 00 40 60 60 40 00 20 20 00 00 20 20 00 00 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 40 60 60 40 40 60 60 40 00 20 20 00 40 60 60 40 00 20 20 00 00 20 20 00 00 20 20 00 40 60 60 40 00 20 20 00 00 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00 00 20 20 00
If posting a bunch of numbers, provide some explanation!
What are we supposed to do with this? (e.g. scan as a 1D numeric array assuming it is decimally formatted (only digits 0..9), then reshape to a 2D array with 16 columns (add padding if necesaary) and format in some kind of hexadecimal format (characters 0..F) with certain field (tab, space, etc.) and row delimiters (e.g. \n)).
Please be very (very!!!) specific! (e.g. you show 627 elements, which is not divisible by 16)
Here's one possible interpretation of the problem. You can easily change the various formats depending on what they are.
(Maybe the original is already hex formatted?)
@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
Maybe like this?
