OraFAQ Forum: Forms » Reg Csv file

Home » Developer & Programmer » Forms » Reg Csv file (oracle forms,10g,windows xp)

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

Reg Csv file [message #501695]

Wed, 30 March 2011 13:48

giridhar123
Messages: 2
Registered: March 2011

Junior Member

Hi,
The form which i developed is for Mulitple user. ie many no of user upload the same csv file at the same time. To differentiate it 4r the user i gave the user name in Prefix. say the users name are xx and yy and the file name is test.csv. In the kentucky server it is loaded as "xx_test.csv" and "yy_test.csv". It loaded along with Double quotes.I used the varible to get loaded

l_bare_filename := '"'||v_username||'_'||substr(:FIC_SOURCE,instr(:FIC_SOURCE,'\',-1)+1)||'"';

l_bare_filename is that variable.

When i tried to null the csv file it is not created as Double quotes in Kentucky server. say it is displaying xx_test.csv file. Below is the command for making null. I used the same variable
host('cat /dev/null > /tmp/'||l_bare_filename )

I want it to be displayed with Double quotes.
please HELP to sort with this issue.

Report message to a moderator

Re: Reg Csv file [message #501699 is a reply to message #501695]

Wed, 30 March 2011 14:46

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I wouldn't know, but - why do you insist on filenames that contain double quotes? It sounds like an unusual requirement. Wouldn't you prefer "ordinary" filenames (which would also fix your problem).

Report message to a moderator

Previous Topic:	Issue with Mandatory Field in Custom Form
Next Topic:	Send e-mail via Oracle Forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 05:06:13 CDT 2024