CHR (27) || CHR (64) || CHR (15), serves for what ???

[Marciel]

Hello everyone,

I am giving maintenance in an old invoice print report, and on the first line there is a field that comes from the above formula. Can anyone tell me what the function of this field? Is it some configuration for matrix printers reports?

[Trevisolli]

Brother,

These characters are probably part of the configuration, in the note printing.

If I am not mistaken, CHR (27), for example, prints in bold, in the matrix.

Take a look at your printer's manual that will probably find information about that specific brand.

[gokden]

I knew only the CHR (10)
Therm he makes a line break ...

[Porva]

Taking advantage of the topic


I wanted to insert an invisible character in a column of a particular select

for example, the alt + 255 keyboard shortcut Generates this invisible character

I know that the CHR (10) creates a line break and such

Someone has idea of ??how I could simulate this alt + 255 In a Select command ???

[Porva]

Gambiarra Detected! : D

I found here, the invisible character is CHR (160) ...

I made a schedule to discover:

Select all

DECLARE 
BEGIN 
 
  FOR i IN 1..255 LOOP     
    dbms_output.put_line('teste  '||CHR(i)||'  teste --> ' || i); 
  END LOOP; 
 
END;

Result:

Select all

teste  .  teste --> 1 
teste  .  teste --> 2 
teste  .  teste --> 3 
teste  .  teste --> 4 
teste  .  teste --> 5 
teste  .  teste --> 6 
teste  .  teste --> 7 
teste  .  teste --> 8 
teste  	  teste --> 9 
teste   
  teste --> 10 
teste  .  teste --> 11 
teste  .  teste --> 12 
teste   
  teste --> 13 
teste  .  teste --> 14 
teste  .  teste --> 15 
teste  .  teste --> 16 
teste  .  teste --> 17 
teste  .  teste --> 18 
teste  .  teste --> 19 
teste  .  teste --> 20 
teste  .  teste --> 21 
teste  .  teste --> 22 
teste  .  teste --> 23 
teste  .  teste --> 24 
teste  .  teste --> 25 
teste  .  teste --> 26 
teste  .  teste --> 27 
teste  .  teste --> 28 
teste  .  teste --> 29 
teste  .  teste --> 30 
teste  .  teste --> 31 
teste     teste --> 32 
teste  !  teste --> 33 
teste  "  teste --> 34 
teste  #  teste --> 35 
teste  $  teste --> 36 
teste  %  teste --> 37 
teste  &  teste --> 38 
teste  '  teste --> 39 
teste  (  teste --> 40 
teste  )  teste --> 41 
teste  *  teste --> 42 
teste  +  teste --> 43 
teste  ,  teste --> 44 
teste  -  teste --> 45 
teste  .  teste --> 46 
teste  /  teste --> 47 
teste  0  teste --> 48 
teste  1  teste --> 49 
teste  2  teste --> 50 
teste  3  teste --> 51 
teste  4  teste --> 52 
teste  5  teste --> 53 
teste  6  teste --> 54 
teste  7  teste --> 55 
teste  8  teste --> 56 
teste  9  teste --> 57 
teste  :  teste --> 58 
teste  ;  teste --> 59 
teste  <  teste --> 60 
teste  =  teste --> 61 
teste  >  teste --> 62 
teste  ?  teste --> 63 
teste  @  teste --> 64 
teste  A  teste --> 65 
teste  B  teste --> 66 
teste  C  teste --> 67 
teste  D  teste --> 68 
teste  E  teste --> 69 
teste  F  teste --> 70 
teste  G  teste --> 71 
teste  H  teste --> 72 
teste  I  teste --> 73 
teste  J  teste --> 74 
teste  K  teste --> 75 
teste  L  teste --> 76 
teste  M  teste --> 77 
teste  N  teste --> 78 
teste  O  teste --> 79 
teste  P  teste --> 80 
teste  Q  teste --> 81 
teste  R  teste --> 82 
teste  S  teste --> 83 
teste  T  teste --> 84 
teste  U  teste --> 85 
teste  V  teste --> 86 
teste  W  teste --> 87 
teste  X  teste --> 88 
teste  Y  teste --> 89 
teste  Z  teste --> 90 
teste  [  teste --> 91 
teste  \  teste --> 92 
teste  ]  teste --> 93 
teste  ^  teste --> 94 
teste  _  teste --> 95 
teste  `  teste --> 96 
teste  a  teste --> 97 
teste  b  teste --> 98 
teste  c  teste --> 99 
teste  d  teste --> 100 
teste  e  teste --> 101 
teste  f  teste --> 102 
teste  g  teste --> 103 
teste  h  teste --> 104 
teste  i  teste --> 105 
teste  j  teste --> 106 
teste  k  teste --> 107 
teste  l  teste --> 108 
teste  m  teste --> 109 
teste  n  teste --> 110 
teste  o  teste --> 111 
teste  p  teste --> 112 
teste  q  teste --> 113 
teste  r  teste --> 114 
teste  s  teste --> 115 
teste  t  teste --> 116 
teste  u  teste --> 117 
teste  v  teste --> 118 
teste  w  teste --> 119 
teste  x  teste --> 120 
teste  y  teste --> 121 
teste  z  teste --> 122 
teste  {  teste --> 123 
teste  |  teste --> 124 
teste  }  teste --> 125 
teste  ~  teste --> 126 
teste    teste --> 127 
teste  €  teste --> 128 

[Porva]

Completing

But in Excel is the numbering with an invisible symbol at the front (as if it were a squatter), then Excel "thinks" that is text and non-numerical, and does not detonate the value of the Cell that by default is in the 'general' format, rather than number.

[velozo_braga]

Guys, thank you for the topic!

helped me a lot, but I wanted to expose my scenario and how it was solved, it will certainly be a new solution alternative:
At first the solution above solved my problem, bank account camps that were spoiling numeric value.

The new: The banking system did not accept the "space" in front!

stake "0" Again, I needed a new solution and there she goes:

In the RTF file, in the text of the help, in the numeric field you want Do not ruin, include the following code:

Select all

<?xdofx:=||" || CAMPO_NUMERO ||"?>

and that's it!

ie, = "field_numero," we included a sign of equal and the field in double quotation marks, which makes Excel understand the number as a general format and will not ruin.

XDOFX: is the function of the Publisher XML so we can concatenate, that is, use || To join the characters.
Embrace,

Marcos Velozo Braga
Technical consultant PeopleSoft