|
Hi All,
I created one formula .It return the string . But every time it concatenate the new value with old value .
e.g. instead of ABC, XYZ ,PQR it return like ABC,ABC XYZ,ABC XYZ PQR .
Formula is like this :
numberVar i=0;
numberVar strLen:=0;
strLen:=Length({tbDocumentDetailsIndia.Nationality}) ;
StringVar Array x;
stringVar strNationality ="";
stringVar array strSplited:= "";
strSplited:= Split ({tbDocumentDetailsIndia.Nationality}," " );
for i:=1 To strLen Do
(
if{tbDocumentDetailsIndia.Nationality}<>" " then
strNationality := strNationality + " " + {tbDocumentDetailsIndia.Nationality} + " "
else
strNationality := strNationality + " " + Trim ({tbDocumentDetailsIndia.Nationality})
);
strNationality;
|