‎2007 Jun 04 12:38 PM
Se38 editor.........
tables: qamr.
data: prueflos, mittelwert, pruefbemkt.
select querry....
O/p will come:
For ex:
prueflos PRUEFBEMKT MITTELWERT
40000000764 R 9.2
40000000764 Y 7.5
40000000764 B 4.8
40000000764 Y 3.4
40000000764 R 9.0
Now I want it in this format....
PRUEFBEMKT
prueflos R Y B K
40000000764 9.2 - - -
40000000764 - 7.5 - -
40000000764 - - 4.8 -
40000000764 - 3.4 - -
40000000764 9.0 - - -
Can anyone help me in this.....
‎2007 Jun 04 12:46 PM
Hi,
You can use field symbols or
IF condition in write statemet.
regards
arun
‎2007 Jun 04 12:58 PM
hi
good
as far as you requirement is concerned you want ot replace the letters with - in that case you can use the REPLACE statement .
REPLACE str1 WITH str2 INTO c [LENGTH len].
REPLACE sub_string WITH new INTO dobj
[IN {BYTE|CHARACTER} MODE]
[LENGTH len].
before using the REPLACE statement you need to store that particular value in a string and after getting the string length you can use the replace statement to replace that particualar character.
thanks
mrutyun^