macro to change out specific words with words in corresponding list

[ThornhillTaylor]

hi all, I'm having trouble thinking through this macro

I have 5 website url's  each one has a word or 2 that is in brackets... I want to replace the words in the brackets with corresponding all numbers in given list

i.e  www. mc.com/reports/surveys/{survey id}/questions/question id/

list to replace []

Survey id

18

19

20

21

22

question id

200

201

202

203

204

205

i know this is easy but im having a difficult time thinking through it.

any help would be appreciated

[CharlieS]

Macro? How about the Find Replace tool? 

https://help.alteryx.com/current/en/designer/tools/join/find-replace-tool.html

[ThornhillTaylor]

Charlie thanks for your response... im not sure that will work...

i currently have 4 url.. they are all connected to an API.. so each pulls hundreds of rows of data

within the api calls, there are 

   survey ids

   questions ids

   answer id

    response ids

each survey has all questions assigned to them (on individual api calls)

each question id has answers assigned (on api calls..

each API call is a different url

so we are talking about probably 100 API calls daily/weekly

i think a macro is necessary, just having trouble setting it up...

[Qiu]

@ThornhillTaylor 
Are you trying to generate all the possible URLs of 

www. mc.com/reports/surveys/{survey id}/questions/question id/

with all the combination of your Survey id and question id?

LIke

www. mc.com/reports/surveys/18/questions/200/

www. mc.com/reports/surveys/18/questions/201/

www. mc.com/reports/surveys/18/questions/202/

[ThornhillTaylor]

Qiu,

yes! exactly... thanks for that.. i probably wasnt as clear as you have made it