Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

Data Archive Reference

Convert fixed format to delimited format

  • Last UpdatedJan 13, 2023
  • 1 minute read

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

TitleResults for “How to create a CRG?”Also Available in