Help

[nagarjuna_kotha]

Hi all,

I need one help

I have one Email field.that consist all emails Dvision ,region and Branch wise.But what i want is,i want to divide that email foeld into Division , region and Branch wise.

How to do that ?

can any one help me ......

Regards,

Naga

[arulsettu]

can you post sample data

[#3]

I guess, subfield() will help, but I agree with Arul, can you provide some rows of your data?

[#4]

You can use SubField() function if the email has any delimiter or left/Mid function if the email has fixed number of character for each category.

If you post any sample data will help to find the exact problem.

[avinashelite]

if you have a separator for all the  fields than try like this:

subfield(fieldname,separator,position of the field)

eg:

subfield(fieldname,'-',2)

here separator is - , similarly it can be , - : anything

2, if the position after the separator  

[jagan]

Hi,

Try like this

Note: assuming that - as separator of email IDS

LOAD

*,

Subfield(EmailID,'-',1) AS Dvision ,

Subfield(EmailID,'-',1) AS region,

Subfield(EmailID,'-',1) AS  Branch

FROM DataSource;

Hope this helps you.

Regards,

jagan.

[thimma_paul]

Hi Can you please give some sample data, so that, we can look on it.