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 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!
2 Replies
pankaj_lpHelper I
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]
