Use string operations in a list of URLS

Learn Academy Feedback
, , , ,
1

Hi Team,

Please help on the below scenario.

I Have captured the data ‘Person/1527’ in an excel.

and i also have the below URL
‘https://occ.com/2017/meetingappi/ModulePeopleIndex/0’.

Please show me how to delete ModulePeopleIndex/0’.from the url and replace with Person/1527.

Like ‘https://occ.com/2017/meetingappi/Person/1527’

Thanks in advance for your help.

2

Hi,
For each of the url
Use regex to remove the text and then use the concat function of the string to merge the cells
Or
use replace function to replace the text.

Let us know if this helps,
Regards,
Pavan H

1 Like
3

@johnvr1990 Is the “ModulePeopleIndex/0” always present in the URL and you want to replace only that or is it that you need to Replace the last two words in the URL ?

1 Like
4

Hi,
Yes “ModulePeopleIndex/0” is always present, and i want to replace

5

@johnvr1990 Then you can just use Replace method in this way :
yourStringVar.Replace(“ModulePeopleIndex/0”,“Person/1527”)

3 Likes