Which IF statement would correctly subset ProductName for values containing the standalone word shirt?

Which IF statement would correctly subset ProductName for values containing the standalone word shirt?

• A. if find(ProductName, 'Shirt') >0;
• B. if findw(ProductName, 'Shirt') = 0;
• C. if find(ProductName, ' Shirt ') = 0;
• D. if findw(ProductName, 'Shirt', ' ') >0;

Answer: (D)

The correct choice utilizes the `findw` function, which is particularly useful when you want to search for entire words within a string. The `findw` function checks for the presence of a specified word in a character string, accounting for word boundaries defined by a delimiter. In this context, the function `findw(ProductName, 'Shirt', ' ')` is searching for 'Shirt' as a standalone word within the `ProductName` variable, using a space as the delimiter. This ensures that 'Shirt' is recognized only when it is not a substring of another word (for instance, it would correctly identify 'Shirt' but ignore 'Shirts' or 'Shirtdress'). The condition checking if `findw` returns a value greater than zero confirms that 'Shirt' exists as a standalone word. This functionality addresses the requirement of the question effectively, making it the appropriate choice. The other options either do not correctly isolate 'Shirt' as a standalone word or utilize functions that are not suitable for this kind of search based on word boundaries.

The correct choice utilizes the findw function, which is particularly useful when you want to search for entire words within a string. The findw function checks for the presence of a specified word in a character string, accounting for word boundaries defined by a delimiter.

In this context, the function findw(ProductName, 'Shirt', ' ') is searching for 'Shirt' as a standalone word within the ProductName variable, using a space as the delimiter. This ensures that 'Shirt' is recognized only when it is not a substring of another word (for instance, it would correctly identify 'Shirt' but ignore 'Shirts' or 'Shirtdress'). The condition checking if findw returns a value greater than zero confirms that 'Shirt' exists as a standalone word.

This functionality addresses the requirement of the question effectively, making it the appropriate choice. The other options either do not correctly isolate 'Shirt' as a standalone word or utilize functions that are not suitable for this kind of search based on word boundaries.