Column Formatting

[MeCoOp]

I have code setup to create a file name and label various colums in Excel.  For some reason my second line of code gets tabbed over and I can't figure out why.  I've attached pictures to show my code, what I get in Excel and what I would like to get.

Thanks,

Bobby

[altenbach]

Attach your code. There is now way of telling what's in these string controls.

Also what you are writing has nothing to do with Excel© you're just writing a plain ASCII file. Create a string indicator right before the last file write and display it as e.g. \codes to see what you've got.

Message Edited by altenbach on 08-04-2006 01:28 PM

[MeCoOp]

Code attached....

[altenbach]

Well, you are creating a spreadheet string from an 1D array and one of the array elements is a linefeed. "Array to spreadsheet string" simply seperates all these with tabs, this you have a tab as first character on the new line.

You should probably write each line seperately, e.g. as in the attached image. (Why do you built a cluster, then convert to array? Built the array directly ;))

Some general comments on your code. Beware of race conditions!

You cannot guarantee in what order things get written to the file and even if the header gets written before data gets appended in the loop. Even the order of the two file writes on the left is not determined. Instead of splitting the path wire, use the path output from the first write to wire the second write operation, etc. Only data dependency guarantees the right sequence.

Message Edited by altenbach on 08-04-2006 02:33 PM