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
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
add a comment |
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
You'll need to use a loop to go through each value inallValData
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
add a comment |
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
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
c# linq integer hex decimal
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 inallValData
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
add a comment |
You'll need to use a loop to go through each value inallValData
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
add a comment |
1 Answer
1
active
oldest
votes
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
add a comment |
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
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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
add a comment |
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
add a comment |
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
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
answered Mar 6 at 20:12
NikolausNikolaus
1,044413
1,044413
add a comment |
add a comment |
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.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
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