Skip to main content
Solved

BulkAttributeRenamer doesn't work with Regex

  • October 7, 2020
  • 1 reply
  • 12 views

fikusas
Contributor
Forum|alt.badge.img+5

I need from the left part (attribute name) get the right part.

Abcd.EfgT.OpKTs ----> OpKTs

 

When using BulkAtributeRenamer with this Regex, result is the same:

Action: Regular Expression Replace

Text to Find: (^[A-Z]{0,}\\.)([A-Z]{0,}\\.)([A-Z]{0,})

String: \\3

Best answer by ebygomm

The regex statement in the BulkAttributeRenamer is case sensitive, try

(^[A-Za-z]{0,}\.)([A-Za-z]{0,}\.)([A-Za-z]{0,})

In the above case, if I just wanted everything after the second full stop I'd use this to match the left part and replace with nothing

.*\.

 

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.

1 reply

ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3427 replies
  • Best Answer
  • October 7, 2020

The regex statement in the BulkAttributeRenamer is case sensitive, try

(^[A-Za-z]{0,}\.)([A-Za-z]{0,}\.)([A-Za-z]{0,})

In the above case, if I just wanted everything after the second full stop I'd use this to match the left part and replace with nothing

.*\.