topic Re: Carriage Return in Data in QlikView

Carriage Return in Data

shaunsomai — Wed, 25 May 2011 14:17:28 GMT

I am getting a carraige return chars coming through in my "|" delimited files. When i read the files in, qlikview picks the carriage return chars and sends the data to the next line hence messing the import of data into the correct fields, I tried to do a search and replace but your default editor like notepad or wordpad doesnt pick it up.

Any suggestions or ideas

Message was edited by: shaunsomai Added sample files

Carriage Return in Data

prieper — Wed, 25 May 2011 20:44:56 GMT

Had something in the past:

Can you load the file as it is, i.e. with CRs and then reload the file in memory and then lateron "glue" the file together as it is needed? Or concatenate each 2nd line? etc.

Can you post an example?

Peter

Carriage Return in Data

shaunsomai — Thu, 26 May 2011 15:07:51 GMT

Hi I have attached a sample file as well as test model to illustrate how the data is being read. thanks shaun

Carriage Return in Data

prieper — Fri, 27 May 2011 08:57:17 GMT

Load the csv without any delimiter

Sort records in Descending order

Inspect the start of each record (PEEK), if matching with account-pattern and the previous record not matching, concatenate them.

Filter only for records, where the account-data is matching

Apply logic to split the line into fields (SUBFIELD)

may post a script lateron

HTH
Peter

Re: Carriage Return in Data

shaunsomai — Fri, 27 May 2011 09:03:45 GMT

I am comfortable with Loading the file without the delimiter, I asssume the sorting would be on row no ,and Applying logic and splitting line with Subfield.Problem is identifying the account pattern. Will appreciate a script thanks shaun