AnsweredAssumed Answered

Importing tab deliminated txt.file

Question asked by GeraldJourneau on Mar 29, 2012
Latest reply on Mar 29, 2012 by philmodjunk


Importing tab deliminated txt.file


Importing a Tab-separate txt.file  with a field which consist of different values, they are entered with a comma seperating each value, 

eg: [EQUIP, FXT, GWILL, NAME] which i need to convert it to read: [Equipment, Fixtures, Goodwill, Company Name] my problem is that the order it comes with does not always match, it comes in different orders all the time. eg:  NAME,EQUIP,FXT,GWILL how do I ensure my outcome will always be the same. The order changes all the time.

Any Ideas would be helpful, willing to try anything. Gerald