Sample Header Ad - 728x90

Looking for solution to add double quotes in field which has commas in SSIS

0 votes
1 answer
3533 views
I have a field called something like TYPE & the values are variant in it. I want the SSIS to export the result to CSV & while exporting, if it finds the , in column TYPE only that line/value should be double quoted. Eg: TYPE Begin Bag 1,000 mL Miscellaneous 20ml Final 2,000 mL Begin Bag 1 mL the result should be (in the csv format exported): TYPE "Begin Bag 1,000 mL", Miscellaneous 20ml, "Final 2,000 mL", Begin Bag 1 mL I tried using the Derived column "\""+ TYPE +"\"" but that just adds Double quotes to every value for column TYPE. Please help! THanks, Atulya
Asked by Atulya (1 rep)
Dec 4, 2018, 08:49 PM
Last activity: Jan 29, 2019, 12:38 AM