Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Are these dates, names of fields, or values of a field? Could you share a sample data set and expected output?
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
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?
Hi Dorlane,
Try to load data using Cross Table functionality and then use Subfield, Keepchar or left function to create Month and Year fields.
Hi Tresesco B
Yes i actually need three separate line items out of it?
I have attached how my data look likes.
Thanks