Conversion: engineering string to fractional string

[dan07]

Hello everyone

I am loading a text file with several columns that has text (informations about the file and column titles) and values in engineering format. After I load this file I use "spreadsheet string to array" to convert it to 2D array of strings.

I would like to leave all the "text" (informations about the file and column titles) unchanged, but I want all the "engineering values" to be converted to "fractional values". How do I convert an engineering string to a fractional string?

I will have to convert the whole file at once because different files have different positions for text and engineering values and because of that would be impossible to know the index of values and convert just them.

Thanks.

Dan07

[GerdW · Accepted solution]

Hi Dan,

conversion is done like that:

But you have to select, what is text and what is number, on your own. How should LabVIEW know about your file format?

[Omar_II]

---

@dan07 wrote:

 I will have to convert the whole file at once because different files have different positions for text and engineering values and because of that would be impossible to know the index of values and convert just them.

---

You will have to loop through your 2D array of strings testing each cell for engineering values to convert and then do what GerdW suggested.

You could use Regular Expressions to detect the engineering values from the text.