Insight - how to apply Regular Expression for manipulating the value for the import source?

[Sanja Vukovic]

In documentation https://documentation.riada.se/insight/latest/insight-manager-s-guide/import-and-synchronization/general-import-concepts under Import Attribute there is "concept" Regular Expression. What is "concept"? Where is the field inside import where I can enter regular expression?
It says "You can use regular expressions to edit the value from the import source." and goes on with examples and all. But it doesn't say where.

Please help.

[Alexander Sundström]

Hi Sanja,

Look at the attached screenshots, click on the cogwheel to open the configure, and there you have the regular expression :)

[Sanja Vukovic]

OK. (It would be nice if that detail was mentioned in documentation.)

I added custom attribute and I used Regular expression (\w*)\W and it works.
But when I look configuration, it is nowhere to be seen that I used it

Now I only need information what to put into Regular expression to get text, for exampe "HMC scan".

[Alexander Sundström]

Hi Sanja,

What do you mean with 

 it is nowhere to be seen that I used it

Regarding using regular espressions we recommend the documentation at https://docs.oracle.com/javase/7/docs/api/java/util/regex/Pattern.html for more information on how to build the regex, and personally, I try to use https://regexr.com/ when I want to test the result.

Best Regards
Alexander

[Sanja Vukovic]

Hi Alexander,

Sorry, by "nowhere" I mean the input configuration. With or without regular expression, it looks the same. It should be visible whether a regular expression is used or not on that attribute.

I am trying to find the function that returns text string (constant), but I can't find it. Please help

[Alexander Sundström]

If you investigate the insight_import.log that's in the JIRA Home directory, you'll see that regex has been applied. 

It's not possible to use regex to replace with a default value, regex can only alter the value that you inputed. As such, you would have to use automation rules to add a default value, like mentioned in another community question.

Best Regards
Alexander