I have an Excel file that contains CRLFs into the cells. In EG 4.1, when this file is imported, in the resulted dataset CRLFs are replaced with blanks. However, in EG 5.1, when same file is imported, in the resulted dataset CRLFs are replaced with dots. For example: In Excel cell there is the following string: ((( (ISP_GROUP1_SDESC IN ("A_Internet","A_Internet_FO","B_VPN","C_Frame Relay", , "B_VPN_Layer2") AND PRICE_PLAN_TYPE_LDESC NOT IN ("Fixed Internet over Fixed Voice")) OR PRICE_PLAN_TYPE_LDESC IN ("Fixed Internet over Fixed Voice") ) AND HFM_SEGMENT_SDESC = "TFSG110" AND MASURA IN ("TD_ISP","CB_ISP","TA_ISP","OHP_CB_ISP_M1")) OR (COD_ACCOUNT="E8049000" and COD_2="TFSG110" and COD_1="MVCB_ISP") ) When the cell is imported in EG 5.1, the string becomes (partial output): (((.(ISP_GROUP1_SDESC IN ("A_Internet","A_Internet_FO","B_VPN","C_Frame Relay", , "B_VPN_Layer2") AND PRICE_PLAN_TYPE_LD Notice the dot after the first three open parenthesis that replaces the CRLF in the original string. As the intention is to use the initial Excel file to build a SQL phrase, the dot which appears leads to syntax errors. Is there any way to circumvent the problem (other that eliminating CRLFs from original file)? Thank you Stefan
... View more