Need Mapping Help
We have IDoc to JDBC scenario in our project. This interface is working fine but we have material description filed length (40 chars) when there is an apostrophe( ' ) coming at end of the material description(40th position) ( ex: AVEVDERIVC C NP VIUYA CSEMEWEA UYV ABC' ) , the message is failing in receiver JDBC channel. In PI We have replacing single quote with two quotes, after executing the PI mapping the field value converts ('AVEVDERIVC C NP VIUYA CSEMEWEA UYV ABC''), in this case we need to remove apostrophe( ' ) at 40th position. as per my understanding if the apostrophe are in odd number while sending to DB it is giving an error. Kindly do help me how we can handle this logic in PI.
Jens Schwendemann replied
@Manoj Khavatkopp's solution will probably work.
If you want to resolve without UDF you could try something in the like of this (provided I understood your problem correctly)
faultText is your input field (just used the first mapping that I found to fiddle around, so don't bother about the naming of the fields)