conversion of 1-d string to dynamic data

[curiousmech]

Greetings,

I am acquiring data via serial from controller.

Now the problem is that the data is in the form of string which i have converted into 1-d array NOW  i want to save that live data in text file that can be viewed on EXCEL.
i have used "write to measurement file " box which is used for this purpose but it doesnt accepts the signal of the output that is in form of 1-d string.
Please guide me how to solve this problem.

[Miraz_Automation]

Hi,

Use Write to Spreadsheet file.vi. this will allow you to save 1-D array. please see attached picture

[curiousmech]

thanks for the guidance. now the thing is how to append the file that is being created because when i set it to TRUE than also it asks for the path again and again.
also the data that is being created is being overwritten on the same row irrespective of creating five different rows.
LOOKING FORWARD FOR GUIDANCE

[P@Anand]

You have the path Input, wire a valid file path so that you can avoid the browse window. Also please go thorugh LabVIEW basic materials so that you can understand how LabVIEW works.

[Miraz_Automation · Accepted solution]

Hi,

Please find modified code and front screen this should solve your problem.

1. Make Append? property true so data will not be overwritten. (shown in picture)

2. Give some valid path (Shown in picture as E:/abcd.csv......you can give any valid path)

[P@Anand]

---

@Miraz_Automation wrote:

Hi,

Please find modified code and front screen this should solve your problem.

1. Make Append? property true so data will not be overwritten. (shown in picture)

2. Give some valid path (Shown in picture as E:/abcd.csv......you can give any valid path)

---

I have a comment.

You don't have to use local variable to switch the button back to Off. Set the Mechanical action to "Latch When released", so this will execute the High state once and automatically switched nack to Off.

[Miraz_Automation]

Agree......i just quickly made it and posted, it can be modified for betterment.

[billko]

---

@Miraz_Automation wrote:

Agree......i just quickly made it and posted, it can be modified for betterment.

---

Hi, Miraz:

I notice you are a new contributor - which is awesome, because we always welcome new blood to the forum.  Answering a post with a VI to solve the issue isn't always the best path.  Have you heard the one about teaching a fisherman to fish...?  Many (most?) times it is better for the original poster if we engage their brain to make them come up with a solution based on information that we provide, rather than spoon-feed them the answers.

This doesn't apply to all posts on the forum, of course.  But after a while you recognize who needs help and who just needs an answer.  😉

[crossrulz]

---

@billko wrote:

---

@Miraz_Automation wrote:

Agree......i just quickly made it and posted, it can be modified for betterment.

---

Hi, Miraz:

I notice you are a new contributor - which is awesome, because we always welcome new blood to the forum.  Answering a post with a VI to solve the issue isn't always the best path.  Have you heard the one about teaching a fisherman to fish...?  Many (most?) times it is better for the original poster if we engage their brain to make them come up with a solution based on information that we provide, rather than spoon-feed them the answers.

This doesn't apply to all posts on the forum, of course.  But after a while you recognize who needs help and who just needs an answer.  😉

---

Not to mention you could be doing some student's homework.  We like to made the original poster show that they are at least trying.  Have then show their current code and have them tell you where they are having issues.  Then we help them fix that issue and point out anything else that could be problematic.  As Billdo stated, it is best for them to get the answer on their own.  We just try to provide the light to show them where it is.

[Miraz_Automation]

Hi Billko,

Thanks for advice I personally belive you are 100 % correct. but my intension is to make people learn quickly and come to a stage so that they can utilize LabVIEW knowledge in achieving their organizational and personal goal . I think its not the age of doing R&D and reinventing the wheel its better to look around grab it and then put extra efforts to customize it for our needs. Thats what I belive.