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
Solved
Vertical Lookup
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+54- Evangelist
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?
+14- Contributor
Yes if possible remove both instances and if possible insert a comma (useful for split string )
thx
+14- Contributor
I would use a StringReplacer
.... thx very simple
I had tried complicate solutions ....
thx
Francesco
+14- Contributor
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