Hi: This is the original string.
strbuffer=2007022713495176690010323181
MTMASSTS03A20060913                              OMSS          HCS1

Can any one please tell me how to i change the above string

1.For Bankruptcyfilingdate           then MTMASSTS03A20060913 will be
MT+LNNSDT+CCYYMMDD
2.For BankruptcyCaseNumberValue      then MTMASSTS03A20060913 will be
MT+LNNLCN+Case#
3.For BankruptcyChapterNumberValue   then MTMASSTS03A20060913 will be
MT+MASBKC+Chapter#


REQUIRED OUTPUT
For Bankruptcyfilingdate, the original string has a date after
MTMASSTS03A but it will be change after MT like that
1.strbuffer1=2007022713495176690010323181
MTLNNSDT20060913                              OMSS          HCS1

For BankruptcyCaseNumberValue="0627303JDL"
2.strbuffer2=2007022713495176690010323181
MTLNNLCN0627303JDL                              OMSS          HCS1

For BankruptcyChapterNumberValue="7"
3.strbuffer3=2007022713495176690010323181
MTMASBKC7                              OMSS          HCS1

I mean after MT the values are change in the string strbuffer
according to the new values. I need help without using query


Thanks,

Anna.

To modify strings, look into the InStr() function and the Mid statement in
help (MSDN).

Mid **statement**  as opposed to "function"

Saga
Show quoteHide quote

OT - MS: $4,000 for Daylight Saving Fix
Within a *.exe
Function that returns an Array
Reason for 'Set' keyword
SendKeys command fails on Vista
Error in reading large csv file
Looking for a way to call LogOff and Shutdown.
Cannot quit Excel called from VB6
Source Control via Network Drive
Getting Info from a .TTF File