Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Find a full string from the substring

michaelcash
アトム

Hi

 

I have given string and substring.

  • I need to mach substring to the string and print full word.
  • Then add one word before and after the match
StringSubstringMatch+1 right word+1 left word
Adam Robert Emil Kamilt emRobert EmilRobert Emil KamilAdam Robert Emil
Big Platform SAPlatformPlatformPlatform SABig Platform
The Big IslandIslaIslandIslandBig Island
The Group Holding SAup HoldGroup HoldingGroup Holding SAThe Group Holding
Karina Marina MariannaMariannaMariannaMariannaMarina Marianna

 

Thanks for you help

3件の返信3
binuacs
ポラリス

@michaelcash 

 

binuacs_0-1640796244574.png

 

michaelcash
アトム

Hi

Thanks for response.

I think i was not fully clear.

 

I have only two columns:

StringSubstring
Adam Robert Emil Kamilt em
Big Platform SAPlatform
The Big IslandIsla
The Group Holding SAup Hold
Karina Marina MariannaMarianna

 

Additional columns are just to show the output so I can't use Find/Replace

 

Match has to be created on finding full word in String based on partial words in Substring

e.g. for the row nr 1, algorithm has to find the pattern and then find the full words around this pattern: Robert Emil

Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @michaelcash,

 

I thought i'd avoid the batch macro route and instead go down the Dynamic Replace tool path:

 

JonathanSherman_0-1640861519558.png

 

I've attached my workflow for you to download if needed!

 

Kind regards,

Jonathan

 

ラベル
トップのソリューション投稿者