LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Cleaning some blob data

I need to do a little file manipulation with VBA

I am pulling blob data out of ms sql server using text copy, the files
are jpeg files that have had tags added to the front of the file, and
of course could be fairly big.

I know that the actual jpeg begins with a particular 4 characters, so I
could identify how many characters into the file i have the real file
starting.

Now if this was a string, I would just use instr to find the start and
right(x$,len(x$)-instr(1,x$,instr$)) to get the data. But this is too
damn big for that method.

Any suggestions? Do I have to do this character by character? if so I
could use a little help with how.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cleaning data Torero Excel Worksheet Functions 3 November 28th 06 10:16 PM
Cleaning Data AMMark Excel Discussion (Misc queries) 1 October 19th 06 07:21 PM
Cleaning Up Data [email protected] Excel Discussion (Misc queries) 3 September 20th 06 04:40 PM
saving blob ntt123 Excel Programming 1 October 10th 05 04:28 AM
Cleaning up data ali Excel Programming 5 December 23rd 03 04:22 PM


All times are GMT +1. The time now is 11:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"