Forum Discussion
Search string in another table and place that value
Hi all, I've been searching this for hours and although I tried lots of solutions and, they either don't work for me or aren't exactly what I'm looking for. I have a list of elements with names lik...
try this custom column and then split by number of charcters if XXXX have fixed number of characters :
custom column= Text.Select([Script Name], {"A".."Z", "a".."z"})
Hi! Thanks for your reply, but as I said, I could not use any splitting word solution as the names in the first column may vary. I would need to search the substring from ScriptControl[Script Name] in the column log[Script Name]
