Analytics Software

Hi Experts ...

I have a sample grid which has line item details and cell text entered. When i try extracting the data , i am getting the extract in the format as below:

!DATA

!LINE_ITEM_DETAIL

Actual;2013;January;Periodic;[None];[None];111010;[ICP None];[None];[None];[None];[None];10000;"Sample";

!DESCRIPTIONS

Actual;2013;January;Periodic;[None];[None];111010;[ICP None];[None];[None];[None];[None];"[Default]~Test123"

!DATA

where :

Sample = Line Item Description

10000 = Line Item Value

Test123 = Cell Text

Options selected while extracting :

Cell text

Line Item Details = Individual Line Items

Extract Format = Without Header

But if i try loading this .DAT file to another application, i am getting error as :

Line : 3, Error:Token should be enclosed in double quotes.

I tried changing the .DAT file as

!DATA

!LINE_ITEM_DETAIL

Actual;2013;January;Periodic;[None];[None];111010;[ICP None];[None];[None];[None];[None];"Sample";10000

!DESCRIPTIONS

Actual;2013;January;Periodic;[None];[None];111010;[ICP None];[None];[None];[None];[None];"[Default]~Test123"

!DATA

This time the loading was successful..

Can any one suggest me if there is any method by which we can get the .DAT file extract in this format from HFM ?

Thanks in advance!