I need help w/ speed up parsing of spreadsheet string

[jon_mcbee]

Any ideas on how to make the attached vi any faster?  I have included an example of the input file as well as the two sub vi's.  Any thoughts will be greatly appreciated.

Cheers!

[Ray.R]

Hi jmcbee,

Do they have to be done seperately? Are there restrictions to doing it in one function?

Unfortunately, I couldn't open your vi's, which are in LV8.5 (I don't have it installed on this PC)..

Can you post an image of the code or in LV8.2? 

Or if it's ok to combine into one, I could prepare an example..

[jon_mcbee]

The logfile is attached....

[Ray.R]

Can you save the vi's as LV8.2?  I'll be able to look at it and use your log file..

🙂

[jon_mcbee]

The sub vi's do not have to be sub vi's, I will try and get some 8.2.1 up for you.  Thanks!

[jon_mcbee]

Attached are the 8.2 versions.  Thanks in advance!!

[Dennis_Knutson]

If you use the built-in Search and Replace String function, it will work much, much faster than your subVI.

[jon_mcbee]

In place of the Search and Split String.vi ?

[jon_mcbee]

Thank you for the reply Dennis,

Could you explain why it will be faster?  I will be a better programmer for it!

Cheers!

[Dennis_Knutson]

Because it doesn't require you to do all of that string concantanation which can be enormous performance hit on long strings where memory allocation has to keep taking place. Just try it and see for yourself.