cancel
Showing results for 
Search instead for 
Did you mean: 

SAP PI mapping query

Former Member
0 Kudos

Hi Experts,

I have two mapping queries:

1. In which field A maps with field B.

For a E-Mail address coming from field A I have to check whether @ and . are available or not.

2. In which field A maps with field B.

The value coming from filed A will be: Only Numerics, Should Migrate Upto 2 decimal places (Ex: 34.21), Ignore the rest if any.

Please let me know.

Regards,

Aniruddha

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

chk the UDF given by Satish:

>>For a E-Mail address coming from field A I have to check whether @ and . are available or not.

u can use standard functions for the same



A-------------
-----------indexOf-----greater(constant(0) ----2nd input)
Constant(.)---
                             ----------------------AND----IfWithoutElse(A----THEN)-----Target
A-------------
------------indexOf-----greater(constant(0) ----2nd input)
Constant(@)---

Answers (1)

Answers (1)

Former Member
0 Kudos

Thanks Amit very much for your help, thanks Satsh.

Regards,

Aniruddha