Crystal Reports How To — Split Words By Delimiter
Crystal Reports How To — Split Words By Delimiter
To get third value e.g. a|b|c
global stringVar array x456 := split({Table.field},”|”);
WhilePrintingRecords; stringVar array x456; numbervar c; c := count(x456); if 4 <= c then
IF x456[4] = “” THEN //To be used if some text is different. x456[3] ELSE x456[4]
Replace: “|” with the delimiter.
Reference: https://stackoverflow.com/questions/13646859/crystal-reports-splitting-delimited-field-to-columns