Hi,
I think you have to transform the data first, Then load it to QlikView.
So I made a Python program to separate your file. But it is my first Python program, So it is not well done, but you can achieve you want to.
To execute the program, Install Python 3.4(you can download from internet).
I hope this program is useful.
#-------------------------------------------------------
# Python Test Program
# Objective : Separate a long record with delimiter.
# Environment : Python 3.4
# ------------------------------------------------------
# File Name : ContractByLinks.py
# Delimiter : ','
# Remove : '"'
# Input File : Text file including ',' and '"'.
# Output File : A result with separated columns.
# This is my first program for Python. So not well done.
# But this can resolve you want to.
#-------------------------------------------------------
StringC = [""]
j = 0
k = 0
recNum = 0
f = open("d:\working\ContractByLinks.txt", 'r') # Input File
o = open("d:\working\ContractByLinks.out", 'w') # Output File
lines = f.readline() # Ignore the first line(Column Name)
while True :
lines = f.readline() # Read next line from the input file
if not lines: # If EOF, finish the program
break
k = 1 # ignore the first character of each line which include '"'
recNum = recNum + 1 # Total record number
l = len(lines) # Record length
StringC = "" # Initialize a variable
for j in range(l): # Performed by repeating as many as record length.
if lines == ',':
o.write(str(StringC))
o.write('\n')
StringC = ""
k = k + 1
if lines == '\n':
o.write(str (StringC))
o.write('\n')
StringC = ""
k = 1
if lines == '"':
o.write(str(StringC))
o.write('\n')
StringC = ""
k = 1
else:
StringC += str(lines)
k = k + 1
k = 0
f.close()
o.close()
print ('Record # %d \n' % recNum )
print("-------------------- FINISHED --------------------")
WanKi,
.png "Luminary Alumni"){kind=icon}