Field Function

DJRH · Post by **DJRH** » Mon Sep 20, 2010 3:18 pm

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.

anbu · Post by **anbu** » Mon Sep 20, 2010 3:43 pm

Delimiter should be single character in Field function.

Use EReplace function to convert ^^^ to ^

arunkumarmm · Post by **arunkumarmm** » Mon Sep 20, 2010 3:51 pm

Yes, delimiter in Field should only be one character. Or you can simply replace ^^^ with @FM and use @FM as your delimiter

chulett · Post by **chulett** » Mon Sep 20, 2010 5:17 pm

Not just "should be" but can only be a single character.

DJRH · Post by **DJRH** » Tue Sep 21, 2010 6:26 am

chulett wrote:Not just "should be" but can only be a single character.

Thanks a lot everyone for your input. I appreciate your quick response.

chulett · Post by **chulett** » Tue Sep 21, 2010 6:51 am

So... resolved?

DJRH · Post by **DJRH** » Tue Sep 21, 2010 6:59 am

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.