Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Biztalk
acce.forsuppliers
acce.hipaa
acce.hl7
acce.rosettanet
accelerator.finserv
admin
appintegration
framework
general
library
nonxml
orchestration
sdk
server
setup
tools
xlangs
xsharp
  
 
date: Thu, 5 Jan 2006 14:11:03 -0800,    group: microsoft.public.biztalk.nonxml        back       


Tricky Flat File Escape Sequence   
I have a flat file that uses Quotes to wrap strings, but it also uses allows 
inline quotes like in the following line.  Any ideas on how I can escape this 
sequence?

"ABC",2284,"Outer String has quotes inside "inner string" end outer string.",0
date: Thu, 5 Jan 2006 14:11:03 -0800   author:   tjhazel

RE: Tricky Flat File Escape Sequence   
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs20 Because you don't have an escape character within the quoted string, I don't believe you'll be able to use the quotes as the wrap character for these fields.  I think the easiest approach would be to use a map to parse off the quotes.  Another alternative would be to use a custom pipeline component that will strip off the leading and trailing quotes.
\par 
\par Hope that helps... let us know if you need additional information.
\par 
\par --
\par Dave
\par 
\par This posting is provided "AS IS" with no warranties, and confers no rights.
\par }
date: Mon, 09 Jan 2006 17:08:44 GMT   author:   (David Downing [MSFT])

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us