Standardize text strings upon data load in Qlikview

[fb987fb]

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: 

• "AMZN 1234-hhh"
• "AMZN 9977-yy-88-yy"
• "AMZN abcd"

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 · Accepted solution]

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

[fb987fb]

PERFECT!

Thank you for your insight.