Hi! I have this example of a data which consist of links.
Using RegEx, i wish to get the company name - Abc, Def and Ghi here for those of only https://files-example.com files .
For example, in this case, bolded is the company name.
https://files-example.com/Marie/Abc/03%This%is%40title%20A.mpv
How do i write a regular expression that checks those of https://files-example.com and retrive that of just the company name in another column?
I am fairly new to RegEx and would absolutely appreciate your help.
Solved! Go to Solution.
Hi @reignM
Here is how you can do it.
Workflow:
You can learn more about Regex from the below link
https://community.alteryx.com/t5/Interactive-Lessons/Parsing-Data-with-RegEx/ta-p/441415
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689
Hope this helps : )
Hi @reignM
You can learn more about Regex from the below link
https://community.alteryx.com/t5/Interactive-Lessons/Parsing-Data-with-RegEx/ta-p/441415
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689
In addition to the above resources, you can use https://regex101.com/ as a sandbox for building and testing out regex. The tool is very intuitive for step-by-step regex building.
This should help you get started with the amazing journey of Regex 😊
Hope this helps : )
This works wonderfully! Thank you so much for the help as well as the attached Regex resources!
Happy to help : ) @reignM
Cheers and have a nice day!
You too! Thank you for the https://regex101.com/ sandbox link. That would definitely help with my learning on RegEx tremendously. Have a wonderful day ahead :)