how to remove 's' from text

[rehanemis]

Hi,

I would like to use a query (update) to just remove the letter 's' from https. so where https i would like to make http.

Original Link: http://www.linkedin.com/pub/suhasini-pashikanti/15/214/622
Updated Link: https://www.linkedin.com/in/suhasini-pashikanti-62221415

I have tried it but no achievement.

Any suggestion?

Thanks

 

[stopher]

The replace function will replace text in a string with some other text:

Replace("http","https",[myLink])

 

[rehanemis]

But how do I update existing record by removing the 's' can you please tell me procedure.

 

[rehanemis]

Also can I use update query to only remove 's'? if yes can you please give me sentence?

 

[stopher]

Yes, just use the replace function in an update query. The example I gave replaces "https" with "http". The think is if you simply try to get rid of the "s" then you will lose the "s" from other parts of your text also.

 

[rehanemis]

Your help is much appreciated. Thanks again.