extracting part of string from the answer

More
1 month 3 weeks ago #218579 by xiaomeng0603
hi
i have the text in Q1.shown like the following 
20%: 100; 25%: 0; 30%: 0; 35%: 0; 40%: 0 (the format is short free text)

how  to extract the substring from the text based on the index ";" and make the result like the following format

20%: 100
25%: 0
30%: 0
35%: 0
40%: 0

thank you

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now