Muhammad Ali
26th January 2011, 15:26
Dear
I want to print text field in item master, text data within in bracket, like [Item .... ..........................Text]
kindly tell me how to chek bracket start & end in text filed tiitm001.txta
if you know please reply
Thanks in Advance
Regards
Ali
bdittmar
26th January 2011, 15:58
Dear
I want to print text field in item master, text data within in bracket, like [Item .... ..........................Text]
kindly tell me how to chek bracket start & end in text filed tiitm001.txta
if you know please reply
Thanks in Advance
Regards
Ali
Hello,
store the textline temporarily to a variable and analyze the variable for "[" and "]" with pos() function.
----------------------------------------------------------------------
Something like :
select tttxt010.*
from tttxt010
where tttxt010._index1 = {:p_item.text, "3"}
selectdo
textline = strip$(shiftl$(tttxt010.text))
if tttxt010.text(1;17) = "<Labeldefinition:" then
kundentyp = textline(pos(textline,"<Kd-Typ:")+8;
pos(textline,"<Kd-Nr")-pos(textline,"<Kd-Typ:")-9)
kundennr = textline(pos(textline,"<Kd-Nr:")+7;
pos(textline,"<In1:")-pos(textline,"<Kd-Nr:")-8)
endif
endselect
-----------------------------------------------------------------------
Regards
rahul.kolhe22
27th January 2011, 06:24
Hi Ali,
We can also use function text.to.buff instead of querying tools tttxt010 table to get the text into a string variable. This returns all the text data in two dimensional array field.
We can then traverse the array field and use the logic suggested by Bernd to find the character '[' & ']'.
Hope it helps.
Regards,
--Rahul