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
Last activity: Jan 29, 2019, 12:38 AM