HOW TO SPLIT A LINK

Exsample -https://docs.google.com/spreadsheets/d/1a1wmdQpgGu9f5gTMefefU_rlecNDiFodoQKDpXxEnxs0c/edit#gid=554539510

output should be = 1a1wmdQpgGu9f5gTMefefU_rlecNDiFodoQKDpXxEnxs0c
any idea

@Tharusha_Fernando
we can work with split method:
YourStringVar.Split({“/”}StringSplitOptions.RemoveEmptyEntries)

or using a regex:

in case of we do have more statics to expect then we can also anchor the regex pattern

1 Like

Hy @ppr thanks for the reply i want only “1a1wmdQpgGu9f5gTMefefU_rlecNDiFodoQKDpXxEnxs0c” and want to remove very thing else from the link

@Tharusha_Fernando
as mentioned / demonstrated in the screenshot it can be retrieved from the array with the splits
e.g. YourStringVar.Split({“/”}StringSplitOptions.RemoveEmptyEntries)(YourSplitIndexAsInt)

or when you give more details we can anchor the regex

1 Like

@Tharusha_Fernando

As @ppr said just make a small modification if the d is static, check as below

Hope this helps you

Thanks

1 Like

@Srini84 this was it thank you @ppr @Srini84

1 Like

@Srini84 can you let me know a sources to learn about regex more

@Tharusha_Fernando

Check this post, that was a amazing post by @Steven_McKeering to learn for beginners

Hope this helps you

Thanks

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.