You are not alone. I've been working with Labview for about 5 years now and I still have some trouble with the formatting functions. I agree that the examples and explanations are flimsy. NI needs to improve on this subject. I have had to learn about some formatting from co-workers and this forum. Here is one instance that drove me nuts:
I have a comma delimited string that contains words and numbers. I wanted to use the spreadsheet string to array to transform the input string into arrays of strings and numbers. Here is an example string with the data types that I needed to be converted in parenthesis:
Resistance Test (string), Comment String (string), 5 (U16), 0 (U16), 10 (U16)
My data file contains many lines of strings like the above representing the test name, comment, measurement, lower and upper limits. I tried using a format string of something like %s,%s,%d,%d,%d. What happens is that the first %s reads "Resistance" and because of the space between "Resistance" and "Test", "Test" was taken to be the second %s. It would bomb on the first %d. What finally worked was a format string of just "%d". Somehow the outputs came out right, 2 word string-2 word string-number-number-number. Doesn't make any sense to me. What if I had DBL instead of U32? Would I use just "%.2f"? The above example is very common in testing, in one form or another. It would be nice to have a help screen showing how to parse such a line with mixed data types, especially where the string contains spaces between words. Some comma separated fields have more than one word as its string, with spaces separating the words. %s will read until the first space. My first field might contain 2 or 3 or more words with spaces.