topic Subfield in QlikView

Subfield

upaliwije — Sat, 04 Oct 2014 05:03:40 GMT

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

ecolomer — Sat, 04 Oct 2014 05:17:58 GMT

Yes, use SUBFIELD function

PrashantSangle — Sat, 04 Oct 2014 05:22:08 GMT

Hi,

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

Regards

upaliwije — Sat, 04 Oct 2014 05:32:35 GMT

pls write the syntax for sub field function

its_anandrjs — Sat, 04 Oct 2014 06:20:10 GMT

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 — Sat, 04 Oct 2014 06:36:16 GMT

The syntax are:

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

Example:

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

MK_QSL — Sat, 04 Oct 2014 07:20:38 GMT

can you exactly tell us how the data are there?