topic Re: To break a field value in App Development

To break a field value

upaliwije — Fri, 15 Mar 2019 05:25:00 GMT

Hi Friends

I have following data in a column

MAKE_MODEL

TOYOTA AURIS
TOYOTA AT-211
TOYOTA AT211
TOYOTA AQUA-DAA-NHP10
TOYOTA AQUA G HYBRID
TOYOTA AQUA
TOYOTA ALTEZZA
TOYOTA ALPHARD

I want to split it into two columns as shown below

Kindly help me to do it in my data load script

crusader_ — Fri, 15 Mar 2019 05:35:40 GMT

Hi,

try below:

left(MAKE_MODEL,index(MAKE_MODEL,' ',1)-1) AS MAKE

mid(MAKE_MODEL,index(MAKE_MODEL,' ',1)+1) AS MODEL

Hope this helps

//Andrei

marcohadiyanto — Fri, 15 Mar 2019 06:00:48 GMT

You can use subfield function. example subfield(MAKE_MODEL,' ' ,1) as MAKE, subfield(MAKE_MODEL,' ' ,2) as MODEL.

More info:

SubField(text, delimiter[, field_no ])

Thanks

upaliwije — Fri, 15 Mar 2019 06:08:16 GMT

Thanks Both of You