Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
oliveton
Creator
Creator

Separate Merged Columns in Excel File in Load

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!

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

You can use Subfield() function.

Like

Subfield(YourfieldName, '/', 2)

View solution in original post

3 Replies
vishsaggi
Champion III
Champion III

You can use Subfield() function.

Like

Subfield(YourfieldName, '/', 2)

View solution in original post

qlikviewwizard
Master II
Master II

Hi,

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

Please check this.

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

Capture.JPG

oliveton
Creator
Creator
Author

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

The SubField does seem to work! Thanks!