Extract string within text in Qlik sense

[LP27]

Hi Qlikers,

Here is the scenario where I would need some idea's on- 

I have column Description in one Table and Vendor No in another Table.

example :-

Description Table

No	Description
1	R555-10034 Alter state
2	R777-10045 Change state
3	56785789907909

Vendor Table

Vendor No

10034

45654

23435

10045

So now I have to extract the string from Description Table if it contains the exact vendor No from Vendor Table.

Example : I need to create New Column as shown below-

No	Description	New Column
1	R555-10034 Alter state	10034
2	R777-10045 Change state	10045
3	56785789907909	-

Note : Only if Vendor No exist in the description Column it should add to new Column as shown above.

I have also tried this condition- if(wildmatch(Description, Vendor No),Vendor No). This did not work!

Let me know how to achieve this, have tried out my best! 

Thanks in Advance🙂

LP

[sunny_talwar · Accepted solution]

Try this

VendorMapping:
Mapping
LOAD [Vendor No],
	 '/'&[Vendor No]&'\';
LOAD * INLINE [
    Vendor No
    10034
    45654
    23435
    10045
];

Table:
LOAD *,
	 TextBetween(MapSubString('VendorMapping', Description), '/', '\') as [New Column];
LOAD * INLINE [
    No, Description
    1, R555-10034 Alter state 
    2, R777-10045 Change state
    3, 56785789907909
];

[LP27]

Wow! that solved my issue.

Thanks @sunny_talwar