Find : InStr And Add Date

[DMT Dave]

Hi Guys, i am trying to use the replace function to find the Colon,

Keep everything before it, Add the date in my case NewWC then 2 line breaks then everything after that

So it should be something like

Good Morning all you guys the forum

We can offer you week commencing: (NewWC Goes Here)

If this works of for you

Please confirm this etc etc....

I think my sequence in the replace function wrong ????

I won't put the full code as its quite large
myrow is select case


NewText is String, NewWC is String, myLine is string "........."

 Me.txtAddLine = DLookup("TextToAdd", "tblAddLine", "[ID] = " & myRow)
    NewText = Me.txtAddLine
    Me.txtReply = myGreet & vbNewLine & vbNewLine & _
    NewText & vbNewLine & vbNewLine & myLine & vbNewLine & vbNewLine & Me.txtMailMessage
    NewWC = Format(Me.txtFrom, "dddd-dd-mmm-yyyy")
    myStr = Replace(NewText, ":", ": " & NewWC & vbNewLine & vbNewLine & myLine & vbNewLine & vbNewLine & Me.txtMailMessage)

[June7]

Looks fine to me. But since I don't know what each variable is actually populated with, can't be sure.

What is the resulting string in myStr? If you don't like the result, then change the sequence.

[Welshgasman]

Why can't you just do a simple replace.
Place a marker like "InsertDate" in your text block and replace InsertDate with your formatted date?

[DMT Dave]

Hi welshgasman thank you, will try playing around with it, can't harm anything

Just didn't know if anything obvious like me not getting sequence correct in replace function

Its one of those where it should be easy to find anything before and after colon then add after the colon and resume with what was already after colon prior to date going in

abcdef:

ghijklm

to become

abcdef: 14-August-2021

ghijklm

[Welshgasman]

I would not even bother searching for colon.
Just put something in as a place marker, that could not possibly exist in normal usage, and then just replace that with your date.?

What if you have several colons in there like one of my emails?

From Donor:
RBL

Received:
02/09/2020

Method:
BACS

Reference:
APBACS/108525

Amount:
£558.00

Balance:
£1,058.00

Notes:
Courtesy notification only

[DMT Dave]

very true, there would every be only 1 colon though as its from a table of replies

however, your suggestion worked great but still loose text after "InsertDate"

So now my line says : InsertDate and now replaces with date, works great thank you very much wgm

[Welshgasman]

very true, there would every be only 1 colon though as its from a table of replies

however, your suggestion worked great but still loose text after "InsertDate"

So now my line says : InsertDate and now replaces with date, works great thank you very much wgm

How can you lose text after InsertDate? with a simple Replace?

Show your replace statement.

[DMT Dave]

Hi wgm, I have corrected it, just had an override after the event so moved the override of code,

just couldn't see the wood for the trees, but what a simple way to replace what you have suggested particularly when the keyword to replace is from your table then it's always the same word to replace!