add computed column based on first letter of previous column

[Kran]

Hi all,

I would like to add an indicator column named 'Zone' for postcode data for  'From' and 'To' in my shipment dataset.

These columns are of character format.

I have data as below:

ShipmentID    Typeofservice   From     To       Quantity      Price

     xx1                    y              1010     2010        5               100

     xx2                    y              3030     1050        4               80

     xx3                    z              2010     4050        4               100

     xx4                    y              7050     1010        2               150

so above I would like to create a column named Zone dependent on the first letter of the From and To columns..

which means

1000 - 1999 is zone 1...

2000-2999 is zone 2

3000-3999 is zone 3 and so on...

Thank you in advance for any help!

[Kurt_Bremser · Accepted solution]

zone_from = substr(left(from),1,1));

The left() function left-adjusts the contents and so eliminates any leading blanks, if such were present.

[Kran]

brilliant! thanks Kurt 🙂