Contains Terminators
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 209
- Joined: Fri Jan 09, 2004 1:14 pm
- Location: Toronto, Canada
- Contact:
Contains Terminators
Folks,
I'm trying to find where in a parallel sequential file stage I can specify 'Contains Terminators' as I would in a server job.
Is there such a beast?
Rob Wierdsma
I'm trying to find where in a parallel sequential file stage I can specify 'Contains Terminators' as I would in a server job.
Is there such a beast?
Rob Wierdsma
Rob Wierdsma
Toronto, Canada
bartonbishop.com
Toronto, Canada
bartonbishop.com
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Contains Terminators
Wierd,rwierdsm wrote:Folks,
I'm trying to find where in a parallel sequential file stage I can specify 'Contains Terminators' as I would in a server job.
Is there such a beast?
Rob Wierdsma
I was also facing the same problem and opened the site to post the same message.. I saw your post. I know its wierd ( , sorry for the pun).
I am trying to solve the problem right now by writing a custom sql and using nested replace
Code: Select all
replace(replace(a.ADDRESS_ID ,chr(13)),chr(10))
10/11/2002 8:36:00 pm to just 11 OCT 02.. .
If you find a simpler way please let us know.
IHTH
-
- Premium Member
- Posts: 209
- Joined: Fri Jan 09, 2004 1:14 pm
- Location: Toronto, Canada
- Contact:
Re: Contains Terminators
Kris,kris007 wrote: If you find a simpler way please let us know.
IHTH
Unfortunately, my task does not allow me to remove the embedded carriage returns, I need to maintain the format of the large text fields I am receiving. As a result, any eventual solution is not likely to aid you in your situation.
I've been flipping between EE and Server to determine a solution, unfortunately, I need the functionality found in both!
Rob Wierdsma
Rob Wierdsma
Toronto, Canada
bartonbishop.com
Toronto, Canada
bartonbishop.com
Re: Contains Terminators
For those of us who have not used Server before, what is 'Contains Terminators'?rwierdsm wrote:Folks,
I'm trying to find where in a parallel sequential file stage I can specify 'Contains Terminators' as I would in a server job.
Is there such a beast?
Rob Wierdsma
Thanks for the info,
Brad.
It is "Sweet" option that is present in the Sequential file stage that lets it know that it is not a line terminator. And so the sequential file stage doesnt end the row there.
Use this to specify how End of Record (EOR) marks are to be treated in this column.
Use this to specify how End of Record (EOR) marks are to be treated in this column.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Rob, you can try writing a dos batch job that replaces all carrige returns with a space. Then reads in x number of characters (x= number of columns in a row) and characters would be your delimiter, and then put a carrige return. This way you can cleanse the data.
Just a thought. Not the best way but atleast something to fall back upon.
Just a thought. Not the best way but atleast something to fall back upon.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Re: Contains Terminators
In that case if the data is really not big or if performance is not a big criteria you might wanna use server jobs for that.rwierdsm wrote: I've been flipping between EE and Server to determine a solution, unfortunately, I need the functionality found in both!
Rob Wierdsma
or as DSGURU2B suggested, try prep'ing the data even before sequential file stage reads it.
-
- Premium Member
- Posts: 209
- Joined: Fri Jan 09, 2004 1:14 pm
- Location: Toronto, Canada
- Contact:
Re: Contains Terminators
Hi Kris,kris007 wrote:In that case if the data is really not big or if performance is not a big criteria you might wanna use server jobs for that.
or as DSGURU2B suggested, try prep'ing the data even before sequential file stage reads it.
I have been trying to solve this issue going down both paths, EE and Server. I'm actually leaning back to Server again.
Another option is to get the extract done in fixed width, however, some of the fields are LongVarchar(32700)
Most of the source rows will have many fewer characters than that and I don't want to bloat the file if it isn't necessary.
In terms of prepping the data, I can get the extract folks to give me whatever I want, however, first I have to find out what I want
Of course what I want is what will work in DS.....
Still kicking this one around......
Thanks for all your ideas, guys (and gals!)
Rob Wierdsma
Rob Wierdsma
Toronto, Canada
bartonbishop.com
Toronto, Canada
bartonbishop.com