Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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!