How to separate Date and Month

[mandilicious]

Hi All

I have data as below i would like  to separate them like to have only Month(Jul,May,Oct,Sep etc ) and year(2015 and 2016)

Company:

LOAD Field,

     [Jul-Sep 2015],

     [May-Aug 2015],

     [Oct-Dec 2015],

     [Jan-Mar 2016]

from

C:\Users..........

Thanks

[tresesco]

Are these dates, names of fields, or values of a field? Could you share a sample data set and expected output?

[mandilicious]

Hi Tresesco

This are values of a field my Expected output it must be separated like below

Month          

Jan

Sep

May

Aug

Year

2015

2016

[tresesco]

Could you explain the real scenario with sample data with few more fields? If you have a value " [Jul-Sep 2015]", do you really want three separate line items out of it?

[ishanbhatt]

Hi Dorlane,

Try to load data using Cross Table functionality and then use Subfield, Keepchar or left function to create Month and Year fields.

[mandilicious]

Hi Tresesco B

Yes i actually need  three separate line items out of it?

I have attached how my data look likes.

Thanks