Skip to main content

Hi

I need to find and extract from column B the value present in column A

for first record for ex PACHINO

 

any suggestion ?

 

Thx

 

Francesco

By extract, do you mean remove the value from column B that is in column A?

So the value remaining in column B would be SP PER ISPICA PACHINO 96018 ? Or do you want to remove both instances?


Yes if possible remove both instances and if possible insert a comma (useful for split string )

thx


I would use a StringReplacer


I would use a StringReplacer

.... thx very simple

I had tried complicate solutions ....

 

thx

 

Francesco


I would use a StringReplacer

Hi

small update

 

If the text to replace i stored in an external table how can manage the replacement ?

 

Francesco


Reply