Hi all,
I have a request in which we need to process a file deliverd by business (CSV).
I've configured the sequential file stage to "Record delimiter string: DOS" , and the section Field Defaults: "Delimiter= |"
The problem is that the column "process" can have a carriage return, and they also want to see this carriage return in the database to which we need to upload the file.
Example of the file record:
"<NULL>"|"<NULL>"|"False"|"12:00 u"|"<NULL>"|"Access"|"Tabel: Pakketten Sales per channel^M
Excel: C+ migraties in input sheet IDTV"|"<NULL>"|"
In vi i can see that there is also a ^M present in the column itself. I've tried different settings but the record is always send to the reject link with following warning:
Sequential_File_0,0: Input buffer overrun at field "Process"
My question is: Is the sequential file stage able to read records where a column in the file contains a carriage return ? And if so, what settings do you need to use in the stage ?
Thanks for any info you can provide.
Read sequential file with ^M in record
Moderators: chulett, rschirm, roy
But doing that would remove the carriage return from the string.
But business still wants to see the carriage return in database.
So
Tabel: Pakketten Sales per channel^M
Excel: C+ migraties in input sheet IDTV"|"<
needs to be stored in the database as
Tabel: Pakketten Sales per channel
Excel: C+ migraties in input sheet IDTV
But business still wants to see the carriage return in database.
So
Tabel: Pakketten Sales per channel^M
Excel: C+ migraties in input sheet IDTV"|"<
needs to be stored in the database as
Tabel: Pakketten Sales per channel
Excel: C+ migraties in input sheet IDTV
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
I guess you can overcome this issue when you define that particular field as LOB in table... Anyways, DB experts can give you more inputs..
When you have Control-M in LOB fields, DS handles them automatically.
Other way is to use Server job![Wink ;)](./images/smilies/icon_wink.gif)
When you have Control-M in LOB fields, DS handles them automatically.
Other way is to use Server job
![Wink ;)](./images/smilies/icon_wink.gif)
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!
Just want to make sure you're aware why that worked. It's because what you actually have there is a CR/LF pair. You see the CR in the data and the record break from the LF terminator. It's the LF that the option allowed you to ignore.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers