I forgot how to do this.
I want to remove the outline sequence before an item's name.
How do I set up the expression in the RegEx tool to repack or get rid of the outline reference. Note, this is just an example. The real data might include 2.1.3, 1.1.5, etc.
Item | --> | Item |
1.1.1) Chassis | Chassis |
Solved! Go to Solution.
Something like REGEX_Replace([Item], "\d.\d.\d\) ", "")
I'd try something like:
REGEX_Replace([Item],"^.*?([A-Za-z].*)$","$1")
Which will match the first character and replace all before
They both work.
I modified the first to include \s to get rid of the space between the outline position and the name.
Thanks!!