Convert fixed format to delimited format
- Last UpdatedJan 13, 2023
- 1 minute read
- PI System
- PI Server
The following is a simple example of converting fixed format data into delimited format. This can be helpful in PI2 to PI3 conversions. Convert mode can be used to reorder fields in a record or to apply modifications to data.
C:\Program Files\PI\adm>type fixed.dat
*23456789012345678901234567890
Tag1 0 100
tag2 -5 555
C:\Program Files\PI\adm>piconfig mode convert
* (Cv - ) PIconfig> @table pipoint
* (Cv - PIPOINT) PIconfig> @isty fixed
* (Cv - PIPOINT) PIconfig> @osty delim
* (Cv - PIPOINT) PIconfig> @istru tag,1,1,9
* (Cv - PIPOINT) PIconfig> @istru zero,1,10,5
* (Cv - PIPOINT) PIconfig> @istru span,1,20,5
* (Cv - PIPOINT) PIconfig> @ostru zero,span,tag
* (Cv - PIPOINT) PIconfig> @modify span+=100
* (Cv - PIPOINT) PIconfig> @echo none
* (Cv - PIPOINT) PIconfig> @input fixed.dat
0 ,200.,Tag1
-5 ,655.,tag2