| Author |
Positional Flat file
|
|
|
| Hi,
I need to output a positional flat file.
Each record in the file is 230 Characters in length.
I require the output to start a new line at position 75 of every record.
Does anyone know how i can achieve this?
Mangi.
| |
| Jeff Lynch 2005-06-27, 5:51 pm |
| Your output positional record can be two fields. The first is an empty field
padded with blanks. You can set the pad character to a "blank". The second
field begins at position 75 and contains your data.
--
Jeff Lynch
"A BizTalk Enthusiast"
http://codebetter.com/blogs/jeff.lynch
"Mangi" <Mangi@discussions.microsoft.com> wrote in message
news:471F3670-4EF1-4BB3-BFFC-A82B00D4110B@microsoft.com...
> Hi,
> I need to output a positional flat file.
> Each record in the file is 230 Characters in length.
> I require the output to start a new line at position 75 of every record.
>
> Does anyone know how i can achieve this?
>
> Mangi.
>
>
| |
|
| There is data up to position 75, effectively what i want to achieve is to
have a carriage return after position 75 and let the rest of the data from
position 76 to 230, continue on a new line.
"Jeff Lynch" wrote:
> Your output positional record can be two fields. The first is an empty field
> padded with blanks. You can set the pad character to a "blank". The second
> field begins at position 75 and contains your data.
>
> --
> Jeff Lynch
> "A BizTalk Enthusiast"
> http://codebetter.com/blogs/jeff.lynch
>
>
> "Mangi" <Mangi@discussions.microsoft.com> wrote in message
> news:471F3670-4EF1-4BB3-BFFC-A82B00D4110B@microsoft.com...
>
>
>
| |
| Jeff Lynch 2005-06-28, 5:52 pm |
| You should be able to map this into a delimited flat-file with two different
positional records each separated by CRLF. If you can attach your inbound
schema and an instance document I'd be happy to take a look.
--
Jeff Lynch
"A BizTalk Enthusiast"
http://codebetter.com/blogs/jeff.lynch
"Mangi" <Mangi@discussions.microsoft.com> wrote in message
news:7C688EFE-5706-4232-9F6A-0D25B2B2019A@microsoft.com...[vbcol=seagreen]
> There is data up to position 75, effectively what i want to achieve is to
> have a carriage return after position 75 and let the rest of the data from
> position 76 to 230, continue on a new line.
>
> "Jeff Lynch" wrote:
>
|
|
|
|