Problem With Header

Question

Problem With Header

preensheen

Ten Centuries

Points: 1362
More actions
October 20, 2010 at 10:01 am

#147382

Hi All,
I am passing a departname in the header. And my departname as comma in it. Example : Expense,Sales
Since I am loading the data to the CSV. Expense and sales are getting separated where as i want them to be together by adding Qquatations to the string like " Expense,Sales". But I am not sure of how i can do this task. Please give me Ideas.
Thanks,
Preensheen

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

If you specify a data qualifier in your export, all of the fields will be enclosed in quotes (or whatever character you choose for it).

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

preensheen Ten Centuries Points: 1362 More actions · Answer 2

GSquared (10/20/2010)
If you specify a data qualifier in your export, all of the fields will be enclosed in quotes (or whatever character you choose for it).

I did have specified the tect qualifier to my CSV export but ..it doesn't work for header.

Please give me suggestions on the best way I can resolve my issues.

GSquared SSC Guru Points: 260824 More actions · Answer 3

How are you building the header? If I remember correctly, you're using a local variable to do that. Can't you just add the quotes in the code where you build the header?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

preensheen Ten Centuries Points: 1362 More actions · Answer 4

GSquared (10/20/2010)
How are you building the header? If I remember correctly, you're using a local variable to do that. Can't you just add the quotes in the code where you build the header?

My header is Dynamic, I will be storing the value coming from foreach to a variable and then pass that variable as the header. So I can't add the quotes when passing. If we can..please do tell me the steps.

Thanks for the support

Preensheed

Phil Parkin SSC Guru Points: 246960 More actions · Answer 5

Can you side-step the problem by replacing commas in your header variables with some other character before they are output? Or by using a different column delimiter everywhere else (eg ¦)?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

GSquared SSC Guru Points: 260824 More actions · Answer 6

preensheen (10/20/2010)
GSquared (10/20/2010)
How are you building the header? If I remember correctly, you're using a local variable to do that. Can't you just add the quotes in the code where you build the header?
My header is Dynamic, I will be storing the value coming from foreach to a variable and then pass that variable as the header. So I can't add the quotes when passing. If we can..please do tell me the steps.
Thanks for the support
Preensheed

SSIS has functions in it for concatenating strings. How you do it depends on how exactly you're building the header.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

preensheen Ten Centuries Points: 1362 More actions · Answer 7

GSquared (10/21/2010)
preensheen (10/20/2010)
GSquared (10/20/2010)
How are you building the header? If I remember correctly, you're using a local variable to do that. Can't you just add the quotes in the code where you build the header?
My header is Dynamic, I will be storing the value coming from foreach to a variable and then pass that variable as the header. So I can't add the quotes when passing. If we can..please do tell me the steps.
Thanks for the support
Preensheed
SSIS has functions in it for concatenating strings. How you do it depends on how exactly you're building the header.

John Rowan SSC Guru Points: 56440 More actions · Answer 8

Why can't you just include the double quotes in with the header variable? How are you getting the header variable into the file?

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

preensheen Ten Centuries Points: 1362 More actions · Answer 9

John Rowan (10/28/2010)
Why can't you just include the double quotes in with the header variable? How are you getting the header variable into the file?

Thanks a lot for all your support..I was able to resolve it by the way you mentioned it.