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
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