AnsweredAssumed Answered

UFL Field format to extract last data column of a row

Question asked by MaxStrueverWipro on Sep 12, 2016
Latest reply on Sep 14, 2016 by cramsey

So, I've been stumped by a challenge presented in the latest UFL interface I am setting up.

I have a data source producing data files with column headers for the name, and then timestamped data in data rows.

one example is this:

 

PtTimeRpEcGf
#sohmV
010:55:37,331342334235
112:12:20,33324245
213:29:02,2321312388

 

However, the data source (a Gamry system) outputs different data depending on the experiment running, so the files can have different numbers of columns, so this could also be the file format coming out

 

PtTimeFreqZrealZimagZsigZmodZphzIdcVdcIERange
#sHzohmohmVohm°AV#
010:55:43,23134233423513423342351342334235
112:12:20,00324245324245324245
213:29:02,00213123882131238821312388

 

 

I have a UFL ini file to grab the various header names and columns

Value1=["**(*)*"]
Value2=["***(*)*"]
Value3=["****(*)*"]
Value4=["*****(*)*"]

...

and this works great, except I can't figure out a good way to grab the last column

If I knew the column count, I could do (for 7 columns as an example):

ValueLast=["******(*)"]

 

however, I'm having trouble thinking of a way of making this flexible for different column counts!

What UFL data extraction line could I use to get, in my posted examples above, both the Gf column from the first file, and the IERange column of the second example file?

 

if anyone has any suggestions, it would be much appreciated!

 

Note:

  • all the files are coming in to the same shared folder with similar name formats, so it would be difficult (and tedious!) to make different UFL interfaces for different numbers of columns. and this might change over time anyway so I'd have to prepare tons of different interfaces
  • one solution would be to have dummy data in the last column, since getting the last column is difficult. I have requested this with the engineer of the system and will pursue that as well. But if I could find a pure UFL solution, that would be great!

 

Thanks!

Outcomes