Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
janardhan
Creator
Creator

extract

hi friends ,'

I have Object id like OTG123456_1

i need to extract only OTG123456

pls its Urgent

3 Replies
diegofcaivano
Partner - Creator
Partner - Creator

Hi. As far as I know, there is no way to access object properties from the application rather than VBScript module.

Where are you planning to place that piece of code? Can you give us further info?

sivarajs
Specialist II
Specialist II

use subfield('OTG123456_1','_',1)

fdelacal
Specialist
Specialist

hope it help you

If you have a field like  you can do it for the field

name of your field FIELD value xxxxx_x, yyyyy_y

=SubField(FIELD,'_',1)

=SubField(OTG123456_1,'_',1)

Hope it help you