cancel
Showing results for 
Search instead for 
Did you mean: 

Regarding Importing Text file

Former Member
0 Kudos

Hi All,

I want to import the Text file which contains the " tab" as Deliminator.

I am not able to import this file as I can not put " Tab" in check box provided on Import manager screen while importing the file.

Kindly advise on the same.

Regards

Rahul Kulkarni

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks Rahul

One suggestion from my side is that please reward the points according to the answer just to motivate the contributors to reply to your further queries.

Former Member
0 Kudos

Hi Rahul,

For importing Tab Delimited file first Select the Type=Delimited Text and enter the delimiter as \t.

Thanks & Regards,

Jitesh Talreja

Former Member
0 Kudos

Hi Jitesh.

Thanks for your reply.

Regards

Rahul

Former Member
0 Kudos

Hi Rahul,

As far as my understanding.

While importing a .txt file we can specify one of the delimiter among (, | ; )which can be entered by the keyboard.

As for Tab as a delimiter it will not allow you to enter Tab in your import manager Delimiter field.As Tab has a different functionality when it is working with the import manager window,it will move the cursor to the next field whn you press Tab instead of specifying it as a delimiter as this Tab key is working acc to the Windows functionlaity.

Unlike Importing when we are syndicating our master data we can specify TAB as a delimiter along with it we can also specify (, ; | custom ) etc.

Hope it helped

Thanks & Regards

Simona