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

https://stackoverflow.com/questions/47014245/split-crystal-report-text-field-with-more-than-one-delimiter-and-load-on-differe