Oscript File Reader adds extra " (double quotes) when there is a " in the data provided in the .csv

When trying to read values from .csv file through Oscript File Reader , if there is a " in the data entered in the csv file the reader is adding extra double qotes.

Example if i give OPEN"TEXT

After Reading the file the output is "OPEN""TEXT"

Is there any solution to overcome this ?

Find more posts tagged with

Comments

eLink User

Post your code for your reading algorithm and a sample csv

I ran a reading routine when I looked at these in a csv

1,OpenText,Live"link

2,OpenText,Open"Text

Here's what my debugger showed me

10:56:14,492 INFO Inputlist-->{'1','OpenText','Live"link'}

10:56:14,492 INFO Inputlist 1st element-->1

10:56:14,492 INFO Inputlist 2nd element -->OpenText

10:56:14,492 INFO Inputlist 3rd element -->Live"link

10:56:14,492 INFO Inputlist-->{'2','OpenText','Open"Text'}

10:56:14,492 INFO Inputlist 1st element-->2

10:56:14,492 INFO Inputlist 2nd element -->OpenText

10:56:14,492 INFO Inputlist 3rd element -->Open"Text

again the debugger output showing me how the list presents itself

I changed the Livel"link to "Live"Link" in my csv

10:58:03,039 INFO Inputlist 3rd element -->"Live"link"

in some rare cases file systems and the way the csv file is built could be to blame

I created my test csv by hand typing the two lines in an ascii editor.

I would parse each input element by a delimiter of your choice then use many Str class emthods

like Trim etc and handle it .

BTW I cannot help ask what version of builder or cside and what livelink windows,unix,linux ?Is this FileReader a new Oscript class?

Appu Nair
www.livelink.in

On Wed, Aug 31, 2016 at 6:48 AM, eLink Entry: Content Server Development Forum <development@elinkkc.opentext.com> wrote:

Oscript File Reader adds extra " (double quotes) when there is a " in the data provided in the .csv file Posted byKavali, Akshara VarshaOn 08/31/2016 07:43 AM

When trying to read values from .csv file through Oscript File Reader , if there is a " in the data entered in the csv file the reader is adding extra double qotes.Example if i give OPEN"TEXTAfter Reading the file the output is "OPEN""TEXT"Is there any solution to overcome this ?
[To post a comment, use the normal reply function]
Forum: Content Server Development Forum
Content Server: Knowledge Center