Hi Ron,

I am confused myself about your question.

I am not sure I understand the question.

I said I could dump the data that they asked for by using dts.

However, they want...

Thanks a lot Ron.

This is the sample data as requested by users.

doc_id|"docket_entry_id"|"document_nm"|"document_descr"|"document_type_id"|"document_perm_rem_flg"|"document_chkd_in_flg"

10|10|"Final Order"|"Orders: Final Order"|1|"N"|"N"

11|11|"Final Order"|"Orders: Final Order"|1|"N"|"N"

12|12|"Final Order"|"Orders: Final Order"|1|"N"|"N"

13|17|"Final Order"|"Orders: Final Order"|1|"N"|"N"

14|19|"Final Order"|"Orders: Final Order 19"|1|"N"|"N"

15|20|"Final Order"|"Orders: Final...

Yes, I am grateful to all of you for your assistance.

Reason I asked for that code is that I have dateA and dateB

So I am trying a conditional if or...

sorry but that is error'ing out.

Thanks for your help.

Thanks to all of you for your *ALWAYS* helpful attitude.

I really appreciate it.

I am still searching for forum for some helpful hints.

Hi Sturner, I indicated at the top why I...

Thanks a lot guys.

Your right Alvin, I would have liked SSIS but have not used it before.

Do you guys have any easy to follow example?

Thanks alot guys.

Thank you very much.

I really didn't nitially understand ALL the fun things your solution was doing until now.

I was able to append the insert bit.

Again, thanks for all your help.

Thank you very much.

I was able to modify the code to give me the column headers and values I am after.

I do want to make this more permanent though and...

Hi,

This data is exported to me from the mainframe by someone.

To ensure that I got each row of data *completely*, I got it to preview window and copied it from...

Any help on this, please?

Here is sample data.

IDNAMERELESTATE NODATE FILLEDPUBTYPE OF DOCUMENTBOOK TYPEBOOK NOPAGE NODISPOSITIONDISP DATE

1NULLNULL       090903  N  PETITION TO TERM GDNSHP MINOR   MIN   2962146GRANTED              90903

2ALBA, LOUIS R                   DEC   147112  080191  Y  APPN YEAR'S SUPPORT...

Hi John,

Thanks very much for the prompt response.

I don't quite understand what you mean by source file.

If you mean whether I have a script to do what I am asking...

Thank you very, very much Wayne for your help.

I have a quick question Wayne.

Why didn't I just do that for only name since that's the only one we are interested in displaying first value only while leaving the...