How can I take parameters from two seperate files and write them to a new file?

[dirtpics]

I am trying to combine the data from two different files and write them to a new text file. The text file represents a text file that is written as images are acquired and the CSV file is an IMU output file that records the lat, long, altitude, etc.. each time an image is acquired.  The two examples aren't a true representation of actual files that will be used because there should be the same number of line in each file (20 images taken should equal 20 entries in the CSV file), but they give you the idea.

I want to take the image name from each line of the text file (aero041510_S01_0002.tiff, ...0003.tiff, ...etc) as well as the latitude and longitude parameters from the CSV file and write them to a new text file.  I've tried taking a spreadsheet to array function and have had limited success.  Anyone have an idea about how I should go about trying to accomplish this?  There is probably alot easier way of doing thigs than how I am trying to do it.

Thanks in advance,

Dirtpics

[smercurio_fc]

You can simplify the code considerably by using Read From Spreadsheet File and Write to Spreadsheet File. Since the number of lines will be the same, you can just use a loop to create your new array. Note that you can use the Format Into String function instead of that Express VI to create your string.

See attached modification to get you started.

[dirtpics]

Thanks for the help!!  I was able to add a few more things and make some changes to make it write to the file like I want.  I'm sure I'll need help on Monday when I get back to working on it.

Thanks again,

Dirtpics