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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Subfield

Hi Friends

HEAD LIGHT, COWLIN, CRASH BAR, FOOT REST, LEFT MIRROR, FRONT & REAR LEFT SIGNAL LIGHTS  RIDER: MR. D.N.SANJEEWA                                                 
REAR LEFT SIDE SIGNAL LIGHT DAMAGE [DRIVER MR.GUNASENA]                                                                                                         
FRONT LEFT FENDER  DRIVER: MR. FAHIM (OWNER)                                                                                                                    

I have above data in a field of data table

Can Someone tell to extract above spare parts and store them in a separate filed

6 Replies
ecolomer
Master II
Master II

Yes, use SUBFIELD function

PrashantSangle

Hi,

It is easy and better if you maintain all Spare parts in Excel Sheet or in Inline Table

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
upaliwije
Creator II
Creator II
Author

pls write the syntax for sub field function

its_anandrjs
Champion III
Champion III

Use Subfield function for this see the examples

Examples:

(For three parameters)

subfield(S, ';' ,2) returns 'cde' if S is 'abc;cde;efg'

subfield(S, ';' ,1) returns NULL if S is an empty string

subfield(S, ';' ,1) returns an empty string if S is ';'

Please provide exact field name with the sample data.

ecolomer
Master II
Master II

The syntax are:

subfield(field, 'separator' [ , índex] )

Example:

subfield(S, ';' ,2) return 'cde' if S is 'abc;cde;efg'

MK_QSL
MVP
MVP

can you exactly tell us how the data are there?