![]() However, the building is the 3rd to last column from the end - so if we reverse it, the data will be in column 3 for both rows. ![]() As you can see, the first row would have the building in the 3rd column whereas the second row would have building in the 4th column. Imagine the above is a two-line sample from a large set of data and you are trying to find the building. ![]() For instance, let's look at the following example data:ĬN=Computer1, OU=Desktop Users, OU=BuildingA, DC=TEST, DC=LOCALĬN=Laptop2, OU=Traveling Users, OU=Finance, OU=BuildingC, DC=TEST, DC=LOCAL But sometimes the values may not all have the same number of columns. One of the most used features is the Text-to-Columns button (found in the Data ribbon of Excel), which splits tab and comma delimited files into individual columns. ![]() This may seem like a weird topic to discuss but I've always found Excel to be highly useful in manipulating data and can often be quicker than writing one-off scripts. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |