New to informatica, need help with expression transformations

[newbie1314]

Hi,

I'm new to using informatica, I am able to do simple mappings. Now I'm having trouble with the following scenario:

So I have 2 columns in my source data, that I need to take the Number part and plug it into new columns that I have created in my target.

con_app (column name)
[AP000001] APP-Database
[AP000002] Tomcat
[AP000003] PATS

con_grp
ABC [111]
XYZ [123]
Workspace [345]

Need to store into target as follows:

con_app
APP-Database
Tomcat
PATS

app_id
AP000001
AP000002
AP000003

con_grp
ABC
XYZ
Workspace

grp_id
111
123
345

I created the exprssion tranformation and taking con_app as input, and created two new rows, 1) con_app & 2) app_id as output which would map to target table.

I'm struggling with how to separate the string between [] and put that into app_id, and remove everything till it hits ] in con_app, and put it into con_app in target.
Same issue for the con_grp, separate the string between [] and put that into grp_id, and the remove everything in con_grp after it [ including [ in and put that into con_grp.

Any help is appreciated.

Thank you!!!