Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
check this -
Replace(mid(name, (Index(Trim(name), '(', -1)+1), (Index(trim(name), ')', -1)-1)), ')','')
hi harsha vardhan use this
purgechar(subfield(name,'(',-1),')') as XXXX,
check this -
Replace(mid(name, (Index(Trim(name), '(', -1)+1), (Index(trim(name), ')', -1)-1)), ')','')
Thanks Neelam. The logic worked
Since you called your post TextBetween, there is indeed a QV function TextBetween(), so another option could be
TextBetween(name, '(',')',SubStringCount(name,'(')) as newfield