Parse .tct file data into MRVS

TanviP003244604 · yesterday

Hi All,

I am working on a Service Catalog Item where I have an attachment type variable. My requirement is:

User uploads a .txt file through the attachment field
On file upload (onChange client script), I need to:
- Read the file content
- Parse the data
- Populate a Multi Row Variable Set (MRVS) on the same form before submission

Sample file format:

p1xyz.DB.ATT.COM =
(DESCRIPTION =
  (ADDRESS =
    (PROTOCOL = TCP)
    (HOST = p1xyz-scan.c01.sbcglobal.net)
    (PORT = 1521)
  )
  (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = p1xyz.db.att.com)
  )
)

Expected MRVS Output:

Each block in the file should create one row in MRVS with:

Domain → p1xyz
Service → DB.ATT.COM
Description →

(DESCRIPTION =
  (ADDRESS =
    (PROTOCOL = TCP)
    (HOST = p1xyz-scan.c01.sbcglobal.net)
    (PORT = 1521)
  )
  (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = p1xyz.db.att.com)
  )
)

Thanks in advance!