Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

shaunsomai
New Contributor

Carriage Return in Data

Hi

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

4 Replies
prieper
Honored Contributor II

Carriage Return in Data

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

shaunsomai
New Contributor

Carriage Return in Data

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

prieper
Honored Contributor II

Carriage Return in Data

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

shaunsomai
New Contributor

Re: Carriage Return in Data

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