Hello

French user uneder FMPro Adv 18 I have a text field listing product quantities delivered by suppliers identified by their IDs (e.g., 20kg delivered by SOC258, 14kg by SOC87), with each entry separated by a line break.For some reason, there are several lines showing a delivery of 0 from certain suppliers;

20 of SOC258

14 of SOC87

0 of SOC34

0 of SOC456

I would like to remove these lines.

Thanks for your advices

You could use a looping script or the While() function to go over each value and test the first character or word. The script option could also split the passed entries into individual records in a related table, with separate fields for quantity and product ID, as one would expect in a relational database.

Alternatively you could use the following expression* to filter out the 0 entries:

FilterValues ( YourField ; Substitute ( ¶ & YourField ; "¶0" ; ¶ ) )

--
(*) based on a brilliant idea by Agnes Barouh