This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The extra delimiter "," can also be between digits or anywhere else and not just words.
Name,Employee,Date,Day,Description Time,1001,27,Tuesday,Worked in Accounts Harry,1223,23,Friday, Experience in sales Susan,K,1211,02,Monday, Sales Josh,1432,22,Thursday, Engineering Katrina,2342,12,Mon,day, Team player Roy,32,11,01,Tuesday, 15 year experience in Sales,Accounts and Audit
There is an extra comma in the last row in the fields "Employee" and Description.
You can assume the day field will always have 2 digits, so use this as a starting point. Edit: Possibly a rash assumption. If not, then this coupled with varying number of digits in the Employee field mean that you can't parse it automatically.
1. the last 2 digits go into the day
2. all the digits before that go into the Employee
3. all the starting text goes into name
Continue on with the remaining steps from my previous post
An other option is based on the idea that most of your data will be correct. In this case put a recordID on all the rows and then pull out all that have exactly 4 "," and process these automatically. Send all the others to an error output to be corrected manually and re entered. Use the recordID to order the combined output