Removing the Default Wrap Character From all records

Posted by aceinthehole on Stack Overflow See other posts from Stack Overflow or by aceinthehole
Published on 2010-03-08T21:18:11Z Indexed on 2010/03/08 21:21 UTC
Read the original article Hit count: 234

Filed under:

BizTalk

|

biztalk-2009

I am using BizTalk 2009 and I have a flat file that is similar to the following

"0162892172","TIM ","LastName ","760 "," ","COMANCHE ","LN "

"0143248282","GEORGE ","LastName ","625 "," ","ENID ","AVE "

When I parse it and start mapping it I need to get rid of the quotation marks. I have marked the Wrap Character attribute for the schema as a quotation mark but it doesn't remove it when BizTalk is parsing the file.

Is there an easy way to specify the removal of a wrap character or am I going to have to run it through a script functiod every time? Also I would like to be able to remove the trailing spaces as well, if at all possible.

© Stack Overflow or respective owner

Related posts about BizTalk

Future of BizTalk

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
The future of BizTalk- The last TechEd Conference was a very important one from BizTalk perspective. Microsoft will continue innovating BizTalk and releasing BizTalk versions for “for next few years to come”. So, all the investments that clients have made so far will continue giving returns. Three… >>> More
BizTalk Server Monitoring – SharePoint Web Part

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
I have been worked with customers using BizTalk as shared infrastructure in the enterprise, where we have two or more BizTalk apps running on it for different Business groups. Also these customers are not using BizTalk ESB portal even though they are using BizTalk ESB exception framework. So main… >>> More
Useful Tips for BizTalk 2006 to BizTalk 2009 Porting

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
BizTalk projects require some manual intervention in order to upgrade them. Execute the following steps to port a BizTalk solution / project: Open the project’s solution file (.sln) using a text editor – NotePad++ is recommended. Remove all the contents (in red below) between (not including)… >>> More
TFS - How much nesting on disk structure

as seen on Stack Overflow - Search for 'Stack Overflow'
We just got TFS installed and ready go. I'm trying to decide on the disk structure. Let's suppose I have two BizTalk projects called Common and BookTransfer (in actuality I have 7). [At this client, we adopted the style of having schemas, orchs, maps in one project called BizTalk.Artifacts]. A folder… >>> More
BizTalk Server 2009 - Architecture Options

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
I recently needed to put forward a proposal for a BizTalk 2009 implementation and as a part of this needed to describe some of the basic architecture options available for consideration. While I already had an idea of the type of environment that I would be looking to recommend, I felt that presenting… >>> More

Related posts about biztalk-2009

Useful Tips for BizTalk 2006 to BizTalk 2009 Porting

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
BizTalk projects require some manual intervention in order to upgrade them. Execute the following steps to port a BizTalk solution / project: Open the project’s solution file (.sln) using a text editor – NotePad++ is recommended. Remove all the contents (in red below) between (not including)… >>> More
BizTalk 2009 - Naming Guidelines

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
The following is effectively a repost of the BizTalk 2004 naming guidlines that I have previously detailed. I have posted these again for completeness under BizTalk 2009 and to allow an element of separation in case I find some reason to amend these for BizTalk 2009. These guidlines should be universal… >>> More
BizTalk 2009 - Architecture Decisions

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
In the first step towards implementing a BizTalk 2009 environment, from development through to live, I put forward a proposal that detailed the options available, as well as the costs and benefits associated with these options, to allow an informed discusion to take place with the business drivers… >>> More
Automated builds of BizTalk 2009 projects using Team System 2008 Build

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to configure automated build of BizTalk 2009 projects using Team Foundation Server 2008. We have a staging server which has BizTalk 2009 installed. I ran the Team Foundation Server Build Setup on this server, and it can build non-BizTalk projects OK. However, BizTalk projects fail to build… >>> More
BizTalk 2009 fault when using POP3 adapter

as seen on Stack Overflow - Search for 'Stack Overflow'
Have anybody came across a problem with POP3 adapter in BT2009? When POP3 adapter is added to locations and assigned to port following errors in windows log appear. Error 1 Faulting application name: BTSNTSvc.exe, version: 3.8.368.0, time stamp: 0x49b1dadf Faulting module name: KERNELBASE.dll… >>> More