OraFAQ Forum: Reports & Discoverer » Comma in the data creating porblem for excel file (csv) generation

Home » Developer & Programmer » Reports & Discoverer » Comma in the data creating porblem for excel file (csv) generation (oracle reports 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Comma in the data creating porblem for excel file (csv) generation [message #414809]

Thu, 23 July 2009 10:26

rajesh4851
Messages: 89
Registered: January 2007

Member

Hi,
I am working on oracle reports 6i. I have one report which will generate .csv file for the given input. Output file has one column called insurer_name. It contains comma(,) in the name. So, when the output csv file generated, it is seperating the name into 2 different columns, because the name has comma.
I am using the delimeter as ','.
Please let me know how to solve this issue?

Report message to a moderator

Re: Comma in the data creating porblem for excel file (csv) generation [message #414813 is a reply to message #414809]

Thu, 23 July 2009 11:28

tmc1
Messages: 2
Registered: June 2009
Location: USA

Junior Member

Try a different delimiter, especially one that will not be found in your data, like a pipe, |.

Report message to a moderator

Re: Comma in the data creating porblem for excel file (csv) generation [message #414827 is a reply to message #414813]

Thu, 23 July 2009 12:56

rajesh4851
Messages: 89
Registered: January 2007

Member

Tried. But its not working.
Moreover, i am using text_IO built in. Its not for any other delimiters.

Report message to a moderator

Re: Comma in the data creating porblem for excel file (csv) generation [message #414994 is a reply to message #414809]

Fri, 24 July 2009 06:09

shaz
Messages: 182
Registered: June 2009

Senior Member

Just remove the comma when you are fetching the data query.

Report message to a moderator

Re: Comma in the data creating porblem for excel file (csv) generation [message #415057 is a reply to message #414994]

Fri, 24 July 2009 09:57

rajesh4851
Messages: 89
Registered: January 2007

Member

but i should not do that Sad

Report message to a moderator

Re: Comma in the data creating porblem for excel file (csv) generation [message #415114 is a reply to message #414809]

Fri, 24 July 2009 23:44

shaz
Messages: 182
Registered: June 2009

Senior Member

Why you should not do that???
just create your simple logic to remove the comma from the name which will solve your problem of delimeter and when you insert it in csv, just write the logic to again apply the comma. you can use the space between the comma and name.
like- Carrey, Jim

I have done it before so can you.

Report message to a moderator

Re: Comma in the data creating porblem for excel file (csv) generation [message #416386 is a reply to message #415114]

Sat, 01 August 2009 06:35

rajesh4851
Messages: 89
Registered: January 2007

Member

ok. can you give me one example how to implement it? Note: im using text_io builtin to generate .CSV file.

Report message to a moderator

Previous Topic:	Capabilities of Discoverer
Next Topic:	How can Report to use execute immediate without error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 23:50:03 CDT 2024