• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Splitting employee details as per attached format

V

VDS

Member
Dear All,

While downloading employee details of Payroll from HR Dept, I received the data as per attachment. COLUMN A gives the combined data and Column B to H is the breakup. Here, for date, time, employee code no, the number of characters is fixed.

I have used Right, Left and Mid functions to extract data as per requirement. But if I want to extract the name & other details form the combined data, become slightly difficult. I tried to to calculate the length of each field and reduce it from the total length. Not able to get through. So, What will be best available option.

VDS
 

Attachments

One of the issues here is that your records are inconsistent

ie: The last 3 records don't have a card No.
The Names can be 1, 2 or 3 words
Some of the Rooms have () some don't

The only way to automate this is to have a set of rules which allows for all cases
 
You must log in or register to reply here.
Back
Top