Hi, I'm new to UltraEdit. The systems people recommended this software to my team, but said they have no instructions for us. lol. I'm a finance person. But I deal with large employee raw data files that are staged and loaded into my employers financial database. For example, these files can contain in excess of 500K rows of data. We recently transitioned to a new database and are still working out system kinks. So as a result, we are having to refer back to the raw data files frequently to confirm that data is reflecting correctly in system as it is received in the file. Each of the characters or groups of characters in the rows mean something and ends up being loaded into various tables in the database. I'm not sure if I'm using the correct terminology but can UltraEdit split the text into characters and label the characters. I think, it may be referred to as a character array or character index. Or is there an easy way I can cut and paste an employees data into UltraEdit and quickly see what number each character is?
For example, each employee may have 3 or 4 rows of data. (This is not same format but just to give example.) There are spaces at the end of some of the rows that need to be counted as a character. And the count needs to continue for each row. So if last character in row 1 is character 50, the first character in line 2 is character 51. In this example, characters 22-27 would translate to the employees DOB.
I've been playing around with some text split formulas in Excel, and I think, the Excel might be the easier way to do this, but still have not figured out how to continue the count on the next row. But I'm still wondering if this can be done with UltraEdit. It came highly recommended so I'm assuming it must be able to do something similar.
So far I've tried a script that I found but the output was still difficult to read.
For example, the output looks similar to this, where the number in the parenthesis is the character count.
I was wondering is there any way to list it or put the character number above the character, similar to the screen shot provided.
Can anyone offer any advice? Is this something UltraEdit can do or is Excel the better option?
For example, each employee may have 3 or 4 rows of data. (This is not same format but just to give example.) There are spaces at the end of some of the rows that need to be counted as a character. And the count needs to continue for each row. So if last character in row 1 is character 50, the first character in line 2 is character 51. In this example, characters 22-27 would translate to the employees DOB.
Code: Select all
12221DOEJOHN111234567102186CA900021789AG___
12222DOEJOHNBCBS23498HEALTHEMP02LEGAL245K98435___So far I've tried a script that I found but the output was still difficult to read.
For example, the output looks similar to this, where the number in the parenthesis is the character count.
Code: Select all
1(1) 2(2) 2(3) 2(4) 1(5) D(6)Can anyone offer any advice? Is this something UltraEdit can do or is Excel the better option?
