lookup help

[changwoo]

i am trying to import a .csv but it is in txt format

and it is seperated with :: not ,

do i have to change :: to , ???

does only .csv file reads with , ?

[lukejadamec · Accepted solution]

A lookup can be either space or comma delimited. It cannot be :: delimited. You could open the file in wordpad or word and use find-replace :: with ,.

After you make the changes, save the file as a .csv.

[changwoo]

Thanks for your help~!!!!! it works great