OraFAQ Forum: Forms » how to remove spaces in the field flat file

Home » Developer & Programmer » Forms » how to remove spaces in the field flat file

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

how to remove spaces in the field flat file [message #616605]

Thu, 19 June 2014 00:09

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hi all,

FILE_NUMBERS NULLIF FILE_NUMBERS = BLANKS "TRIM(:FILE_NUMBERS )"

In the file I am getting spaces at the end of the file.How to remove these spaces.

123ECA123 at this end square box type

Thanks

Report message to a moderator

Re: how to remove spaces in the field flat file [message #616621 is a reply to message #616605]

Thu, 19 June 2014 02:35

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

Senior Member
Account Moderator

Find what this square box really is, and then RTRIM that character, such as

SQL> select dump('abcd') from dual;

DUMP('ABCD')
--------------------------
Typ=96 Len=4: 97,98,99,100

SQL> select rtrim('abcd', chr(100)) from dual;

RTR
---
abc

SQL>

Or, try with SUBSTR, such as

SQL> select substr('abcd', 1, length('abcd') - 1) from dual;

SUB
---
abc

SQL>

[Updated on: Thu, 19 June 2014 02:36]

Report message to a moderator

Previous Topic:	do not show LOV when enable of text item=false
Next Topic:	Disabling all the block except single item

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 05:42:21 CDT 2024