Hey guys,
I have a .csv file with 12 fields across(A, B, C, etc...) and 13,000 entries(down). I already have the formula to read the table and find a matching entry, but I am having trouble isolating the separate fields(separated by a comma)
Example: .csv file
1987,John Doe,9903 Meyer Drive,Los Angeles,CA,90212,etc...
How do I isolate the entries to get the values for each??
A = 1987
B = John Doe
C = 9903 etc...
I have a .csv file with 12 fields across(A, B, C, etc...) and 13,000 entries(down). I already have the formula to read the table and find a matching entry, but I am having trouble isolating the separate fields(separated by a comma)
Example: .csv file
1987,John Doe,9903 Meyer Drive,Los Angeles,CA,90212,etc...
How do I isolate the entries to get the values for each??
A = 1987
B = John Doe
C = 9903 etc...