Re: [Axapta-Knowledge-Village] Import csv with newline character in string field.

2007-06-08 Thread Hemant Kumthekar
Hi,

When you are defining the field setup, you can also define on a tab prefix or 
suffix values to be attached during the import. Use \n as the character for new 
line for the Item Text field.  For more information see the help on this.

Hemant 



- Original Message 
From: Agus Riyadi [EMAIL PROTECTED]
To: axapta-knowledge-village Axapta-Knowledge-Village@yahoogroups.com
Sent: Thursday, June 7, 2007 10:27:15 PM
Subject: [Axapta-Knowledge-Village] Import csv with newline character in string 
field.

Hi All,

I need to import csv file into a table using definition group of type
custom.
The table has string field that allow multiline (e.g. item description) , so
there could be newline character in the field value.

The problem is when I try to put newline character in the csv file, it is
recognized as record delimiter, not as part of the field value as expected.
Axapta will treat the next string after newline as first field of new
record.
Any workaround please help.

Thanks

Regards,

Agus

[Non-text portions of this message have been removed]





   

Need a vacation? Get great deals
to amazing places on Yahoo! Travel.
http://travel.yahoo.com/

[Non-text portions of this message have been removed]



[Axapta-Knowledge-Village] Import csv with newline character in string field.

2007-06-07 Thread Agus Riyadi
Hi All,

I need to import csv file into a table using definition group of type
custom.
The table has string field that allow multiline (e.g. item description), so
there could be newline character in the field value.

The problem is when I try to put newline character in the csv file, it is
recognized as record delimiter, not as part of the field value as expected.
Axapta will treat the next string after newline as first field of new
record.
Any workaround please help.

Thanks


Regards,

Agus


[Non-text portions of this message have been removed]