Unformatted String stored in database:
CustomerID:1020 |type:Current|City:Karachi|Country:PakistanThe code should be written inside the formulae editor
Create a new formula name it whatever you like
e.g @formatString
formulae field to display the formatted string after splitting is given below:
stringVar array stringArray := split({Tablename.toFormatedField},"|");
Local numberVar i;
Local stringVar outputFormattedString := "";
Local numberVar i;
Local stringVar outputFormattedString := "";
For i:=1 to Count(stringArray) do(
outputFormattedString := outputFormattedString + stringArray[i] + Chr(10)
);
outputFormattedString;
The outputString is :outputFormattedString;
CustomerID:1020
type:Current
City:Karachi
Country:Pakistan
type:Current
City:Karachi
Country:Pakistan
nice sharing. it is rocking info.
ReplyDeletewebdesigning.ae