Home » Developer & Programmer » Forms » how to remove spaces in the field flat file
how to remove spaces in the field flat file [message #616605] Thu, 19 June 2014 00:09 Go to next message
mist598
Messages: 905
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
Re: how to remove spaces in the field flat file [message #616621 is a reply to message #616605] Thu, 19 June 2014 02:35 Go to previous message
Littlefoot
Messages: 19536
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:
  


Current Time: Mon Sep 01 23:58:27 CDT 2014

Total time taken to generate the page: 0.27076 seconds