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