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
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