Concatenate certain values from two or more string fields into one

[gauravmahendru]

Hi,

I am trying to achieve the following:

Field A (Country): INDIA

Field B (Location): Pune

Field C (Asset Tag): GM110022

Concatenated Field: IN_Pune_GM110022

I know the calculated field type can give me "INDIA_Pune_GM110022", however, I want only the first two characters from Field A.

Guidance appreciated.

[Nitin Panchal]

@gauravmahendru - Any update on this? Please mark my response as "Accepted Solution" if it resolved your issue. This will help community member who is looking for an answer.