Creating Table via Link

[DBFIN]

I've created a table via a link to a csv file using advanced specifications. The specifications interpret the data in delimited format using a comma delimiter to separate fields. If a field already includes a comma in the middle of the value, such as "Robert Cooney, Senior", the linking process splits the field into two fields instead of one and shifts all the remaining data (please see yellow highlights in file attachment).

How can I avoid this problem ? The field value should be only one field.

 

[ByteMyzer]

Specify the " as your Text Qualifier in your Specification.

 

[DBFIN]

That worked fantastically ! Could you explain why this works ?

 

[ByteMyzer]

The Text Qualifier qualifies a delimiter as a text character. The leading TQ says, "Interpret any successive instances of the delimiter as a text character." The trailing TQ says, "Interpret any successive instances of the delimiter as a delimiter."

 

[DBFIN]

Thank you so much. Your expertise is greatly appreciated !!

 

[ByteMyzer]

You're very welcome, I'm glad it worked for you.