Excel cannot import files with long column and with comma

I have used the following VB script and have some problem to read the long text file ( in attachment file called A1.csv). The 2nd line of data showed only 3 instead of 42 column. Somehow excel did not import data. Also try to ignore the comma (comma=false) but it does not work (sample file B1.csv)
Please help to look at the script.

Thank you
============script====================

Please Login or Register  to view this content.

=====================================

===[Input file: A1]====Note: 2 lines of sample data=========

PROPERTYID|CLIENTCERTIFICATEDIR|AUTHENTICATIONTYPES|AUTHENTICATIONDELAY|CHAPCHALLENGESIZE|AUTHMECHANISMS|SIGNINGALGORITHMS|CIPHERMETHODS|SIGNINGMETHODS|AUDITDELAY|AUDITTIMEOUTTIME|SERVICETOKENLIFETIME|PARLAYHEARTBEATINTERVAL|ASYNCHRONOUSTIMEOUT|HEARTBEATTIMEOUTDELAY|POLICYENABLED|HONORSERVICEAGREEMENT|DEFAULTREGISTRATIONPOLICY|DEFAULTDISCOVERYPOLICY|DEFAULTHEARTBEATPOLICY|MINIMUMHEARTBEATINTERVAL|ENFORCESELECTSERVICEAGMT|CDBRECOVERYINDICATOR
Framework|/cust_use/FW/cert|P_AUTHENTICATION,P_OSA_AUTHENTICATION|1000|16|P_OSA_MD5|SP_NULL_STRING|SP_NULL_STRING|SP_NULL_STRING,P_MD5_RSA_1024,P_MD5_RSA_512|16000|0|60000|10000|3000|2000|N|N|IGNORE|IGNORE|IGNORE|5|N|1
===[End of Input file: A1 =========

===[Input file B1] 4 lines of sample data =========
SERVICE_NAME|SERVICE_TYPE|ATTR_TYPE|ATTR_LIST
SMS|2|Subscriber|SDCSACCOUNTSTATUS@SDCSMSISDN@SDCSCUSTOMERTYPE@SDCSBLACKLIST@SDCSBLACKLISTALL
SMS|2|Enterprise|ID@NAME@TESTLIST
SMS|2|Additional|X-CHARGEPRICE@X-BILLINGNAME
SMS|2|Application|ID@STARTDATE@ENDDATE@STATUS@SUBSCRIBERTYPE@TESTLIST@CHARGEPRICE@APPTYPE@SHORTCODE@SUBSCRIBERIDS
===[end of Input file B1] =========

Hello samart103
,
Welcome to the Forum!

Your files did not attach with your post. To make posts easier to read, copy and edit, please use code tags. I have done this for you because you are new. Do take some time to read the forum rules. These help make it easier to find and get answers quickly to your questions.

As a new member, please take some time to familiarize yourself with the rules.
Click here for the Forum Rules