topic Re: Delimiter not been recognized in QlikView

Delimiter not been recognized

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am facing a problem with delimiters in Qlikview. I have data with '|' as delimiters, however based on sample data as below qlikview does not recognize '|' as delimiters due to apostrophe ( ' ). When i loaded the data into Qlikview, the data is combined it into one field instead of separate field.

Any advice or solution could fix the problem? Thanks!!?

Re: Delimiter not been recognized

Miguel_Angel_Baeyens — Thu, 20 Oct 2016 10:32:01 GMT

Hi Meng Hui Lee,

Is that actually a delimited file? It also looks like fixed size. Anyway, make sure you are specifying "no quotes" in the load statement file options.

As a last resort, do MSQ format truncates data while loading from delimited text file

Miguel

Re: Delimiter not been recognized

nagarjuna_kotha — Thu, 20 Oct 2016 10:50:52 GMT

Hi,

I recently i also faced delimeter issue, got resolved.

Can u share ur table script and output ?

while loading from SAP report Delimeter issues will come by following reasons:

As per the below mentioned Qik Community link, the issue can also occur when sorting is used in SAP Layout-Settings. Hence all such sorting at SAP report setting side should be removed before extraction.
Ref.: https://community.qlikview.com/thread/108716

Do the test run with above change and probably with a new test report created in SAP not having any sorting, to isolate any human error. I believe that this should work however considering remote possibilities of other factors, kindly follow the steps below in case the above fails:

Use the above new test SAP report and change the Report Format to "List" in place of ALV (Grid) and check.
. This may also occur if number of fields are more. Remove unwanted fields which will reduce the number and then check.
. After removing the unwanted fields, if the issue persists, then extract only five fields and check.

-Nagarjun

Re: Delimiter not been recognized

Fri, 21 Oct 2016 04:59:24 GMT

Hi,

Thank you for your replied.

Let me explain more details on it. I do need load the data into Qlikview, but i found there is one row of the record not loaded accordingly due to the apostrophe ('). My delimiter is vertical line (|) , but the data have the apostrophe after the delimiter. Ex: |'AINUL AFIQAH BINTI |'AINUL AFIQAH BINTI |

So Qlikview doesn't recognized the vertical line as delimiter, in fact this 2 ( 'AINUL AFIQAH BINTI ) should be insert into different field instead of gather into one field. My expected output have to consist the apostrophe also, so i hope to find a solution to load this data into database with separate field.

.txt data file:

Output:

Expected output:

Re: Delimiter not been recognized

carlcimino — Thu, 02 Apr 2020 01:21:23 GMT

I had this same problem when using SAP Concur files with Qlik Sense November 2018. A few records in the '|' delimited text files had apostrophes next to the delimiter and caused it to not be recognized for some reason. Switched from msq to no quotes and it worked! Very odd though.