Access Excel remove text in brackets

This Access Excel VBA tutorial explains how to remove text in brackets using custom Function. You may also want to read: Change text color in brackets Extract text in brackets Access Excel remove text in brackets I was inspired to create this post because the HR system I am using (Workday) is very annoying, some data fields are actually a combination of two different fields, the additional data field is displayed in brackets in the prefix. For example,  an employee has a English name ...
More

Excel VBA separate line break data into different rows

This Excel VBA tutorial explains how to separate line break data into different rows. You may also want to read: Access Excel remove line break and carriage return Excel VBA separate line break data into different rows Recently I received a report from a HR system which is claimed to be a standard report. In the report, some data are grouped into one Cell and are separated by line break. I found this report format totally unacceptable. From the database perspective, each dependent...
More

Peoplesoft HCM Business Unit, SetID, TableSet

This Peoplesoft HCM tutorial explains Business Unit, SetID, TableSet. Peoplesoft HCM Business Unit, SetID, TableSet SetID If you look at the Table fields through Query Manager, you will find many Peoplesoft Tables contain SetID field. Tables that have SetID field include Location, Jobcode, Department, Salary Admin Plan, Employee Class, etc. SetID is a grouping for Business Unit in order to restrict or grant access to data within a table. If SetID contains only one Business Unit, the SetID ...
More

MPF Ordinance in Hong Kong

MPF Ordinance in Hong Kong This tutorial explains the core concepts of MPF Ordinance in Hong Kong. All data were updated as at 2015 March, I may not be able to constantly update the Ordinance. MPF Enrollment Permitted Period is the period within which an employer must enroll employees in an MPF scheme. Employment type Permitted Period Non casual employee the first 60 days of employment Casual employee the first 10 days of employment Self employed person the first 60 ...
More