Hi. I have an Excel-file with a table with employee data that I want to upload to a mySQL database. The table, which is exported from the HR system, has one column that contains both names and employee numbers. The problem is, to make use of this data I need to have the employee number separated to a new column. The employee number consist of 8-10 numbers. In the Excel-file, the data looks like this:
[Last name], [First name] [middle name] [employee number]
For example: Doe, John 12345678
or: Smith, Alex Bob 1234567899
I have previously been able to separate the employee number in Excel, using Power Query and splitting the column when it changes from text to numbers. But I cannot fint anything similar in EasyMorph. I have tried using the “split delimited text into columns”, but I don’t think it is suitable for this problem But I am new to this application, so I might have overlooked something.
So, anyone has any suggestions on how to solve this problem?