I had the following formula to display only the first 30 characters of the part description not including carriage returns working once.
Now I am trying to reuse it and whenever I add the calculated field the query returns no records (remove the calc field and the records return fine). Analyze indicates syntax is okay.
Setup is a calculated field, format=X(30), type=character
Formula: substring(replace(replace(Part.PartDescription,chr(13)," "),chr(10)," "),1,30)
Any ideas why the above would work anymore? Is there a better formula for just display the first 30 characters without any returns? (I have to exclude returns since the results of this dashboard are pasted into excel and we don't want all the extra rows coming up.)
Now I am trying to reuse it and whenever I add the calculated field the query returns no records (remove the calc field and the records return fine). Analyze indicates syntax is okay.
Setup is a calculated field, format=X(30), type=character
Formula: substring(replace(replace(Part.PartDescription,chr(13)," "),chr(10)," "),1,30)
Any ideas why the above would work anymore? Is there a better formula for just display the first 30 characters without any returns? (I have to exclude returns since the results of this dashboard are pasted into excel and we don't want all the extra rows coming up.)