Replacing part of the text with value from another column

[al1981]

Dear all

I have long url with in one column. Inside, there is a text wich i would like to replace with values from other column

[Link] is text in this colum (full link in 2nd pic) and there is text inside "1.1.2018" that would need to be replaced with value from [text1] for 1st text and text2 with 2nd text...

Goal: to generate link for each month

[Anonymous]

Hi @al1981 ,

In this case, you can try to separate the URL and replace the value. Because I found that you are replacing the values after "p_datum_od=" and "p_datum_do=".

I'll replace the first text with an example, and so on for the second text.

Split again.

Now the first half[url.1], the replaced text[url.2.1] and the second half[url.2.2] are separated successfully. Now it's just a matter of re-merging the first half, the replaced text[text1], and the second half.

Here's the result.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[al1981]

Hi, yes this is exactly how i did but hoped there is a more simple solution. Tnx

[donsvensen]

Hi 

This blog post might help you - #PowerQuery – Replace Values in one column with the value in another column – Erik Svensen – Blog ab...

[al1981]

HI, thank you! I will need to check in more detail but not really sure i can replace part of the cell value with this? I will check very soon, thank you!