How to Replace the Text values in a Paragraph with Field Values in another Table?

[Anonymous]

Hi all,

I'm having a Paragraph as below in Table

and  ID table as below. The task is I need to replace the "Names" in Paragraph with respective ID's

Result I need is as Below

[YoussefBelloum]

Hi,

you can combine functions like Replace with a Mapping load and Applymap()

[sunny_talwar]

May be use MapSubstring

[sunny_talwar · Accepted solution]

Something like this

Mapping:

Mapping

LOAD * INLINE [

    Name, ID

    Steve, 1

    Rajesh, 2

    Vicky, 3

];

Table:

LOAD Paragraph as OriginalParagraph,

MapSubString('Mapping', Paragraph) as Paragraph;

LOAD * INLINE [

    Paragraph

    "Steve is Retailer, Rajesh is his Consumer, Vicky is Manufacturer and Rajesh is his Worker"

];

[Anonymous]

Ya Thanks Bro,

It worked

[YoussefBelloum]

Was thinking about this but with the Replace() function. this is def better