TextBetween

[vardhan1305]

I need to create a column XXX where i should get the Number/text  between the text.

KeepChar(name, '0123456789')  worked for 2 scenarios and i need to apply for the other one too.

id         state         name                                                  XXX

abc        BC       alb - ik me (abc def)(1234)                      1234

abc        BC       alb - ik me (abc def)(1234)                      1234

abc        BC       alb - ik me (1234)                                     1234

abc         BC      alb - ik me (1234)                                      1234

abc       BC       alb - ik me (pittsburgh)                           pittsburgh

Please help me out

[santhana]

hi harsha vardhan use this

purgechar(subfield(name,'(',-1),')') as XXXX,

[neelamsaroha157 · Accepted solution]

check this -

Replace(mid(name, (Index(Trim(name), '(', -1)+1), (Index(trim(name), ')', -1)-1)), ')','')

[vardhan1305]

Thanks Neelam. The logic  worked

[swuehl]

Since you called your post TextBetween, there is indeed a QV function TextBetween(), so another option could be

TextBetween(name, '(',')',SubStringCount(name,'(')) as newfield