AnsweredAssumed Answered

PI UFL: How to disregard the Double qoute with comma

Question asked by RoyRobinJr on Jul 21, 2019
Latest reply on Aug 5, 2019 by RoyRobinJr

Hi community,

 

                      I am having hard time filtering the csv file. I have csv file that has values with double qoute with comma inside. Having issues in archiving.

 

Screenshots belows:

 

Screenshot Filter on the line 1 till when the filter line Line 55 was not already align due on the inside comma of a double qoute value. 

Filter were skipped

the filter on the last row suddenly goes on the left side and filtered wrong values

 

 

Im having a hard time dealing with this issue. Hoping that you I can find help with the problem.

 

 

 

Also attach my INI file and 2 csv file that i am dealing with

TIA! 

 

Thanks,

Roy

 

Outcomes