07-17-2019 05:38 AM
Hello,
We have a DIP process that is ordered, with no field delimiters, and a custom separator (pipe symbol). One of the keywords configured in this DIP process is alphanumeric and has a maximum length of 250 characters. However, when the data in the index file for this keyword contains multiple sentences and therefore multiple periods and capitalized letters we are receiving and error: "Wrong number of fields". When the values for this keyword in the index file do not contain multiple sentences we do not receive this error. Here is an example of an item that would cause an error:
field1|This is field 2. With an extra sentence.|field3
Wondering if anyone has any thoughts?
Thanks
Derek
07-17-2019 06:30 AM
Hi All,
I have ran several tests after viewing the index file in Notepad++ and discovering an 'LF' character between the sentences. After removing this character the index files processed successfully. This was hard to spot because opening the index files in plain notepad did not reveal this 'LF' character and there was no apparent new line between the sentences.
I am still curious as to why this 'LF' character affected the process the way that it did because we did not select the 'Newline' separator in the configuration but rather the 'Custom' separator.
Thank you all for your very fast responses.
Derek
07-17-2019 05:44 AM
Hi, Derek, what version of OnBase are you running?
07-17-2019 05:46 AM
We are currently on version 15.0.1.84
07-17-2019 05:50 AM
How sure are you that your long text, in your example field2, doesn't actually contain a pipe character anywhere in any of the supplied text values????
07-17-2019 05:53 AM
There is never a pipe symbol in the supplied text values. These are typed by users and every instance we have had where this has failed the text values did not have a pipe character only multiple sentences. Also the supplied text values do not exceed the 250 character limit.
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.