How can exclude the brackets with Subfield()-Funktion

[beck_bakytbek]

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

[OmarBenSalem]

Purgechar(Subfield (tech_id, ' , ', 1) ,'(')

[Somasundaram · Accepted solution]

try with this,

SubField(purgechar(tech_id,'('),',',1) as ID

works for me.,

[bhargav_bhat]

use
replace(Subfield (tech_id, ' , ', 1), '(' , '')

[beck_bakytbek]

Omar Thanks a lot for your Help and Time

[beck_bakytbek]

Thanks a lot for your help and time