Page 1 of 1

Field Function

Posted: Mon Sep 20, 2010 3:18 pm
by DJRH
string ="TestString1 ^^^ TestString2"
MyString = Field(string, "^^^" ,2)

Call DSLogInfo(" The string value is : " : MyString , "JobControl")

Does not fetch the second string.
With single "^" as delimeter it works fine and fetches the " TestString2" but does not work with "^^^". I need to use 3 carets (^^^) as delimeter thus if anybody can help me with this.

Posted: Mon Sep 20, 2010 3:43 pm
by anbu
Delimiter should be single character in Field function.

Use EReplace function to convert ^^^ to ^

Posted: Mon Sep 20, 2010 3:51 pm
by arunkumarmm
Yes, delimiter in Field should only be one character. Or you can simply replace ^^^ with @FM and use @FM as your delimiter

Posted: Mon Sep 20, 2010 5:17 pm
by chulett
Not just "should be" but can only be a single character. :wink:

Posted: Tue Sep 21, 2010 6:26 am
by DJRH
chulett wrote:Not just "should be" but can only be a single character. :wink:
Thanks a lot everyone for your input. I appreciate your quick response.

Posted: Tue Sep 21, 2010 6:51 am
by chulett
So... resolved?

Posted: Tue Sep 21, 2010 6:59 am
by DJRH
chulett wrote:So... resolved?
Yes, I will consider this as resolved as we do not have any option other then using eReplace or use different delimeter type.

Thanks once again for everyone's input.