Welcome to MSDN Blogs Sign in | Join | Help

Microsoft BizTalk Server

(Kerrey Zheng's view with BPI Products)
Using "String Find" Functoid with Special Characters

Problem

You need to find a special character when use the String Find Mapping functoid, such as a (carriage return) or a NL line feed).

Solution

BizTalk provides a String Find functoid: Use the String Find functoid to return the position in a string at which another specified string begins. This functoid requires two input parameters: the string that is being searched through, and the string which is being sought.

Sometimes you need to search a special character, for example, the original string looks like as below:

"This is a testing.
 This is another testing"

The string is a multi-line string, which you only want to get the first line, so you may imagine to use String Find Mapping functoid to return the position of <CR> and then to use String Left Mapping functoid to return the first line. However, you cannot directly input a special character in String Find Mapping functoid!

image

Luckily, there is another functoid named ASCII to Character functoid image to return a character when given an ASCII value as input. You can just input "13" as this functoid's parameter, as below:

image

The final solution should looks like as below:

image

Posted: Monday, December 17, 2007 11:03 AM by Kerrey Zheng

Comments

No Comments

Leave a Comment

(required) 

(required) 

(optional)

(required) 

  
Enter Code Here: Required

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Page view tracker