How do you create an IIF file with emedded quotes
Item name is 1/4" Pipe
This truncates to 1/4 on import and creates a new unwanted item
Embedded quotes IIF file
Jun 07, 2005
2 Replies
Karl, rather than use quotes as the delimiter, why not used tabs, or commas (opens up a whole nother can of worms though)
Gary
The standard way in a CSV file is to quote the entire field and then double the quote chars you wish to keep:
raw / as CSV
Bob "BigGuy" McKenzie / "Bob ""BigGuy"" McKenzie"
1/4" Pipe / "1/4"" Pipe"If you're using tab-delimited IIF files, the same should work because oddly enough, IIF requires quotes when a field contains a comma in a tab-delimited file, which is not normally the case.
Let us know if it works.
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required