bLAcKmAgE87
-
Content Count
104 -
Joined
-
Last visited
-
Medals
.thumb.png.c084df258e8e0164151d25982b70cd42.png)
Single Status Update
See all updates by bLAcKmAgE87
-
so far...I'm stuck... STUCK... building a hash map... not because arrays are slow or un-fancible... but because of the way that data is inevitably structured... if it can't be evenly sorted into an array without a god amount of code, then my other strategy is to avoid scanning up headers to slot in...
AVOID... then... that is, build each data piece with its key, since each piece of data CANNOT BE correlated with its HEADER AMONGST other DATA CELLS.
So...thinking ahead.. I shouldn't use hash maps to build functions, that is for our arrays. Instead I need to use them to carry on important transitions into the arrays themselves. A compete and total bitch when using an array. Guessing the first and last of, well, every column and title at the same time.
https://community.bistudio.com/wiki/HashMap
Spoiler_configElementsVehicles = []; _configElementsVehicles = "true" configClasses (configFile >> "120mm_HE") ; _countVehicleElements = count _configElementsVehicles ; _configBinElementsVehicles = [] ; _BEVscanword = 'bin\config.bin/120mm_HE/' ; _countBEVscanword = count _BEVscanword ; _type = _BEVscanword ; for [{ _pop = 0 }, { _pop < _countVehicleElements }, { _pop = _pop + 1 }] do { _selectedElementFromCV = _configElementsVehicles select _pop ; _convertedSelection = (str _selectedElementFromCV) ; _findTypeSelection = _convertedSelection find _BEVscanword ; if(_findTypeSelection != -1) then { _configBinElementsVehicles pushBack _selectedElementFromCV ; }; }; _countAbleSelections = count _configBinElementsVehicles ; _convertedListCV = [] ; for [{ _pop = 0 }, { _pop < _countAbleSelections }, { _pop = _pop + 1 }] do { _currentBinElementCV = _configBinElementsVehicles select _pop ; _currentBinElementCV = (str _currentBinElementCV) ; _newSelectionIndx = count _currentBinElementCV ; _newSelectionIndx = _newSelectionIndx - _countBEVscanword ; _newSelectionIndx = _newSelectionIndx ; _convertedSelectionElement = _currentBinElementCV select [ _countBEVscanword , _newSelectionIndx ] ; _convertedListCV pushBack _convertedSelectionElement ; }; _col1 = [] ; _col2 = [] ; _col3 = [] ; for[{_pop = 0 },{_pop < _countAbleSelections},{_pop = _pop + 1}] do { currentCheckSlot = _convertedListCV select _pop ; _configs = configProperties [configFile >> "120mm_HE" >> currentCheckSlot ]; _configs2 = getText (configFile >> "120mm_HE" >> currentCheckSlot >> "simulation" ) ; _configs3 = getText (configFile >> "120mm_HE" >> currentCheckSlot >> "type" ) ; _configsC = count str _configs ; _configsC = _configsC - _countBEVscanword ; _configsC = _configsC ; _configsD = str (_configs select 0 ) ; _configsD = _configsD select [ _countBEVscanword , _configsC ] ; _col1 pushBack _configsD ; _col2 pushBack _configs2 ; _col3 pushBack _configs3 ; }; //hint (str _col1 + " | "+ str count _col1 ) ; _elementsToTake = [] ; _CVelementJoint = [] ; for [{ _pop = 0 }, { _pop < _countAbleSelections }, { _pop = _pop + 1 }] do { _listedElement = _convertedListCV select _pop ; _hasFuelTanks = _col2 select _pop ; _scanword = 'Weapon' ; _convertedHasWord = (str _hasFuelTanks ); _decisionToTakeElement = _convertedHasWord find _scanword ; //if( _decisionToTakeElement >= 0 ) then //{ _elementsToTake pushBack _listedElement ; _CVelementJoint pushBack _listedElement ; //}; }; _countTakenElements = count _elementsToTake ; hint("loop layer starting | " + str _countTakenElements ) ; //sleep 2 ; _CVelementProperties = [] ; private _objNamePass = "" ; _someLine = "" ; for [{private _gh = 0 }, { _gh < _countTakenElements }, { _gh = _gh + 1 }] do { _savedObjectDimensions = [] ; _selectedElementSlotTitle = _elementsToTake select _gh ; _selectedCVelement = _elementsToTake select _gh ; _configGM = configProperties [configFile >> "120mm_HE" >> _selectedElementSlotTitle ] ; _configsCD = count str _configGM ; //_configsCD = _configsCD - _countBEVscanword ; //_configsCD = _configsCD ; _configsG = str _configGM; //_configsG = _configsG select [ _countBEVscanword , _configsCD ] ; _fool = "" ; _fool = _configsG regexReplace ["bin\\config\.bin\/120mm_HE" ,""]; _fool = _fool regexReplace [_selectedElementSlotTitle, "" ] ; _fool = _fool regexReplace ["/.", "" ] ; _foolC = (count _fool) ; //_fool = _fool select [ 2 , _foolC] ; //_fool = _configsG regexReplace ["bin\\config\.bin\//g" ,""]; //_fools = str _fool ; _savedObjectDimensions pushBack ( _selectedElementSlotTitle) ; _newFool = [] ; _fool = _fool splitString "," ; { _x = _x regexReplace ["\[" , ""] ; _x = _x regexReplace ["\]" , ""] ; _newFool pushBack _x ; } foreach _fool ; _savedObjectDimensions pushBack ( _newFool ) ; //_savedObjectDimensions pushBack ( str _configYM) ; //_savedObjectDimensions pushBack ( str _configCM) ; if(_gh == 0 ) then { _someLine = _newFool ; }; _CVelementProperties pushBack ( _savedObjectDimensions) ; }; //hint ( str (((_CVelementProperties select 0 ) select 1 ) select 0 ) + " | " + ( str ( count _CVelementProperties ) ) ); //hint str _CVelementProperties ; //sleep 3 ; _incr = 0 ; _popAry = [] ; { _title = _x select 0 ; _parts = _x select 1 ; _partsC = count _parts ; //hint str _parts ; _finally = [] ; _finally pushBack ( "_|"); for [{private _gh = 0 }, { _gh < _partsC }, { _gh = _gh + 1 }] do { _part = _parts select _gh ; _configsX = configFile >> "120mm_HE" >> _title >> _part ; _sepWord = " | " ; _finally pushBack _sepWord ; _finally pushBack _part ; switch ( true ) do { case (isNumber _configsX): {_finally pushBack getNumber _configsX }; case (isText _configsX): {_finally pushBack getText _configsX }; case (isArray _configsX): {_finally pushBack getArray _configsX; }; default { nil }; }; //hint str _finally ; //sleep 2 ; //((_CVelementProperties select _incr ) select 1) insert [ -1, _finally ] ; }; _finally pushBack ( "_+|"); hint str _finally ; sleep 1 ; _popAry pushBack _title ; _popAry pushBack _finally ; _incr = _incr + 1 ; } foreach _CVelementProperties ; hint "end layer" ; copyToClipBoard (str _popAry ) ; /* --preceeding code almost worked except in order to build the base you have to manually move elements --and label the headers from the breaktags DROP TABLE IF EXISTS a3_120mm_HE ; CREATE TABLE a3_120mm_HE ( title text , Simulation text , QualityLevel decimal , tType text, pPosition text , Intensity decimal , Intervals text, LifeTime decimal ); SELECT * FROM a3_120mm_HE ; */
...well... if you get to the bottom and can read the headers... SELECT * FROM a3_120mm_HE ; in sql
"blast_wave_refract" "particles" " blast_wave_effect_medium " " [0,0,0] " 1 " 3 * 1 " 0.2 "ExplodeRefract" "particles" " blast_wave_med " " [0,0,0] " 1 "1" 1 "DustLongMediumMed" "particles" 1 " DustLongMedium " " [0,0,0] " 1 "1" 1 "DustLongMedium" "particles" 2 " DustLongMedium " " [0,0,0] " 1 "1" 1 "ExplosionDustLong" "particles" " ExplosionDustLong " " [0,0,0] " 0.2 "1" 1 "ShrapnelFast" "particles" " ShrapnelFast " " [0,0,0] " 1 "1" 3 "ShrapnelLong" "particles" " ShrapnelLong " " [0,0,0] " 1 "1" 20 "GroundDustCottonMed" "particles" 2 " GroundDustCottonMed " " [0,0,0] " 0.1 "1" 0.5 "DustFast" "particles" " DustFast " " [0,0,0] " 1 "1" 0.5
-
big compaines with the issue
Spoilerlet Source = Table.FromColumns({Lines.FromBinary(File.Contents("X:\sourceWeaps.txt"), null, null, 1252)}), #"Split Column by Delimiter" = Table.ExpandListColumn(Table.TransformColumns(Source, {{"Column1", Splitter.SplitTextByDelimiter(",""+|"",", QuoteStyle.None), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Column1"), #"Changed Type" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Column1", type text}}), #"Split Column by Delimiter1" = Table.SplitColumn(#"Changed Type", "Column1", Splitter.SplitTextByEachDelimiter({","}, QuoteStyle.None, false), {"Column1.1", "Column1.2"}), #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter1",{{"Column1.1", type text}, {"Column1.2", type text}}), #"Split Column by Delimiter2" = Table.SplitColumn(#"Changed Type1", "Column1.2", Splitter.SplitTextByEachDelimiter({","}, QuoteStyle.None, false), {"Column1.2.1", "Column1.2.2"}), #"Changed Type2" = Table.TransformColumnTypes(#"Split Column by Delimiter2",{{"Column1.2.1", type text}, {"Column1.2.2", type text}}), #"Split Column by Delimiter3" = Table.SplitColumn(#"Changed Type2", "Column1.2.2", Splitter.SplitTextByEachDelimiter({","}, QuoteStyle.None, false), {"Column1.2.2.1", "Column1.2.2.2"}), #"Changed Type3" = Table.TransformColumnTypes(#"Split Column by Delimiter3",{{"Column1.2.2.1", type text}, {"Column1.2.2.2", type text}}), #"Split Column by Delimiter4" = Table.SplitColumn(#"Changed Type3", "Column1.2.2.2", Splitter.SplitTextByEachDelimiter({","}, QuoteStyle.None, false), {"Column1.2.2.2.1", "Column1.2.2.2.2"}), #"Changed Type4" = Table.TransformColumnTypes(#"Split Column by Delimiter4",{{"Column1.2.2.2.1", type text}, {"Column1.2.2.2.2", type text}}), #"Split Column by Delimiter5" = Table.SplitColumn(#"Changed Type4", "Column1.2.2.2.2", Splitter.SplitTextByEachDelimiter({","}, QuoteStyle.None, false), {"Column1.2.2.2.2.1", "Column1.2.2.2.2.2"}), #"Changed Type5" = Table.TransformColumnTypes(#"Split Column by Delimiter5",{{"Column1.2.2.2.2.1", Int64.Type}, {"Column1.2.2.2.2.2", type text}}), #"Split Column by Delimiter6" = Table.SplitColumn(#"Changed Type5", "Column1.2.2.2.2.2", Splitter.SplitTextByEachDelimiter({","}, QuoteStyle.None, false), {"Column1.2.2.2.2.2.1", "Column1.2.2.2.2.2.2"}), #"Changed Type6" = Table.TransformColumnTypes(#"Split Column by Delimiter6",{{"Column1.2.2.2.2.2.1", Int64.Type}, {"Column1.2.2.2.2.2.2", type text}}), #"Split Column by Delimiter7" = Table.SplitColumn(#"Changed Type6", "Column1.2.2.2.2.2.2", Splitter.SplitTextByEachDelimiter({","}, QuoteStyle.None, false), {"Column1.2.2.2.2.2.2.1", "Column1.2.2.2.2.2.2.2"}), #"Changed Type7" = Table.TransformColumnTypes(#"Split Column by Delimiter7",{{"Column1.2.2.2.2.2.2.1", Int64.Type}, {"Column1.2.2.2.2.2.2.2", type text}}), #"Split Column by Delimiter8" = Table.SplitColumn(#"Changed Type7", "Column1.2.2.2.2.2.2.2", Splitter.SplitTextByEachDelimiter({","}, QuoteStyle.None, false), {"Column1.2.2.2.2.2.2.2.1", "Column1.2.2.2.2.2.2.2.2"}), #"Changed Type8" = Table.TransformColumnTypes(#"Split Column by Delimiter8",{{"Column1.2.2.2.2.2.2.2.1", Int64.Type}, {"Column1.2.2.2.2.2.2.2.2", type text}}), #"Split Column by Delimiter9" = Table.SplitColumn(#"Changed Type8", "Column1.2.2.2.2.2.2.2.2", Splitter.SplitTextByEachDelimiter({","}, QuoteStyle.None, false), {"Column1.2.2.2.2.2.2.2.2.1", "Column1.2.2.2.2.2.2.2.2.2"}), #"Changed Type9" = Table.TransformColumnTypes(#"Split Column by Delimiter9",{{"Column1.2.2.2.2.2.2.2.2.1", type number}, {"Column1.2.2.2.2.2.2.2.2.2", type text}}), #"Split Column by Delimiter10" = Table.SplitColumn(#"Changed Type9", "Column1.2.2.2.2.2.2.2.2.2", Splitter.SplitTextByEachDelimiter({","}, QuoteStyle.None, false), {"Column1.2.2.2.2.2.2.2.2.2.1", "Column1.2.2.2.2.2.2.2.2.2.2"}), #"Changed Type10" = Table.TransformColumnTypes(#"Split Column by Delimiter10",{{"Column1.2.2.2.2.2.2.2.2.2.1", type text}, {"Column1.2.2.2.2.2.2.2.2.2.2", type text}}), #"Split Column by Delimiter11" = Table.SplitColumn(#"Changed Type10", "Column1.2.2.2.2.2.2.2.2.2.2", Splitter.SplitTextByEachDelimiter({","}, QuoteStyle.None, false), {"Column1.2.2.2.2.2.2.2.2.2.2.1", "Column1.2.2.2.2.2.2.2.2.2.2.2"}), #"Changed Type11" = Table.TransformColumnTypes(#"Split Column by Delimiter11",{{"Column1.2.2.2.2.2.2.2.2.2.2.1", type number}, {"Column1.2.2.2.2.2.2.2.2.2.2.2", type text}}), #"Split Column by Delimiter12" = Table.SplitColumn(#"Changed Type11", "Column1.2.2.2.2.2.2.2.2.2.2.2", Splitter.SplitTextByEachDelimiter({","}, QuoteStyle.None, false), {"Column1.2.2.2.2.2.2.2.2.2.2.2.1", "Column1.2.2.2.2.2.2.2.2.2.2.2.2"}), #"Changed Type12" = Table.TransformColumnTypes(#"Split Column by Delimiter12",{{"Column1.2.2.2.2.2.2.2.2.2.2.2.1", type number}, {"Column1.2.2.2.2.2.2.2.2.2.2.2.2", type text}}), #"Split Column by Delimiter13" = Table.SplitColumn(#"Changed Type12", "Column1.2.2.2.2.2.2.2.2.2.2.2.2", Splitter.SplitTextByEachDelimiter({","}, QuoteStyle.None, false), {"Column1.2.2.2.2.2.2.2.2.2.2.2.2.1", "Column1.2.2.2.2.2.2.2.2.2.2.2.2.2"}), #"Changed Type13" = Table.TransformColumnTypes(#"Split Column by Delimiter13",{{"Column1.2.2.2.2.2.2.2.2.2.2.2.2.1", type number}, {"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2", type text}}), #"Split Column by Delimiter14" = Table.SplitColumn(#"Changed Type13", "Column1.2.2.2.2.2.2.2.2.2.2.2.2.2", Splitter.SplitTextByEachDelimiter({","}, QuoteStyle.None, false), {"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.1", "Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2"}), #"Changed Type14" = Table.TransformColumnTypes(#"Split Column by Delimiter14",{{"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.1", type number}, {"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2", type text}}), #"Split Column by Delimiter15" = Table.SplitColumn(#"Changed Type14", "Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2", Splitter.SplitTextByEachDelimiter({","}, QuoteStyle.None, false), {"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.1", "Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2"}), #"Changed Type15" = Table.TransformColumnTypes(#"Split Column by Delimiter15",{{"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.1", type number}, {"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2", type text}}), #"Split Column by Delimiter16" = Table.SplitColumn(#"Changed Type15", "Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2", Splitter.SplitTextByEachDelimiter({","}, QuoteStyle.None, false), {"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.1", "Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2"}), #"Changed Type16" = Table.TransformColumnTypes(#"Split Column by Delimiter16",{{"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.1", type text}, {"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2", type text}}), #"Split Column by Delimiter17" = Table.SplitColumn(#"Changed Type16", "Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2", Splitter.SplitTextByEachDelimiter({","}, QuoteStyle.None, false), {"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.1", "Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2"}), #"Changed Type17" = Table.TransformColumnTypes(#"Split Column by Delimiter17",{{"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.1", Int64.Type}, {"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2", type text}}), #"Split Column by Delimiter18" = Table.SplitColumn(#"Changed Type17", "Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2", Splitter.SplitTextByEachDelimiter({","}, QuoteStyle.None, false), {"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.1", "Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2"}), #"Changed Type18" = Table.TransformColumnTypes(#"Split Column by Delimiter18",{{"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.1", type text}, {"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2", type text}}), #"Split Column by Delimiter19" = Table.SplitColumn(#"Changed Type18", "Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2", Splitter.SplitTextByDelimiter(""",""[", QuoteStyle.None), {"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.1", "Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2"}), #"Changed Type19" = Table.TransformColumnTypes(#"Split Column by Delimiter19",{{"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.1", type text}, {"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2", type text}}), #"Replaced Value" = Table.ReplaceValue(#"Changed Type19","[","",Replacer.ReplaceText,{"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.1"}), #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","]","",Replacer.ReplaceText,{"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2"}), #"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1","]","",Replacer.ReplaceText,{"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.1"}), #"Replaced Value3" = Table.ReplaceValue(#"Replaced Value2","""""","""",Replacer.ReplaceText,{"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.1"}), #"Replaced Value4" = Table.ReplaceValue(#"Replaced Value3","""""","""",Replacer.ReplaceText,{"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.1"}), #"Replaced Value5" = Table.ReplaceValue(#"Replaced Value4","""","",Replacer.ReplaceValue,{"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.1"}), #"Replaced Value6" = Table.ReplaceValue(#"Replaced Value5","""","",Replacer.ReplaceValue,{"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2"}), #"Replaced Value7" = Table.ReplaceValue(#"Replaced Value6","""""","""",Replacer.ReplaceText,{"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2"}), #"Replaced Value8" = Table.ReplaceValue(#"Replaced Value7","""""","""",Replacer.ReplaceText,{"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2"}), #"Replaced Value9" = Table.ReplaceValue(#"Replaced Value8","""","",Replacer.ReplaceText,{"Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.1"}), #"Replaced Value10" = Table.ReplaceValue(#"Replaced Value9","""","",Replacer.ReplaceText,{"Column1.1", "Column1.2.1", "Column1.2.2.1", "Column1.2.2.2.1", "Column1.2.2.2.2.2.2.2.2.2.1", "Column1.2.2.2.2.2.2.2.2.2.2.2.2.2.2.2.1"}), #"Replaced Value11" = Table.ReplaceValue(#"Replaced Value10","[","",Replacer.ReplaceText,{"Column1.1"}) in #"Replaced Value11"
-