Separate Merged Columns in Excel File in Load

[oliveton]

Is there a way to somehow separate two sets of data that exist in one cell in Excel?

Please see attached example; the numbers combined in one cell, separated by a slash. I only need the number on the right side of the slash. So in line 4 I want to keep 134 and not include 3 or anything to the left of 3.

Would be awesome if there was a solution for this.

Thanks everyone!

[vishsaggi · Accepted solution]

You can use Subfield() function.

Like

Subfield(YourfieldName, '/', 2)

[qlikviewwizard]

Hi,

I did not clear for which field you are looking for change.

Please check this.

='SubField Out Put  :'&SubField(PNPUBA, '/', 2)

[oliveton]

Oh sorry the field I was looking to change was "COMMN."

The SubField does seem to work! Thanks!