Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
i got a Situation, where i have the following data:
tech_id:
(121516, 2, 3)
(45784569, 2, 3)
i used the SubField-Funtcion like: Subfield (tech_id, ' , ', 1) as ID to get the Value such: 121516, 45784569, but after script reload i have ths follwing data: (121516, (45784569.
How can i exclude the brackets?
Does anybody have any ideas?
Thanks a lot
Beck
try with this,
SubField(purgechar(tech_id,'('),',',1) as ID
works for me.,
Purgechar(Subfield (tech_id, ' , ', 1) ,'(')
try with this,
SubField(purgechar(tech_id,'('),',',1) as ID
works for me.,
Omar Thanks a lot for your Help and Time
Thanks a lot for your help and time