OraFAQ Forum: Server Administration » Help! Need to create to a fixed width file

Home » RDBMS Server » Server Administration » Help! Need to create to a fixed width file

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

Help! Need to create to a fixed width file [message #371239]

Fri, 22 September 2000 09:17

tommy
Messages: 22
Registered: July 2000

Junior Member

I need to create a fixed width file from my oracle data. When I try to use RPAD(varx,35,' ') it puts tabs instead of spaces in the file. Is there a way around this. I need it to be spaces not tabs.

Thanks
Tommy

Report message to a moderator

Re: Help! Need to create to a fixed width file [message #371241 is a reply to message #371239]

Fri, 22 September 2000 09:57

Suresh
Messages: 189
Registered: December 1998

Senior Member

RPAD(varx,35,' ') should work..Try with space (' ') as third parameter.

Report message to a moderator

Re: Help! Need to create to a fixed width file [message #371243 is a reply to message #371241]

Fri, 22 September 2000 10:49

tommy
Messages: 22
Registered: July 2000

Junior Member

I still get tabs in the file instead of spaces.

Report message to a moderator

Re: Help! Need to create to a fixed width file [message #371244 is a reply to message #371241]

Fri, 22 September 2000 11:06

Suresh
Messages: 189
Registered: December 1998

Senior Member

try this
RPAD(varx,35,chr(32))

Report message to a moderator

Previous Topic:	Syntax question
Next Topic:	help !!!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 15:03:36 CDT 2024