Absolutely no idea what that's suposed to be - I think your best bet
is a robust regular expression here (or perhaps an afternoon with RTFM
in collaboration with their IS department ?)

Cheers - Neil

On Tue, 03 Jul 2007 09:29:53 -0700, tekiegreg
<codesweeper@c...> wrote:

>For a new project I'm starting for a major restaurant, I've got do
>determine what the below file is producing and get it into a standard
>format (preferably XML) for DB Work.  However I really don't have much
>of an idea of what I'm dealing with and I'm hoping someone here
>recognizes the file, any takers?  Note what could be potentially
>damaging financial info is obfuscated to protect the innocent:
>---
>SHOPDR9999DRD FINANCIAL FILE
>01040FCLO9999000106302007YJohn Doe
>01020FCOM9999000106302007
>01095FFIN999900010630200707270036234000000000000000+000000000009530000000-00000391000000000000000000036234003658700000000
>01048FSAL9999000106302007BEER        0000000000009999
>01048FSAL9999000206302007WHOLE PIES  0000000000009999
>01048FSAL9999000306302007PREMIUM     0000000000009999
>01048FSAL9999000406302007SLICED PIE  0000000000009999
>01048FSAL9999000506302007FOOD        0000000000999999
>01048FSAL9999000606302007DESSERTS    0000000000099999
>01048FSAL9999000706302007EXCL TAX    0000000000099999
>01048FSAL9999000806302007INCL TAX    0000000000099999
>01048FTEN9999000106302007GIFT CERT   0000000000099999
>01048FTEN9999000206302007VISA/MC/DISV0000000000999999
>01048FADJ9999000106302007MGR. MEALS  0000000000009999
>01048FADJ9999000206302007EMP MEAL DIS0000000000009999
>01048FADJ9999000306302007PROMOS      0000000000000999
>01048FADJ9999000406302007FRIEND ASSOC0000000000000999
>01048FADJ9999000506302007FRNDS/FAM 250000000000000999
>01048FADJ9999000606302007ADVO FREE KI0000000000000999
>01036FDEP99990001063020070701200700999999
>01089FSFT9999000109999999999999999.9999999.9999999.9999999.9999999.999999999999999999999999999
>01058FMSL999900099999999999999999999999999999999999999999999999
>01027FSUM9999000999999999FCLO001
>TRLRDR9999DRD FINANCIAL FILE 000025
>SHOPDR9999DRD FINANCIAL FILE
------------------------------------------------
Digital Media MVP : 2004-2007
http://mvp.support.microsoft.com/mvpfaqs