Originally posted by: edi1999

I have a user that wants to send comma delimited files but wants us to be able to handle text strings in double quotes where users type commas in their notes.  Is that possible?

Can this be mapped without WTX seeing the coma in the quotes as a delimiter?

001,Test file, "This file, that I created, is a test only",ABC123,123456

Thanks.

Originally posted by: paul.brett

Yes, it is possible.  All you need to do is mark that field with an initiator and terminator, and it will suspend looking for delimiters until it finds the terminator.

An example is included.

Thank-you.

Paul.

Follow me on Twitter

Attachment(s)

comma.zip   10 KB 1 version

Originally posted by: edi1999

Awesome.  Thanks Paul.