How to store alphanumeric value in one tag with PI ufl.

It should not be a string because if we pull the data on excel, we cannot do any calculation as the cells is set as text and cannot format the cell.

To copy the value into another sheet is a bad solution as it requires a lot of manual operation

Please help

OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System.
We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ  or contact OSIsoft vCampus for more details.

What I have is a lab data and I set it into two different tag: one for alphanumeric value and one for floating point value. The issue on the report and calculation.
We can't do calculation for a wide of cell in excel because one tag may have <10 value but it is reported as 10 with the floating point. Then our mean and sum outcome are always wrong.
My setup is:

tagname,timestamps,floating_value,alpha_value

So if I have a set of data like below

22bo130lqcond,01-02-2011 09:00,10,<10
22bo130lqcond,01-02-2011 09:25,0.5,0.5
22bo130lqcond,01-02-2011 09:00,8,<8

The value can go under DL detection limit that why we have the value >xx and <xx

thks fr your help

We have the all the data on PI but we cannot explore them, I mean to do calculation with excel.

Here is an exact file that we process

Tag_Name,Tag_Descr,Sampling_Date,Login_Date,Completion_Date,TT_Process,TT_Lab,Value_F,Value_S,UOM,Method
74HE102LQNa,Boiler Feed Water - Sodium,2011/09/13 11:00,2011/09/13 11:50,2011/09/13 14:12,50,142,5,<5,ppb,
74HE102LQK,Boiler Feed Water - Potassium,2011/09/13 11:00,2011/09/13 11:50,2011/09/13 14:12,50,142,8,8,ppb,

On the first entry: value_f is 5 and value_s(string) <5

So if I use the float value on my report and pull the result with datalink on range(A1,A100), calculate the mean, I got wrong result and we cannot trust with because at leat one of this value have <10 but reported as 10
If I use the string one, I cannot format the cell on excel to be a number

tks

I tried but these data are string number and cannot be manipulated.

To be able to do that, I have to copy all the value into new sheet then format as number. But that is lot of manual operation and waste a lot of time as we have lot of tags to monitor

I have two ufl interface one store the string and one store the float

String

[INTERFACE]
PLUG-IN=ASCIIFiles.dll

[PLUG-IN]
IFM=\\10.73.3.198\pims\out\UN2PI*._OK
IFS=C
REN=_DONE
ERR=BAD2
PURGETIME=2d
PFN=true
NEWLINE=13,10

[SETTING]
DEB=4
MAXLOG=10
MAXLOGSIZE=512
MSGINERROR=\\10.73.3.198\pims\ERR\Error2.log
OUTPUT=\\10.73.3.198\pims\log\LogFile2.log
LOCALE=en-us

[FIELD]
Field(1).NAME="Timestamp"
Field(1).TYPE="DateTime"
Field(1).FORMAT="yyyy/MM/dd hh:mm"
Field(2).NAME="TagName"
Field(2).TYPE="String"
Field(3).NAME="Value_String"
Field(3).TYPE="String"
FIELD(4).NAME="UnitOM"
FIELD(4).TYPE="String"
FIELD(5).NAME="Method"
FIELD(5).TYPE="String"
FIELD(6).NAME="Description"
FIELD(6).TYPE="String"
FIELD(7).NAME="CompletionDate"
FIELD(7).TYPE="String"
FIELD(8).NAME="LoginDate"
FIELD(8).TYPE="String"
FIELD(9).NAME="ProcessTime"
FIELD(9).TYPE="String"
FIELD(10).NAME="LabTime"
FIELD(10).TYPE="String"

[MSG]
MSG(1).NAME="BatchFL"
MSG(1).EPC="String"

[BatchFL]
BatchFL.FILTER = C1=="*"
' Field extractions (variables)
'
' Send the values to PI Archive
' Numerical value
'
TagName=["(*),*,*,*,*,*,*,*,*,*,*"]
Description=["*,(*),*,*,*,*,*,*,*,*,*"]
Timestamp=["*,*,(*),*,*,*,*,*,*,*,*"]
LoginDate=["*,*,*,(*),*,*,*,*,*,*,*"]
CompletionDate=["*,*,*,*,(*),*,*,*,*,*,*"]
ProcessTime=["*,*,*,*,*,(*),*,*,*,*,*"]
LabTime=["*,*,*,*,*,*,(*),*,*,*,*"]
Value_String=["*,*,*,*,*,*,*,*,(*),*,*"]
UnitOM=["*,*,*,*,*,*,*,*,*,(*),*"]
Method=["*,*,*,*,*,*,*,*,*,*,(*)"]
StoreInPI(TagName + "_Value",Description,Timestamp,Value_String,,,"UOM: " + UnitOM + " Method : " + Method + " ProcessTime: " + ProcessTime + "m LabTime:" + LabTime + "m")
StoreInPI(TagName + "_CompletionDate",Description,Timestamp,CompletionDate,,,"UOM: " + UnitOM + " Method : " + Method + " ProcessTime: " + ProcessTime + "m LabTime:" + LabTime + "m")
StoreInPI(TagName + "_LoginDate",Description,Timestamp,LoginDate,,,"UOM: " + UnitOM + " Method : " + Method + " ProcessTime: " + ProcessTime + "m LabTime:" + LabTime + "m")

Float


[INTERFACE]
PLUG-IN=ASCIIFiles.dll

[PLUG-IN]
IFM=\\10.73.3.198\pims\out\UN2PI*.csv
IFS=C
REN=_OK
ERR=BAD
PURGETIME=30m
PFN=true
NEWLINE=13,10

[SETTING]
DEB=4
MAXLOG=10
MAXLOGSIZE=512
MSGINERROR=\\10.73.3.198\pims\ERR\Error.log
OUTPUT=\\10.73.3.198\pims\log\LogFile.log
LOCALE=en-us

[FIELD]
Field(1).NAME="Timestamp"
Field(1).TYPE="DateTime"
Field(1).FORMAT="yyyy/MM/dd hh:mm"
Field(2).NAME="TagName"
Field(2).TYPE="String"
Field(3).NAME="Value_Number"
Field(3).TYPE="Number"
FIELD(6).NAME="UnitOM"
FIELD(6).TYPE="String"
FIELD(7).NAME="Method"
FIELD(7).TYPE="String"
FIELD(8).NAME="Description"
FIELD(8).TYPE="String"
FIELD(9).NAME="ProcessTime"
FIELD(9).TYPE="String"
FIELD(10).NAME="LabTime"
FIELD(10).TYPE="String"

[MSG]
MSG(1).NAME="BatchFL"
MSG(1).EPC="Float32"

[BatchFL]
BatchFL.FILTER = C1=="*"
' Field extractions (variables)
'
' Send the values to PI Archive
' Numerical value
'
TagName=["(*),*,*,*,*,*,*,*,*,*,*"]
Description=["*,(*),*,*,*,*,*,*,*,*,*"]
Timestamp=["*,*,(*),*,*,*,*,*,*,*,*"]
Value_Number=["*,*,*,*,*,*,*,(*),*,*,*"]
UnitOM=["*,*,*,*,*,*,*,*,*,(*),*"]
Method=["*,*,*,*,*,*,*,*,*,*,(*)"]
ProcessTime=["*,*,*,*,*,(*),*,*,*,*,*"]
LabTime=["*,*,*,*,*,*,(*),*,*,*,*"]
StoreInPI(TagName,Description,Timestamp,Value_Number,,,"UOM: " + UnitOM + " Method : " + Method + " ProcessTime: " + ProcessTime + "m LabTime: " + LabTime + "m" )