Hi,
Please refer to the below table. I want to create a lookup
6.100 Orange |
6.110 Mango |
6.120 Mango and Oranges |
6.130 Kiwi |
6.140 Doughnut with cream |
6.150 Salad |
6.160 Blueberry |
6.170 Raspberry |
6.180 Muskmelon |
6.200 Salad with Cream / Salad with Meat |
Watermelon |
Banana |
6.230 Grapes with Strawberry and Pineapple |
I only need to extract the text here so the final lookup needs to be as shown below
Orange |
Mango |
Mango and Oranges |
Kiwi |
Doughnut with cream |
Salad |
Blueberry |
Raspberry |
Muskmelon |
Salad with Cream / Salad with Meat |
Watermelon |
Banana |
Grapes with Strawberry and Pineapple |
Please help with your thoughts.
Thanks
Solved! Go to Solution.
Hi @JDong — Now, please try this expression in a Formula tool:
Trim(REGEX_Replace([Field1], "^[\d+.,-]+\s", ""))
If it resolves your query Please mark it "Solved" or "Solved" with a Like. This will help other users find the same answer/resolution. Thank you.