Subfield

[upaliwije]

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]

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

[upaliwije]

pls write the syntax for sub field function

[its_anandrjs]

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]

The syntax are:

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

Example:

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

[MK_QSL]

can you exactly tell us how the data are there?