Is there anyway to strip off the text in a record after a comma?

[#1]

Is there anyway to strip off the text in a record after a comma?  Example: ",Red Dog" and I just want "Red Dog"

[stevedark]

You can do this with an index and a mid statement, assuming the string is in a field:

mid(FieldName, index(FieldName, ',', -1) + 1)

The QlikView help guide will give you full syntax definition of the Mid and Index functions.

Hope that helps,

Steve

[sivarajs · Accepted solution]

you can use

Subfield(fieldname,',',2)

[jagan]

Hi,

You can use Subfield() as suggested by Sivaraj, if you further do not have any comma in your text.  If you have additional comma then use Mid() with Index() like below

=Mid(',Red Dog', Index(',Red Dog',',') + 1)

Hope this helps you.

Regards,

Jagan.