Need help in Overwriting result in text file

[Divineapple]

Sorry, im new to Labview.

My situation is this.

I can store the name and the result and i have the index.

Now I'm having a problem on overwriting result i had in text file.

I give you an example.

Now in my text file i have a name of a student and the result.

i wan to overwrite the result of the student.(this is just an example.)

can someone guide me please?

really need help as this is my school project.

Thanks!

i'll attach my program i have done soon.

[muks]

You can use the write to spreadsheet file and over write the file name when asked for replace existing file.

[muks]

[Divineapple]

you got the wrong idea.

i do not want to replace the file to a new file.

what i want was to edit the exsiting file if the same name appear twice.

Example:

in my text file i have already had the name of example Tom and result 80

and now i input the same name and diff result.

i wan was to overwrite the result. 

my project was similar to this here is my attachment of my project

[KateB]

Use read from spreadsheet file to read data fitst.

Then, edit read data and write it back using write to spreadsheet file.

[Divineapple]

How am I to edit and write back? I read from spreadsheet first then use search and replace function? Is there any example on it?

[KateB]

One of the idea.

[Divineapple]

By doing that, must i manually change it myself by looking at the table?

(btw im using labview 2009)

 Can it be by when there's the same data in the file, it will overwrite by itself ONLY on the result.

Something like this:

In my text file i have:

 Name       Result

 Tom            80

 and when i key in again on the front panel to store:

Name: Tom 

Result:  70

it detect the same name, but different result and it will overwrite the previous result.

and they will show (when you search for the name):

Name: Tom

result :70

you can take a look at the attachment.

[KateB]

There are many array manipulation function available in LabVIEW.

Try study each of them to see how can you utilize it for your task.

[Divineapple]

i got the idea what funtion to use. But i dont know how to apply it.