Home » Developer & Programmer » Reports & Discoverer » Comma in the data creating porblem for excel file (csv) generation (oracle reports 6i)
Comma in the data creating porblem for excel file (csv) generation [message #414809] Thu, 23 July 2009 10:26 Go to next message
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?
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 Go to previous messageGo to next message
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, |.
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
shaz
Messages: 182
Registered: June 2009
Senior Member
Just remove the comma when you are fetching the data query.
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 Go to previous messageGo to next message
rajesh4851
Messages: 89
Registered: January 2007
Member
but i should not do that Sad
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 Go to previous messageGo to next message
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.
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 Go to previous message
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.
Previous Topic: Capabilities of Discoverer
Next Topic: How can Report to use execute immediate without error
Goto Forum:
  


Current Time: Mon Nov 04 05:29:29 CST 2024