Import using delimited text

[Former Member]

Hi All,

Can anyone send the link or any documents on how to import the data using the deleimted text format?

I tries to to import the data in delimited text format but was unble to find a way to split the fields which comes all in one line?

Thanks in advance

Regards

Nitin

[former_member188878]

Hi Nitin,

Please closed down the thread,if your your query is answered.

shankar

[mf_haq]

Hi,

It's very simple and MDM IM supports different formats like delimiter, Excel, DBMS etc.... If you want to import Delimiter format please follow the steps in sequence.

1. Log in to Import manager component with your user name and password

2. select the format which you want to import (For Ex: Delimiter)

3. select the file which you want to import

4. Delimiter is ;

Regards,

MF.Haq

[former_member207367]

Hi

Log in to Import Manager and select Delimited Text in the Type, select the remote system ,file and specify the Delimiter in the Delimiter text box. Import manager takes care of the rest....

Is your file Tab delimited file? then Delimiter will be " \t "

Check this and let me know...

regards

Sowseel

[former_member182007]

Nitin -

A new repository property was added which allows you to import text files that have quotation (") marks in them by changing the default value from True to False.

Right click on the repository in the MDM Console in the Repositories pane and select Properties.

Modify the property "Use CSV format to import delimited files" accordingly to your need.Set it to Yes.

Here

It is not possible to import files where the data contains both ' and ".

In such cases where your souce file contains both ' and " we would recommend that you convert the files into Excel sheets or XML format. This will enable you to import the files as desired without regard to either the ' or " being in the source file.

Hope it helps

thx

Deep

[Former Member]

Hi,

Refer the below thread

[http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/17496] [original link is broken] [original link is broken] [original link is broken];

Thanks,