FW: Embedded carriage return in PC data

[Bruce Schuck]

Well ... you could always define a field with length of 2047 call
field2047 and a variable length record called record2047.

Then, when you write out the text file, make sure the fields are NOT
variable length and make sure they are 2047 long in Access:

sString2047 = string(2047," ")
sString2047 = sRealData       ' the actual data


Then ignore character 2047 when you read the file with quiz or whatever.

Bruce Schuck


> -----Original Message-----
> From: powerh-l-admin@cube.swau.edu
[mailto:powerh-l-admin@cube.swau.edu]
> On Behalf Of Jeff Hoffman
> Sent: March 18, 2002 12:51 PM
> To: powerh-l@lists.swau.edu
> Subject: Embedded carriage return in PC data
> 
> G'Day
> 
> Sorry for this non PH question butttttt....
> 
> I am using VMS variable length file to read data from an Access data
base.
> 
> CR's are embedded in the data, they are being treated as end of
record.
> 
> Has anybody got some advice (politely please) of a way to detect and
> remove
> these before I access this file with PH?
> 
> Thanks
>
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+-
> +-+
> + Jeff Hoffman                          + e-mail:
wonicon@optushome.com.au
> +
> + Director                              +
> +
> + WoniCon Pty Ltd   (ABN 93 083 502 630)+
,-_|\
> +
> + 21 Prices Circuit                     + voice: +61 2 9542 1527  /
\
> +
> + Woronora    NSW     2232              +
\_,-._*
> +
> + AUSTRALIA                             + mobile: 040 790 3929
v
> +
>
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+-
> +-
> +
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe" in message body to powerh-l-
> request@lists.swau.edu
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a
subscriber.