Forum Discussion
Solved
Import correctly CSV into power query
Hello everyone, I am contacting you because I am having trouble importing a CSV file into Power Query, but without success... I can't seem to find the right method to do this. What drives me even c...
I can import the file using this MCode:
= Csv.Document(File.Contents("Z:\test.csv"),[Delimiter=";", Encoding=1201, QuoteStyle=QuoteStyle.Csv])
Or do I miss something?
Victory it works, so what differ between what I did and what you did is the encoding number you used "1201"
Could you explain me how you selected this "encoding system" ?
It's possible we are,
I tried to change the encoding in Power query
let
Source = Csv.Document(File.Contents("C:\Users\Alex.Ward\Downloads\test2\test.csv"),[Delimiter=";", Columns=1, Encoding=65001, QuoteStyle=QuoteStyle.None]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}})
in
#"Changed Type"
I now have a result similar to yours
Hopefully someone else can help
Thanks a lot to have tried to help me, I am strugglin with this since some days now !
I hope someone will find the solution.
Thanks a again
Try this:
let Source = Csv.Document(File.Contents("C:\Users\Alex.Ward\Downloads\test2\test.csv"),[Delimiter=";", Columns=100, Encoding=65001, QuoteStyle=QuoteStyle.None]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}), #"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]), #"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"#(0000)B#(0000)b#(0000)c#(0000)l#(0000)n#(0000) #(0000)b#(0000)z#(0000)n#(0000)b#(0000)T#(0000)T#(0000)", type text}}), #"Filtered Rows" = Table.SelectRows(#"Changed Type1", each ([#"#(0000)B#(0000)b#(0000)c#(0000)l#(0000)n#(0000) #(0000)b#(0000)z#(0000)n#(0000)b#(0000)T#(0000)T#(0000)"] = "#(0000)""#(0000)4#(0000)3#(0000)1#(0000)0#(0000)4#(0000)0#(0000)""#(0000)" or [#"#(0000)B#(0000)b#(0000)c#(0000)l#(0000)n#(0000) #(0000)b#(0000)z#(0000)n#(0000)b#(0000)T#(0000)T#(0000)"] = "#(0000)""#(0000)4#(0000)3#(0000)1#(0000)0#(0000)4#(0000)4#(0000)""#(0000)" or [#"#(0000)B#(0000)b#(0000)c#(0000)l#(0000)n#(0000) #(0000)b#(0000)z#(0000)n#(0000)b#(0000)T#(0000)T#(0000)"] = "#(0000)""#(0000)4#(0000)3#(0000)4#(0000)0#(0000)3#(0000)3#(0000)""#(0000)" or [#"#(0000)B#(0000)b#(0000)c#(0000)l#(0000)n#(0000) #(0000)b#(0000)z#(0000)n#(0000)b#(0000)T#(0000)T#(0000)"] = "#(0000)""#(0000)4#(0000)3#(0000)4#(0000)0#(0000)7#(0000)8#(0000)""#(0000)" or [#"#(0000)B#(0000)b#(0000)c#(0000)l#(0000)n#(0000) #(0000)b#(0000)z#(0000)n#(0000)b#(0000)T#(0000)T#(0000)"] = "#(0000)""#(0000)4#(0000)3#(0000)4#(0000)0#(0000)8#(0000)0#(0000)""#(0000)" or [#"#(0000)B#(0000)b#(0000)c#(0000)l#(0000)n#(0000) #(0000)b#(0000)z#(0000)n#(0000)b#(0000)T#(0000)T#(0000)"] = "#(0000)""#(0000)4#(0000)3#(0000)4#(0000)0#(0000)8#(0000)1#(0000)""#(0000)" or [#"#(0000)B#(0000)b#(0000)c#(0000)l#(0000)n#(0000) #(0000)b#(0000)z#(0000)n#(0000)b#(0000)T#(0000)T#(0000)"] = "#(0000)""#(0000)4#(0000)3#(0000)4#(0000)0#(0000)8#(0000)3#(0000)""#(0000)" or [#"#(0000)B#(0000)b#(0000)c#(0000)l#(0000)n#(0000) #(0000)b#(0000)z#(0000)n#(0000)b#(0000)T#(0000)T#(0000)"] = "#(0000)""#(0000)4#(0000)3#(0000)4#(0000)0#(0000)8#(0000)4#(0000)""#(0000)")), #"Replaced Value1" = Table.ReplaceValue(#"Filtered Rows","""","",Replacer.ReplaceText,{"#(0000)B#(0000)b#(0000)c#(0000)l#(0000)n#(0000) #(0000)b#(0000)z#(0000)n#(0000)b#(0000)T#(0000)T#(0000)", "#(0000)b#(0000)l#(0000)b#(0000)T#(0000)l#(0000)t#(0000)T#(0000)n#(0000) #(0000)b#(0000)p#(0000)", "#(0000)p#(0000)T#(0000)c#(0000)B#(0000)b#(0000)T#(0000) #(0000)c#(0000)B#(0000)B#(0000)p#(0000)z#(0000)b#(0000)t#(0000) #(0000)b#(0000)p#(0000)", "#(0000)c#(0000)B#(0000)B#(0000)p#(0000)z#(0000)b#(0000)t#(0000) #(0000)b#(0000)c#(0000)n#(0000)T#(0000)", "#(0000)B#(0000)z#(0000)s#(0000)t#(0000)p#(0000)n#(0000)T#(0000)T#(0000) #(0000)T#(0000)y#(0000)p#(0000)T#(0000)", "#(0000)S#(0000)T#(0000)T#(0000)v#(0000)l#(0000)B#(0000)T#(0000) #(0000)G#(0000)T#(0000)p#(0000)z#(0000)p#(0000)", "#(0000)S#(0000)c#(0000)b#(0000)T#(0000)s#(0000) #(0000)p#(0000)X#(0000)X#(0000)l#(0000)B#(0000)T#(0000)", "#(0000)T#(0000)T#(0000)X#(0000)T#(0000)T#(0000)T#(0000)b#(0000)B#(0000)T#(0000) #(0000)b#(0000)p#(0000)", "#(0000)X#(0000)c#(0000)n#(0000)l#(0000)b#(0000)y#(0000) #(0000)G#(0000)T#(0000)p#(0000)z#(0000)p#(0000)", "#(0000)n#(0000)p#(0000)d#(0000)T#(0000)b#(0000) #(0000)b#(0000)p#(0000)", "#(0000)P#(0000)T#(0000)p#(0000)d#(0000)z#(0000)B#(0000)t#(0000) #(0000)G#(0000)T#(0000)p#(0000)z#(0000)p#(0000)", "#(0000)P#(0000)p#(0000)w#(0000)T#(0000)T#(0000) #(0000)S#(0000)z#(0000)p#(0000)p#(0000)b#(0000)y#(0000)", "#(0000)z#(0000)b#(0000)l#(0000)t#(0000) #(0000)S#(0000)T#(0000)T#(0000)l#(0000)c#(0000)b#(0000) #(0000)b#(0000)p#(0000)", "#(0000)T#(0000)p#(0000)l#(0000)d#(0000)T#(0000)n#(0000)l#(0000)B#(0000)", "#(0000)B#(0000)p#(0000)n#(0000)n#(0000)T#(0000)T#(0000)B#(0000)l#(0000)c#(0000)b#(0000) #(0000)P#(0000)T#(0000)T#(0000)B#(0000)c#(0000)z#(0000)t#(0000)l#(0000)p#(0000)b#(0000)", "#(0000)X#(0000)c#(0000)B#(0000)t#(0000)p#(0000)T#(0000)y#(0000) #(0000)B#(0000)p#(0000)d#(0000)T#(0000)", "#(0000)D#(0000)c#(0000)t#(0000)T#(0000) #(0000)D#(0000)T#(0000)s#(0000)p#(0000)c#(0000)t#(0000)B#(0000)h#(0000)T#(0000)d#(0000)", "#(0000)D#(0000)T#(0000)s#(0000)p#(0000)c#(0000)t#(0000)B#(0000)h#(0000)T#(0000)d#(0000) #(0000)T#(0000)p#(0000)", "#(0000)W#(0000)c#(0000)T#(0000)T#(0000)h#(0000)p#(0000)z#(0000)s#(0000)T#(0000) #(0000)D#(0000)T#(0000)s#(0000)p#(0000)c#(0000)t#(0000)B#(0000)h#(0000)T#(0000)d#(0000) #(0000)X#(0000)T#(0000)p#(0000)n#(0000)", "#(0000)D#(0000)c#(0000)t#(0000)T#(0000) #(0000)p#(0000)X#(0000) #(0000)D#(0000)T#(0000)s#(0000)p#(0000)c#(0000)t#(0000)B#(0000)h#(0000) #(0000)X#(0000)T#(0000)p#(0000)n#(0000) #(0000)W#(0000)c#(0000)T#(0000)T#(0000)h#(0000)p#(0000)z#(0000)s#(0000)T#(0000)", "#(0000)D#(0000)T#(0000)s#(0000)p#(0000)c#(0000)t#(0000)B#(0000)h#(0000)T#(0000)d#(0000) #(0000)T#(0000)p#(0000)_1", "#(0000)p#(0000)T#(0000)d#(0000)T#(0000)T#(0000) #(0000)T#(0000)T#(0000)X#(0000)T#(0000)T#(0000)T#(0000)b#(0000)B#(0000)T#(0000)", "#(0000)S#(0000)t#(0000)p#(0000)T#(0000)c#(0000)g#(0000)T#(0000) #(0000)b#(0000)p#(0000)B#(0000)c#(0000)t#(0000)l#(0000)p#(0000)b#(0000)", "#(0000)B#(0000)z#(0000)y#(0000) #(0000)T#(0000)p#(0000)t#(0000)c#(0000)b#(0000) #(0000)V#(0000)c#(0000)b#(0000)z#(0000)T#(0000)", "#(0000)B#(0000)z#(0000)s#(0000)t#(0000)p#(0000)n#(0000)T#(0000)T#(0000) #(0000)T#(0000)p#(0000)t#(0000)c#(0000)b#(0000) #(0000)V#(0000)c#(0000)b#(0000)z#(0000)T#(0000)", "#(0000)X#(0000)c#(0000)B#(0000)t#(0000)p#(0000)T#(0000)y#(0000) #(0000)n#(0000)p#(0000)d#(0000)T#(0000)b#(0000) #(0000)B#(0000)p#(0000)d#(0000)T#(0000)", "#(0000)c#(0000)d#(0000)n#(0000)l#(0000)b#(0000) #(0000)c#(0000)p#(0000)p#(0000)T#(0000)p#(0000)v#(0000)c#(0000)b#(0000) #(0000)D#(0000)c#(0000)t#(0000)T#(0000)", "#(0000)T#(0000)b#(0000)g#(0000)l#(0000)b#(0000)T#(0000)T#(0000)T#(0000) #(0000)c#(0000)p#(0000)p#(0000)T#(0000)p#(0000)v#(0000)c#(0000)b#(0000) #(0000)D#(0000)c#(0000)t#(0000)T#(0000)", "#(0000)X#(0000)c#(0000)B#(0000)t#(0000)p#(0000)T#(0000)y#(0000) #(0000)c#(0000)p#(0000)p#(0000)T#(0000)p#(0000)v#(0000)c#(0000)b#(0000) #(0000)D#(0000)c#(0000)t#(0000)T#(0000)", "#(0000)T#(0000)S#(0000)n#(0000) #(0000)c#(0000)p#(0000)p#(0000)T#(0000)p#(0000)v#(0000)c#(0000)b#(0000) #(0000)D#(0000)c#(0000)t#(0000)T#(0000)", "#(0000)B#(0000)p#(0000)n#(0000)p#(0000)T#(0000)T#(0000)s#(0000)s#(0000)p#(0000)T#(0000) #(0000)n#(0000)p#(0000)d#(0000)T#(0000)b#(0000)", "#(0000)B#(0000)p#(0000)n#(0000)p#(0000)T#(0000)T#(0000)s#(0000)s#(0000)p#(0000)T#(0000) #(0000)S#(0000)T#(0000)T#(0000)l#(0000)c#(0000)b#(0000) #(0000)b#(0000)p#(0000)", "#(0000)z#(0000)b#(0000)l#(0000)t#(0000) #(0000)P#(0000)z#(0000)T#(0000)B#(0000)h#(0000)c#(0000)s#(0000)T#(0000)d#(0000) #(0000)X#(0000)T#(0000)p#(0000)n#(0000)", "#(0000)l#(0000)b#(0000)v#(0000)p#(0000)l#(0000)B#(0000)T#(0000) #(0000)D#(0000)c#(0000)t#(0000)T#(0000)", "#(0000)l#(0000)b#(0000)s#(0000)t#(0000)c#(0000)b#(0000)b#(0000)c#(0000)t#(0000)l#(0000)p#(0000)b#(0000) #(0000)D#(0000)c#(0000)t#(0000)T#(0000)", "#(0000)X#(0000)c#(0000)l#(0000)b#(0000)z#(0000)T#(0000)T#(0000) #(0000)D#(0000)c#(0000)t#(0000)T#(0000)", "#(0000)T#(0000)x#(0000)t#(0000)T#(0000)b#(0000)d#(0000)T#(0000)d#(0000) #(0000)W#(0000)c#(0000)T#(0000)T#(0000)c#(0000)b#(0000)t#(0000)y#(0000)", "#(0000)b#(0000)c#(0000)b#(0000)p#(0000)z#(0000)T#(0000) #(0000)B#(0000)p#(0000)s#(0000)t#(0000) #(0000)l#(0000)b#(0000)B#(0000)b#(0000)z#(0000)d#(0000)T#(0000)d#(0000)", "#(0000)D#(0000)c#(0000)y#(0000)s#(0000) #(0000)s#(0000)l#(0000)b#(0000)B#(0000)T#(0000) #(0000)l#(0000)b#(0000)s#(0000)t#(0000).#(0000)", "#(0000)D#(0000)c#(0000)y#(0000)s#(0000) #(0000)s#(0000)l#(0000)b#(0000)B#(0000)T#(0000) #(0000)X#(0000)c#(0000)l#(0000)b#(0000)", "#(0000)X#(0000)c#(0000)l#(0000)b#(0000)z#(0000)T#(0000)T#(0000) #(0000)B#(0000)c#(0000)t#(0000)T#(0000)g#(0000)p#(0000)T#(0000)y#(0000)", "#(0000)D#(0000)T#(0000)t#(0000)c#(0000)l#(0000)b#(0000)s#(0000) #(0000)p#(0000)X#(0000) #(0000)X#(0000)c#(0000)l#(0000)b#(0000)z#(0000)T#(0000)T#(0000)", "#(0000)T#(0000)b#(0000)g#(0000)b#(0000)l#(0000)s#(0000)h#(0000) #(0000)T#(0000)T#(0000)c#(0000)b#(0000)s#(0000)b#(0000)c#(0000)t#(0000)l#(0000)p#(0000)b#(0000)", "#(0000)T#(0000)b#(0000)t#(0000)T#(0000)y#(0000) #(0000)D#(0000)c#(0000)t#(0000)T#(0000)", "#(0000)S#(0000)z#(0000)b#(0000)n#(0000)l#(0000)s#(0000)s#(0000)l#(0000)p#(0000)b#(0000) #(0000)D#(0000)c#(0000)t#(0000)T#(0000)", "#(0000)S#(0000)z#(0000)b#(0000)n#(0000)l#(0000)s#(0000)s#(0000)l#(0000)p#(0000)b#(0000) #(0000)T#(0000)l#(0000)n#(0000)T#(0000)", "#(0000)S#(0000)z#(0000)b#(0000)n#(0000)l#(0000)t#(0000)t#(0000)T#(0000)d#(0000) #(0000)B#(0000)y#(0000)", "#(0000)S#(0000)t#(0000)c#(0000)t#(0000)z#(0000)s#(0000)", "#(0000)T#(0000)T#(0000)c#(0000)s#(0000)p#(0000)b#(0000) #(0000)B#(0000)p#(0000)d#(0000)T#(0000)", "#(0000)B#(0000)p#(0000)n#(0000)n#(0000)T#(0000)b#(0000)t#(0000)s#(0000)", "#(0000)n#(0000)p#(0000)d#(0000)l#(0000)X#(0000)l#(0000)T#(0000)d#(0000) #(0000)B#(0000)y#(0000)", "#(0000)n#(0000)p#(0000)d#(0000)l#(0000)X#(0000)l#(0000)T#(0000)d#(0000) #(0000)D#(0000)c#(0000)t#(0000)T#(0000)", "#(0000)T#(0000)T#(0000)X#(0000)T#(0000)T#(0000) #(0000)T#(0000)p#(0000)", "#(0000)P#(0000)c#(0000)T#(0000)t#(0000) #(0000)b#(0000)z#(0000)n#(0000)b#(0000)T#(0000)T#(0000)", "#(0000)P#(0000)c#(0000)T#(0000)t#(0000) #(0000)D#(0000)T#(0000)s#(0000)B#(0000)T#(0000)l#(0000)p#(0000)t#(0000)l#(0000)p#(0000)b#(0000)", "#(0000)P#(0000)c#(0000)T#(0000)t#(0000) #(0000)D#(0000)T#(0000)s#(0000)B#(0000)T#(0000)l#(0000)p#(0000)t#(0000)l#(0000)p#(0000)b#(0000) #(0000)p#(0000)t#(0000)h#(0000)T#(0000)T#(0000)", "#(0000)P#(0000)c#(0000)T#(0000)t#(0000) #(0000)Q#(0000)z#(0000)c#(0000)b#(0000)t#(0000)l#(0000)t#(0000)y#(0000)", "#(0000)S#(0000)c#(0000)b#(0000)T#(0000)s#(0000) #(0000)B#(0000)p#(0000)b#(0000)X#(0000)l#(0000)T#(0000)n#(0000)c#(0000)t#(0000)l#(0000)p#(0000)b#(0000) #(0000)b#(0000)z#(0000)n#(0000)b#(0000)T#(0000)T#(0000)", "#(0000)H#(0000)c#(0000)P#(0000)T#(0000) #(0000)t#(0000)p#(0000) #(0000)D#(0000)T#(0000)s#(0000)p#(0000)c#(0000)t#(0000)B#(0000)h#(0000)?#(0000)", "#(0000)b#(0000)c#(0000)b#(0000)p#(0000)z#(0000)T#(0000) #(0000)c#(0000)b#(0000)b#(0000)p#(0000)w#(0000)c#(0000)b#(0000)B#(0000)T#(0000)", "#(0000)z#(0000)b#(0000)l#(0000)t#(0000) #(0000)B#(0000)z#(0000)y#(0000) #(0000)P#(0000)T#(0000)l#(0000)B#(0000)T#(0000)", "#(0000)b#(0000)l#(0000)b#(0000)T#(0000) #(0000)B#(0000)z#(0000)y#(0000) #(0000)P#(0000)T#(0000)l#(0000)B#(0000)T#(0000)", "#(0000)z#(0000)b#(0000)l#(0000)t#(0000) #(0000)B#(0000)z#(0000)s#(0000)t#(0000)p#(0000)n#(0000)T#(0000)T#(0000) #(0000)P#(0000)T#(0000)l#(0000)B#(0000)T#(0000)", "#(0000)b#(0000)l#(0000)b#(0000)T#(0000) #(0000)B#(0000)z#(0000)s#(0000)t#(0000)p#(0000)n#(0000)T#(0000)T#(0000) #(0000)P#(0000)T#(0000)l#(0000)B#(0000)T#(0000)", "#(0000)B#(0000)z#(0000)s#(0000)t#(0000) #(0000)B#(0000)p#(0000)b#(0000)t#(0000)c#(0000)B#(0000)t#(0000)", "#(0000)B#(0000)z#(0000)s#(0000)t#(0000) #(0000)P#(0000)h#(0000)", "#(0000)B#(0000)z#(0000)s#(0000)t#(0000) #(0000)b#(0000)c#(0000)n#(0000)T#(0000)", "#(0000)B#(0000)z#(0000)s#(0000)t#(0000) #(0000)c#(0000)d#(0000)d#(0000) #(0000)4#(0000)", "#(0000)B#(0000)z#(0000)s#(0000)t#(0000) #(0000)c#(0000)d#(0000)d#(0000) #(0000)1#(0000)", "#(0000)B#(0000)z#(0000)s#(0000)t#(0000) #(0000)B#(0000)l#(0000)t#(0000)y#(0000)", "#(0000)B#(0000)z#(0000)s#(0000)t#(0000) #(0000)T#(0000)T#(0000)g#(0000)", "#(0000)B#(0000)z#(0000)s#(0000)t#(0000) #(0000)P#(0000)p#(0000)s#(0000)t#(0000) #(0000)B#(0000)p#(0000)d#(0000)T#(0000)", "#(0000)B#(0000)z#(0000)s#(0000)t#(0000) #(0000)B#(0000)p#(0000)z#(0000)b#(0000)t#(0000)T#(0000)y#(0000)", "#(0000)l#(0000)b#(0000)s#(0000)t#(0000)�#(0000)B#(0000)p#(0000)b#(0000)t#(0000)c#(0000)B#(0000)t#(0000)", "#(0000)l#(0000)b#(0000)s#(0000)t#(0000) #(0000)P#(0000)h#(0000)", "#(0000)l#(0000)b#(0000)s#(0000)t#(0000) #(0000)b#(0000)c#(0000)n#(0000)T#(0000)", "#(0000)l#(0000)b#(0000)s#(0000)t#(0000) #(0000)c#(0000)d#(0000)d#(0000) #(0000)4#(0000)", "#(0000)l#(0000)b#(0000)s#(0000)t#(0000) #(0000)c#(0000)d#(0000)d#(0000) #(0000)1#(0000)", "#(0000)l#(0000)b#(0000)s#(0000)t#(0000) #(0000)B#(0000)l#(0000)t#(0000)y#(0000)", "#(0000)l#(0000)b#(0000)s#(0000)t#(0000) #(0000)T#(0000)T#(0000)g#(0000)", "#(0000)l#(0000)b#(0000)s#(0000)t#(0000) #(0000)P#(0000)p#(0000)s#(0000)t#(0000) #(0000)B#(0000)p#(0000)d#(0000)T#(0000)", "#(0000)l#(0000)b#(0000)s#(0000)t#(0000) #(0000)B#(0000)p#(0000)z#(0000)b#(0000)t#(0000)T#(0000)y#(0000)", "#(0000)X#(0000)c#(0000)B#(0000)t#(0000)p#(0000)T#(0000)y#(0000) #(0000)D#(0000)T#(0000)s#(0000)p#(0000)c#(0000)t#(0000)B#(0000)h#(0000) #(0000)D#(0000)c#(0000)t#(0000)T#(0000)", "#(0000)D#(0000)l#(0000)X#(0000)X#(0000)T#(0000)T#(0000)T#(0000)b#(0000)B#(0000)T#(0000) #(0000)b#(0000)T#(0000)t#(0000)w#(0000)T#(0000)T#(0000)b#(0000) #(0000)X#(0000)c#(0000)B#(0000)t#(0000)p#(0000)T#(0000)y#(0000) #(0000)D#(0000)T#(0000)s#(0000)p#(0000)c#(0000)t#(0000)B#(0000)h#(0000) #(0000)D#(0000)c#(0000)t#(0000)T#(0000) #(0000)t#(0000)p#(0000) #(0000)X#(0000)c#(0000)l#(0000)b#(0000)z#(0000)T#(0000)T#(0000) #(0000)D#(0000)c#(0000)t#(0000)T#(0000)", "#(0000)W#(0000)c#(0000)T#(0000)T#(0000)h#(0000)p#(0000)z#(0000)s#(0000)T#(0000) #(0000)D#(0000)T#(0000)s#(0000)p#(0000)c#(0000)t#(0000)B#(0000)h#(0000) #(0000)D#(0000)c#(0000)t#(0000)T#(0000)", "#(0000)D#(0000)l#(0000)X#(0000)X#(0000)T#(0000)T#(0000)T#(0000)b#(0000)B#(0000)T#(0000) #(0000)b#(0000)T#(0000)t#(0000)w#(0000)T#(0000)T#(0000)b#(0000) #(0000)W#(0000)c#(0000)T#(0000)T#(0000)h#(0000)p#(0000)z#(0000)s#(0000)T#(0000) #(0000)D#(0000)T#(0000)s#(0000)p#(0000)c#(0000)t#(0000)B#(0000)h#(0000) #(0000)D#(0000)c#(0000)t#(0000)T#(0000) #(0000)t#(0000)p#(0000) #(0000)X#(0000)c#(0000)l#(0000)b#(0000)z#(0000)T#(0000)T#(0000) #(0000)D#(0000)c#(0000)t#(0000)T#(0000)", "#(0000)T#(0000)x#(0000)B#(0000)T#(0000)T#(0000)d#(0000)T#(0000)d#(0000) #(0000)W#(0000)c#(0000)T#(0000)T#(0000)c#(0000)b#(0000)t#(0000)y#(0000)", "#(0000)S#(0000)c#(0000)X#(0000)T#(0000)t#(0000)y#(0000) #(0000)l#(0000)s#(0000)s#(0000)z#(0000)T#(0000)", "#(0000)", "", "_2", "_3", "_4", "_5", "_6", "_7", "_8", "_9", "_10", "_11"}) in #"Replaced Value1"Seems like too much work to be the right way to do things though, but it looks better!