Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Parsing flat files

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-07 : 11:58:23
Ricky writes "Hi there,

I appreciate you reading this question. My question is:

If I have a flat file that have data to be parsed, what is the best approach if any?

For example, filea.txt has these data:

12   ABC Company      19 My Way St.        Orange FL ....
4533 Acme Inc. 2342 This Way. Ave. RSM CA ....

.
.
.

You know what I mean there? It looks like a TAB Delimited values that I can use? Am I in the right path here?

Also, can I convert HEX to ASCII if the flat files have them in?

Thanks.

Ricky"
   

- Advertisement -