topic Standardize text strings upon data load in Qlikview in App Development

Standardize text strings upon data load in Qlikview

fb987fb — Fri, 14 Jul 2023 20:12:47 GMT

I'm new at using QlikView, so sorry if this is a stupid question.

I have data in an excel spreadsheet. I want to standardize some text strings upon loading the data into Qlik.

Text string examples:

I want to standardize all text strings that contain "AMZN" to be "Amazon"

Is there a way to accomplish this?

Thanks for the help.

rubenmarin — Sat, 15 Jul 2023 07:18:23 GMT

Hi, for this example it could be something like: If(WildMatch(FieldName,'AMZN*'),'Amazon') as StandarizedText

fb987fb — Sun, 16 Jul 2023 01:35:55 GMT

PERFECT!

Thank you for your insight.