I'm having issues with the names as highlighted below. Since some are single named and some are multiple named they all need to be in the same column.
01 000 01 000 001 5DN C Abuna's Chant# 0.019 0.038 0.008 0.019
I assume thats why the # sign is there but i can't figure out how to tell access to ignore the space from the single letter and start over at the #. Also that # needs to be stripped out eventually.
Any ideas? Below is some more lines to work with. It is in a standard .txt file.
Code:
01 000 01 000 001 5DN C Abuna's Chant# 0.019 0.038 0.008 0.019
01 000 01 000 002 5DN C Armed Response# 0.019 0.038 0.008 0.019
01 000 01 000 003 5DN R Auriok Champion# 2.640 4.656 1.980 3.492
01 000 01 000 004 5DN U Auriok Salvagers# 0.038 0.067 0.019 0.034
01 000 01 000 005 5DN R Auriok Windwalker# 0.115 0.672 0.066 0.437
01 000 01 000 006 5DN R Beacon of Immortality# 1.920 3.360 1.344 2.520
01 000 01 000 007 5DN R Bringer of the White Dawn# 0.864 1.536 0.562 1.075
01 000 01 000 008 5DN U Circle of Protection: Artifacts# 0.038 0.067 0.019 0.034
01 000 01 000 009 5DN C Leonin Squire# 0.115 0.480 0.066 0.274
01 000 01 000 010 5DN C Loxodon Anchorite# 0.019 0.038 0.008 0.019
01 000 01 000 011 5DN U Loxodon Stalwart# 0.038 0.067 0.019 0.034
01 000 01 000 012 5DN R Raksha Golden Cub# 0.768 1.440 0.499 1.008
01 000 01 000 013 5DN R Retaliate# 0.384 0.960 0.219 0.624
01 000 01 000 014 5DN R Roar of Reclamation# 0.115 0.672 0.066 0.437
01 000 01 000 015 5DN C Skyhunter Prowler# 0.019 0.038 0.008 0.019
01 000 01 000 016 5DN U Skyhunter Skirmisher# 0.048 0.067 0.024 0.034
01 000 01 000 017 5DN C Stand Firm# 0.019 0.038 0.008 0.019
01 000 01 000 018 5DN C Stasis Cocoon# 0.019 0.038 0.008 0.019
01 000 01 000 019 5DN U Steelshaper's Gift# 0.384 1.152 0.219 0.806
01 000 01 000 020 5DN U Vanquish# 0.038 0.067 0.019 0.034
01 000 01 000 021 5DN R Acquire# 0.192 0.672 0.109 0.437
01 000 01 000 022 5DN C Advanced Hoverguard# 0.019 0.038 0.008 0.019
01 000 01 000 023 5DN R Artificer's Intuition# 0.288 0.672 0.164 0.437
01 000 01 000 024 5DN R Beacon of Tomorrows# 0.960 1.680 0.624 1.176
01 000 01 000 025 5DN R Blinkmoth Infusion# 0.096 0.672 0.048 0.437
01 000 01 000 026 5DN R Bringer of the Blue Dawn# 2.640 13.440 1.980 11.424
01 000 01 000 027 5DN C Condescend# 0.240 0.960 0.137 0.624
01 000 01 000 028 5DN U Disruption Aura# 0.038 0.067 0.019 0.034
01 000 01 000 029 5DN C Early Frost# 0.077 0.336 0.039 0.192
01 000 01 000 030 5DN U Eyes of the Watcher# 0.038 0.067 0.019 0.034
01 000 01 000 031 5DN U Fold into Æther# 0.038 0.067 0.019 0.034
01 000 01 000 032 5DN R Hoverguard Sweepers# 0.192 0.672 0.109 0.437
01 000 01 000 033 5DN C Into Thin Air# 0.019 0.038 0.008 0.019
01 000 01 000 034 5DN U Plasma Elemental# 0.038 0.067 0.019 0.034
01 000 01 000 035 5DN U Qumulox# 0.038 0.067 0.019 0.034
01 000 01 000 036 5DN C Serum Visions# 0.115 1.152 0.066 0.806
01 000 01 000 037 5DN R Spectral Shift# 0.192 0.672 0.109 0.437
01 000 01 000 038 5DN C Thought Courier# 0.019 0.038 0.008 0.019
01 000 01 000 039 5DN C Trinket Mage# 0.480 4.800 0.274 3.600
01 000 01 000 040 5DN U Vedalken Mastermind# 0.038 0.067 0.019 0.034
01 000 01 000 041 5DN R Beacon of Unrest# 2.160 3.792 1.620 2.844
01 000 01 000 042 5DN C Blind Creeper# 0.019 0.038 0.008 0.019
01 000 01 000 043 5DN R Bringer of the Black Dawn# 1.440 2.544 1.008 1.908
01 000 01 000 044 5DN C Cackling Imp# 0.019 0.038 0.008 0.019
01 000 01 000 045 5DN R Desecration Elemental# 0.115 0.672 0.066 0.437
01 000 01 000 046 5DN U Devour in Shadow# 0.038 0.067 0.019 0.034
01 000 01 000 047 5DN C Dross Crocodile# 0.019 0.038 0.008 0.019
01 000 01 000 048 5DN U Ebon Drake# 0.038 0.067 0.019 0.034