Depends on file size. If small I'd use the vi editor, or vim and :set et before making a general change like :%s/./&/ If big then I'd write a VB program 'cause I'm in Windows which lacks utilities. If you are in UNIX maybe you could use rhe tc(C) or sed(C) filters. But if your data has tabs maybe it's delimited and then you can use another input format. It it's not as much delimited as you want, you might consider loading a temporary table and then SELECTing into the *real* table maybe breaking one column into several new columns using DB2 SQL functions to extract substrings and casting. HTH Juan Lanus TECNOSOL
kishore lingamallu wrote: > > Hi > > I am trying to import tab delimited data file using method L and > specified the positions obviously the import is not reading the > positions correctly as the tab character are found in between the > column data. > > What can I do replace all tab character and preserve the data alignment? > > Kish > > > > > _________________________________________________________________ > Get your FREE download of MSN Explorer at > http://explorer.msn.com/intl.asp > > > ===== > To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > For other info (and scripts), see > http://people.mn.mediaone.net/scottrmcleod > > > ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
