Update another field using substring

[Michael shechter]

hi fidel,

I got a text custom filed that contained active directory user with the flowing formats
1.LOLAON\bh0ilona [e-mail] 3.oplhezi i want to do substring so i will be able insert it to user picker field. for example instead LOLAON\bh0ilona it should be bh0ilona or instead [e-mail] it it should be mm00zomi how can i do it thank you !

[Fidel Castro Armario]

Hi Michael,

According to you description I assume there are 3 different patterns:

1) LOLAON\bh0ilona should be converted to bh0ilona

We want to extract the substring from '\' character to end of line.

2) [e-mail] should be converted to mm00zomi

We want to extract the substring from beginning of input to '@' character.

3) oplhezi should be taken without any transformation.

If there isn't a '\' or a '@' character, we want to take the whole string.

Is my description correct?

[Michael shechter]

Yes you are right

בברכה מיכאל שכטר | צוות בקרה | מטה אגף מערכות מידע | איילון חברה לביטוח טלפון: 072-2227393| E-mail: [e-mail]

[Fidel Castro Armario]

Use "Copy a parsed text to a field" with the following configuration:

• Target field: select the User Picker field
• Parsing mode: advanced
• Text to be parsed:

replaceFirst(%{nnnnn}, "(^.*\\\\)|(@.*$)", "")

replacing nnnnn with field code for text custom field containing active directory user.

[Michael shechter]

Thank YOU very much !!!

בברכה מיכאל שכטר | צוות בקרה | מטה אגף מערכות מידע | איילון חברה לביטוח טלפון: 072-2227393| E-mail: [e-mail]

[Fidel Castro Armario]

You are welcome.