+1-888-319-3663

COMMUNITY FORUM

Eliminate Quote Symbols from Imported Data

callen asked 7 years ago

I’m getting data from a text file that includes double quote symbols (“) around a field. This is the item description. When the data imports, you see “White Cord” instead of White Cord. I am regrettably not that gifted with either vb.net or C# coding. How can I handle the removal of these quote symbols around the item description source field? Thank you

Answers

0 Vote Up Vote Down

Best Answer

lorren answered 7 years ago

Callen,

You would have to create a calculated field that simply replaces the double-quotes.

return _FIELDNAME.Replace("""",string.Empty)

Then use that calculated field for the mapping.

If you would like to submit an answer or comment, please sign in to the eOne portal.