eWON Flexy parse csv or text file

Ewon Support Ewon Flexy
#1

Hey @hms_support , @Tim_hms

In the case of a user file of type csv or text, how to make a parser knowing that :

  • the opening of file is carried out in text: OPEN “exp:$dtUF $uf/usr/mytextalarms.csv” FOR TEXT INPUT AS 2

  • the GET action cannot be performed correctly if the file contains about 7000 characters in total, over several lines. text$ = GET 2 does not allow to store the whole file, maybe an optimized solution exists ?

If the file contains for example :

Alarm001: Please contact the maintenance department of the XX equipment to solve the problem.
Alarm002: text2
Alarm003: text3
Alarm004: text4
…

The csv or txt file has several lines and about 7000 characters in total, how to execute the GET function to correctly execute the INSTR function to display the appropriate message for each alarm concerned?

Thank you for your help!
Jhon

Estat.htm values
#2

Hi John,

I was going to recommend you to this page but it looks like you already commented here. I’ll try and get in contact with Simon tomorrow morning and see what I can find out for you.

https://techforum.ewon.biz/thread-418.html

-Tim

1 Like
#5

Hi @Tim_hms,

Thank you very much for your contacts, a real teamwork at eWON !
Very good job ! :slight_smile:

The solution is on the following link :

https://techforum.ewon.biz/thread-1285.html

1 Like
#6

Thanks John, glad we could get it working!