Is it possible? Formatting a data into something else

[RJ]

I have a 2 fields, one is Data (populated from AD) if blank, another field
DataSet (Dropdown) to choose, then it sets the Data field with DataSet field
Value, then it hides once the Data field is set. Works beautifully, now my
scenario is, if the Data field is populated from Active Directory (Ex: State
is New York) would like to change it to NY. how do I do that? Thanks for
your time.

 

[Swathi (GGK Tech)]

Hi,
Set a rule on data set field.
1.Go to dataset field properties.
2.Set the condition as if dataset field is not blank
3.Then add action to set the data field with the following expression.
concat(substring(substring-before(., " "), 1, 1),
substring(substring-after(., " "), 1, 1))
Here . -> reprsents the data set field.

Hope this will work for you.