Convert multiple hex values to decimal separated by commas2019 Community Moderator ElectionConvert Decimal to Double?How to convert decimal to hex in JavaScript?How do I round a decimal value to 2 decimal places (for output on a page)Convert hex string to int in PythonCreating a comma separated list from IList<string> or IEnumerable<string>C# convert integer to hex and back againHow to convert a byte array to a hex string in Java?Convert floats to ints in Pandas?convert decimal to hex then do hex mathIgnoring Blank Cells when converting from Hex to Decimal in Excel VBA

Gravity magic - How does it work?

Look at your watch and tell me what time is it. vs Look at your watch and tell me what time it is

If curse and magic is two sides of the same coin, why the former is forbidden?

What has been your most complicated TikZ drawing?

Can I use USB data pins as power source

Python if-else code style for reduced code for rounding floats

It's a yearly task, alright

Bach's Toccata and Fugue in D minor breaks the "no parallel octaves" rule?

How to deal with a cynical class?

A sequence that has integer values for prime indexes only:

Brexit - No Deal Rejection

Who is flying the vertibirds?

Life insurance that covers only simultaneous/dual deaths

How to make healing in an exploration game interesting

Knife as defense against stray dogs

How to explain that I do not want to visit a country due to personal safety concern?

What did Alexander Pope mean by "Expletives their feeble Aid do join"?

Is it true that good novels will automatically sell themselves on Amazon (and so on) and there is no need for one to waste time promoting?

What's the meaning of “spike” in the context of “adrenaline spike”?

How difficult is it to simply disable/disengage the MCAS on Boeing 737 Max 8 & 9 Aircraft?

Why doesn't using two cd commands in bash script execute the second command?

If the DM rolls initiative once for a group of monsters, how do end-of-turn effects work?

My adviser wants to be the first author

How to create the Curved texte?



Convert multiple hex values to decimal separated by commas



2019 Community Moderator ElectionConvert Decimal to Double?How to convert decimal to hex in JavaScript?How do I round a decimal value to 2 decimal places (for output on a page)Convert hex string to int in PythonCreating a comma separated list from IList<string> or IEnumerable<string>C# convert integer to hex and back againHow to convert a byte array to a hex string in Java?Convert floats to ints in Pandas?convert decimal to hex then do hex mathIgnoring Blank Cells when converting from Hex to Decimal in Excel VBA










0















I am doing an analysis of a csv file that has multiple columns and rows.



I am pulling specific data from the csv file and importing the data into
a datagridview. I would like to pull data from a column with multiple hex values (separated by commas) on each row and convert all the values from hex to integers and place them into the datagridview. The problem I am having is I don't know how to convert all the values from hex to integer and place them in datagridview. I am only able to convert the first Value and place that single value into the datagridview. ex (500)



If I do not convert any values I am able to place all the values from a column's row into the datagridview. ex (1F4,96,3D4,14A)



// converting the first value on each row and placing to datagridview
rawData = line.Split('"')[5];
firstValData = rawData.Split(',').First();
int datatoHex = Convert.ToInt32(firstValData, 16);
allRow["Data"] = datatoHex;

Construct.MainDataTable.Rows.Add(allRow);
dataGridView1.DataSource = Construct.MainDataTable;

//I attempted to do this but doesnt work
rawData = line.Split('"')[5];
allValData = rawData.Split(',').All();
int datatoHex = Convert.ToInt32(allValData, 16);
allRow["Data"] = datatoHex;

Construct.MainDataTable.Rows.Add(allRow);
dataGridView1.DataSource = Construct.MainDataTable;









share|improve this question
























  • You'll need to use a loop to go through each value in allValData and add each as a new row in your table.

    – Heretic Monkey
    Mar 6 at 20:04











  • Use following : int number = int.Parse("1F4", System.Globalization.NumberStyles.HexNumber); For multiple numbers : int[] numbers = "1F4,96,3D4,14A".Split(new char[] ',' ).Select(x => int.Parse(x, System.Globalization.NumberStyles.HexNumber)).ToArray();

    – jdweng
    Mar 6 at 20:23
















0















I am doing an analysis of a csv file that has multiple columns and rows.



I am pulling specific data from the csv file and importing the data into
a datagridview. I would like to pull data from a column with multiple hex values (separated by commas) on each row and convert all the values from hex to integers and place them into the datagridview. The problem I am having is I don't know how to convert all the values from hex to integer and place them in datagridview. I am only able to convert the first Value and place that single value into the datagridview. ex (500)



If I do not convert any values I am able to place all the values from a column's row into the datagridview. ex (1F4,96,3D4,14A)



// converting the first value on each row and placing to datagridview
rawData = line.Split('"')[5];
firstValData = rawData.Split(',').First();
int datatoHex = Convert.ToInt32(firstValData, 16);
allRow["Data"] = datatoHex;

Construct.MainDataTable.Rows.Add(allRow);
dataGridView1.DataSource = Construct.MainDataTable;

//I attempted to do this but doesnt work
rawData = line.Split('"')[5];
allValData = rawData.Split(',').All();
int datatoHex = Convert.ToInt32(allValData, 16);
allRow["Data"] = datatoHex;

Construct.MainDataTable.Rows.Add(allRow);
dataGridView1.DataSource = Construct.MainDataTable;









share|improve this question
























  • You'll need to use a loop to go through each value in allValData and add each as a new row in your table.

    – Heretic Monkey
    Mar 6 at 20:04











  • Use following : int number = int.Parse("1F4", System.Globalization.NumberStyles.HexNumber); For multiple numbers : int[] numbers = "1F4,96,3D4,14A".Split(new char[] ',' ).Select(x => int.Parse(x, System.Globalization.NumberStyles.HexNumber)).ToArray();

    – jdweng
    Mar 6 at 20:23














0












0








0








I am doing an analysis of a csv file that has multiple columns and rows.



I am pulling specific data from the csv file and importing the data into
a datagridview. I would like to pull data from a column with multiple hex values (separated by commas) on each row and convert all the values from hex to integers and place them into the datagridview. The problem I am having is I don't know how to convert all the values from hex to integer and place them in datagridview. I am only able to convert the first Value and place that single value into the datagridview. ex (500)



If I do not convert any values I am able to place all the values from a column's row into the datagridview. ex (1F4,96,3D4,14A)



// converting the first value on each row and placing to datagridview
rawData = line.Split('"')[5];
firstValData = rawData.Split(',').First();
int datatoHex = Convert.ToInt32(firstValData, 16);
allRow["Data"] = datatoHex;

Construct.MainDataTable.Rows.Add(allRow);
dataGridView1.DataSource = Construct.MainDataTable;

//I attempted to do this but doesnt work
rawData = line.Split('"')[5];
allValData = rawData.Split(',').All();
int datatoHex = Convert.ToInt32(allValData, 16);
allRow["Data"] = datatoHex;

Construct.MainDataTable.Rows.Add(allRow);
dataGridView1.DataSource = Construct.MainDataTable;









share|improve this question
















I am doing an analysis of a csv file that has multiple columns and rows.



I am pulling specific data from the csv file and importing the data into
a datagridview. I would like to pull data from a column with multiple hex values (separated by commas) on each row and convert all the values from hex to integers and place them into the datagridview. The problem I am having is I don't know how to convert all the values from hex to integer and place them in datagridview. I am only able to convert the first Value and place that single value into the datagridview. ex (500)



If I do not convert any values I am able to place all the values from a column's row into the datagridview. ex (1F4,96,3D4,14A)



// converting the first value on each row and placing to datagridview
rawData = line.Split('"')[5];
firstValData = rawData.Split(',').First();
int datatoHex = Convert.ToInt32(firstValData, 16);
allRow["Data"] = datatoHex;

Construct.MainDataTable.Rows.Add(allRow);
dataGridView1.DataSource = Construct.MainDataTable;

//I attempted to do this but doesnt work
rawData = line.Split('"')[5];
allValData = rawData.Split(',').All();
int datatoHex = Convert.ToInt32(allValData, 16);
allRow["Data"] = datatoHex;

Construct.MainDataTable.Rows.Add(allRow);
dataGridView1.DataSource = Construct.MainDataTable;






c# linq integer hex decimal






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Mar 6 at 20:05









marc_s

581k13011221268




581k13011221268










asked Mar 6 at 20:00









Olujide OluadeOlujide Oluade

103




103












  • You'll need to use a loop to go through each value in allValData and add each as a new row in your table.

    – Heretic Monkey
    Mar 6 at 20:04











  • Use following : int number = int.Parse("1F4", System.Globalization.NumberStyles.HexNumber); For multiple numbers : int[] numbers = "1F4,96,3D4,14A".Split(new char[] ',' ).Select(x => int.Parse(x, System.Globalization.NumberStyles.HexNumber)).ToArray();

    – jdweng
    Mar 6 at 20:23


















  • You'll need to use a loop to go through each value in allValData and add each as a new row in your table.

    – Heretic Monkey
    Mar 6 at 20:04











  • Use following : int number = int.Parse("1F4", System.Globalization.NumberStyles.HexNumber); For multiple numbers : int[] numbers = "1F4,96,3D4,14A".Split(new char[] ',' ).Select(x => int.Parse(x, System.Globalization.NumberStyles.HexNumber)).ToArray();

    – jdweng
    Mar 6 at 20:23

















You'll need to use a loop to go through each value in allValData and add each as a new row in your table.

– Heretic Monkey
Mar 6 at 20:04





You'll need to use a loop to go through each value in allValData and add each as a new row in your table.

– Heretic Monkey
Mar 6 at 20:04













Use following : int number = int.Parse("1F4", System.Globalization.NumberStyles.HexNumber); For multiple numbers : int[] numbers = "1F4,96,3D4,14A".Split(new char[] ',' ).Select(x => int.Parse(x, System.Globalization.NumberStyles.HexNumber)).ToArray();

– jdweng
Mar 6 at 20:23






Use following : int number = int.Parse("1F4", System.Globalization.NumberStyles.HexNumber); For multiple numbers : int[] numbers = "1F4,96,3D4,14A".Split(new char[] ',' ).Select(x => int.Parse(x, System.Globalization.NumberStyles.HexNumber)).ToArray();

– jdweng
Mar 6 at 20:23













1 Answer
1






active

oldest

votes


















0














Try something like this:



rawData = line.Split('"')[5];
var valDatas = rawData.Split(',').Select(s=> Convert.ToInt32(s, 16));

foreach(int val in valDatas)

//whatever you want to do






share|improve this answer






















    Your Answer






    StackExchange.ifUsing("editor", function ()
    StackExchange.using("externalEditor", function ()
    StackExchange.using("snippets", function ()
    StackExchange.snippets.init();
    );
    );
    , "code-snippets");

    StackExchange.ready(function()
    var channelOptions =
    tags: "".split(" "),
    id: "1"
    ;
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function()
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled)
    StackExchange.using("snippets", function()
    createEditor();
    );

    else
    createEditor();

    );

    function createEditor()
    StackExchange.prepareEditor(
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader:
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    ,
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    );



    );













    draft saved

    draft discarded


















    StackExchange.ready(
    function ()
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55031284%2fconvert-multiple-hex-values-to-decimal-separated-by-commas%23new-answer', 'question_page');

    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    Try something like this:



    rawData = line.Split('"')[5];
    var valDatas = rawData.Split(',').Select(s=> Convert.ToInt32(s, 16));

    foreach(int val in valDatas)

    //whatever you want to do






    share|improve this answer



























      0














      Try something like this:



      rawData = line.Split('"')[5];
      var valDatas = rawData.Split(',').Select(s=> Convert.ToInt32(s, 16));

      foreach(int val in valDatas)

      //whatever you want to do






      share|improve this answer

























        0












        0








        0







        Try something like this:



        rawData = line.Split('"')[5];
        var valDatas = rawData.Split(',').Select(s=> Convert.ToInt32(s, 16));

        foreach(int val in valDatas)

        //whatever you want to do






        share|improve this answer













        Try something like this:



        rawData = line.Split('"')[5];
        var valDatas = rawData.Split(',').Select(s=> Convert.ToInt32(s, 16));

        foreach(int val in valDatas)

        //whatever you want to do







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Mar 6 at 20:12









        NikolausNikolaus

        1,044413




        1,044413





























            draft saved

            draft discarded
















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid


            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.

            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55031284%2fconvert-multiple-hex-values-to-decimal-separated-by-commas%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Save data to MySQL database using ExtJS and PHP [closed]2019 Community Moderator ElectionHow can I prevent SQL injection in PHP?Which MySQL data type to use for storing boolean valuesPHP: Delete an element from an arrayHow do I connect to a MySQL Database in Python?Should I use the datetime or timestamp data type in MySQL?How to get a list of MySQL user accountsHow Do You Parse and Process HTML/XML in PHP?Reference — What does this symbol mean in PHP?How does PHP 'foreach' actually work?Why shouldn't I use mysql_* functions in PHP?

            Compiling GNU Global with universal-ctags support Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Data science time! April 2019 and salary with experience The Ask Question Wizard is Live!Tags for Emacs: Relationship between etags, ebrowse, cscope, GNU Global and exuberant ctagsVim and Ctags tips and trickscscope or ctags why choose one over the other?scons and ctagsctags cannot open option file “.ctags”Adding tag scopes in universal-ctagsShould I use Universal-ctags?Universal ctags on WindowsHow do I install GNU Global with universal ctags support using Homebrew?Universal ctags with emacsHow to highlight ctags generated by Universal Ctags in Vim?

            Add ONERROR event to image from jsp tldHow to add an image to a JPanel?Saving image from PHP URLHTML img scalingCheck if an image is loaded (no errors) with jQueryHow to force an <img> to take up width, even if the image is not loadedHow do I populate hidden form field with a value set in Spring ControllerStyling Raw elements Generated from JSP tagds with Jquery MobileLimit resizing of images with explicitly set width and height attributeserror TLD use in a jsp fileJsp tld files cannot be resolved