If it's a proper CSV there will be a comma between the fields.
It might be a TSV, meaning that there's a <tab> between the fields
It definitely won't be space delimited, because as you can see there's spaces used with the country field.
Thanks for the clarification on csv files, however its not TSV, can we do
something to split it in 3? when I do custom split and separate out last
and first, then the remaining one should have been fine, but the problem is
that after custom split, the original stays the same.
I am looking at calculated field to do the same. Any idea will be welcome.
On Tue, Feb 6, 2018 at 7:23 AM, Chris McClellan <
Can you upload the file ? (or a few sample records ?) that's the only way you're going to get the right answer
Thanks a lot, that certainly helped. It worked perfect.