Right Function Challange with User Response

building reports webintelligence
1

Hello Friends, I have requirement to break the user response values entred for user name and display seperately so let say user enter Raju-prasad;Ram-Mohan;Murali Gonda
then i want to break at ; to pick 3 names in seperate fields.
fIELD1 = Raju-prasad;
FIELD2=Ram-Mohan;
FIELD3 = Murali Gonda ;

when i use
the right function it does not work to break at ;

is there any function to pick userresponse values 1, 2, 3

please correct my code

=Right(UserResponse([Supervisor Name];“Supervisor Name:”);Pos(UserResponse([Supervisor Name];“Supervisor Name:”);";")-8)

soniya

soniyakaren (BOB member since 2009-07-21)

2

is there a limit on how many names can be selected?

jresendez :mexico: (BOB member since 2004-05-03)

3

The Pos() function will return the position of the first ; in the string, so you might want to use it with the Left() function to get the first name in the string:

=Left(UserResponse([Supervisor Name];"Supervisor Name:");Pos(UserResponse([Supervisor Name];"Supervisor Name:");";")-1)

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

4

Yes there is a limit of 3 selection values, so this is what i used to get first one in seperate field but how do I get 2 and 3 user entered values in 2 different fields since length of field 2 and 3 varies so i cannot use trim

Left(UserResponse([Supervisor Name];“Supervisor Name:”);Pos(UserResponse([Supervisor Name];“Supervisor Name:”);";")-1)

please help me how to get 2 and 3 values

soniyakaren (BOB member since 2009-07-21)

5

OK, I got it. I did this with eFashion, putting a prompt on State, and selecting 3 values at the prompt. I parsed out the three values as follows:

Value 1:

=Left(UserResponse("Enter value(s) for State:");Pos(UserResponse("Enter value(s) for State:");";")-1)

Value 2:

=Left(Substr(UserResponse("Enter value(s) for State:");Pos(UserResponse("Enter value(s) for State:");";")+1;Length(UserResponse("Enter value(s) for State:")));Pos(Substr(UserResponse("Enter value(s) for State:");Pos(UserResponse("Enter value(s) for State:");";")+1;Length(UserResponse("Enter value(s) for State:")));";")-1)

Value 3:

=Substr(Substr(UserResponse("Enter value(s) for State:");Pos(UserResponse("Enter value(s) for State:");";")+1;Length(UserResponse("Enter value(s) for State:")));Pos(Substr(UserResponse("Enter value(s) for State:");Pos(UserResponse("Enter value(s) for State:");";")+1;Length(UserResponse("Enter value(s) for State:")));";")+1;Length(Substr(UserResponse("Enter value(s) for State:");Pos(UserResponse("Enter value(s) for State:");";")+1;Length(UserResponse("Enter value(s) for State:")))))

Enjoy. 8)

MichaelWelter :vatican_city: (BOB member since 2002-08-08)