Search string in another table and place that value

[fab14]

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 like this

Table "log"

Script Name

XXX_XX_ExportToDwgReg_0.2.1

XXX_XX_ExportToDwgReg_0.2.1

XXX_XX_FindCAD_0.2a

XXX_XX_AutomaticDoorMarks_0.3.1

XXX_XX_RevisionClouds_0.6.2

XXX_XX_FindCAD_0.2a

XXX_XX_AutomaticDoorMarks_0.3.1

With more columns with a lot of info.

I have another table like this

Table "ScriptControl"

Script Name	Time
FindCAD	5
ExportToDwgReg	30
RevisionClouds	25
AutomaticDoorMarks	15

What I would need is something like this

Script Name	Short Name	Time
XXX_XX_ExportToDwgReg_0.2.1	ExportToDwgReg	30
XXX_XX_ExportToDwgReg_0.2.1	ExportToDwgReg	30
XXX_XX_FindCAD_0.2a	FindCAD	5
XXX_XX_AutomaticDoorMarks_0.3.1	AutomaticDoorMarks	15
XXX_RevisionClouds_0.6.2	RevisionClouds	25
XXX_XX_FindCAD_0.2a	FindCAD	5
XXX_XX_AutomaticDoorMarks_0.3.1	AutomaticDoorMarks	15

So, I would need to search the string in ScriptControl[Script Name] comparing it to the values in log[Script Name] and place the value in a column in the table log, and after that, place the respective value "Time" in another column.

By the way, splitting the strings in log[Script Name] by "_" wouldn't work as sometimes the names may differ.

Can someone help me, please? Thanks! 🙂

Many thanks in advance! Cheers!

[pankaj_lp]

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"})

[fab14]

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]