Changes
Jump to navigation
Jump to search
added Using the Normalize Fixed Width Script section
# Enter your username (in the form ad.mcnaircenter.org\user where user is replaced with your username on the RDP server) and password on the RDP server.
# The drive should now appear on your Finder menu sidebar.
=== Using the Normalize Fixed Width Script ===
Ed has written a very useful script that will take text files with lots of spaces and turn them into tab delimited text files, this file can currently be found at "E:\Processing\SDC Data." You can access it by
# RDP onto the server and open Windows Powershell. It is on the taskbar at the bottom of the screen with a blue square icon with an arrow in it.
# type in "cd 'E:\Processing\SDC Data' "
'''OR'''
# Open File Explorer
# Look in bulk (E:) then Processing then SDC Data
There you should be able to find the script NormalizeFixedWIdth.pl. In order to run the script you must RDP onto the server and use PowerShell. There are 2 easy ways to get your file into the same folder as this script
# You could copy the script into the folder with the files you want to normalize
# You could copy the files you want to normalize into "E:\Processing\SDC Data" and then take it out once you are done normalizing it
Once you have performed one of the above steps you can use the script to normalize your text file. To do this:
# Open windows PowerShell
# use the cd (change directory) command to navigate to the place you put both the text file and the script, if you moved your text file, use "cd 'E:\Processing\SDC Data' ". The proper way to use this command is to type "cd (name of folder you want to move into without parentheses around it)" into PowerShell.
# PowerShell should say "PS E:\Processing\SDC Data>" or a different filepath if you moved the script.
# Now in order to use the script type "perl NormalizeFixedWidth.pl -file='name of file to normalize (make sure to include the single quotes on the outside and the file extension or the script won't work)' "
