LabVIEW
How to format a text file
I don't think you need any loops and there is certainly no need o convert to numbers and back!
(scanning and formatting operations are expensive!)
Read the file as a plain string, then convert it to a 1D array of strings, one line per array element.
Reshape to a 2D array of proper dimensions and transpose to fill columns first.
Use spreadsheet string to array (now with tab as delimiter) to generate the desired string.
Write the string to a new file.
Here's a simple draft (LabVIEW 8.0). Look ma, no loops! 😄
Modify as needed.
Message Edited by altenbach on 06-15-2007 03:29 PM
@roiht wrote:
Though you forgot to place Number to string pallatte in between, but I've placed it now and it's working simply great.
Just for your reference:
Actually, this VI works correctly under LabVIEW 8.2, where the "read from spreadsheet file" got enhanced with a polymorphic selector that allows reading arrays of strings instead of arrays of numbers. The downconversion to LabVIEW 8.0 can only read numeric spreadsheets, breaking the code.
This is how it looks in 8.2:
(Whenever possible, I check downconverted code in the target version and correct such issues. Most likely, Caseyw does not have 8.0.)
If you want to adapt this code for 8.0, read it as a string, then convert to a 2D array of strings to simulate the 8.2 capabilities.
Still, I prefer my method. 😄
Message Edited by altenbach on 06-15-2007 03:46 PM
