Databases
StackOverflow2013
Postsdbo
POArrays and measurement unit conversion
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POArrays and measurement unit conversion
    primarykey
    data
    text
    <pre><code>using (read = new StreamReader("C:/Users/Sam Smith/Desktop/convert.txt")) { while (!read.EndOfStream) { lineFromFile = read.ReadLine(); units = lineFromFile.Split(','); if (units.Contains(splitEntry[0]) &amp;&amp; units.Contains(splitEntry[1])) { firstUnit = units[0]; secondUnit = units[1]; userConvertValue = Convert.ToDouble(splitEntry[2]); fileConvertValue = Convert.ToDouble(units[2]); result = fileConvertValue * userConvertValue; } if (units.Contains(splitEntry[0]) &amp;&amp; units.Contains(splitEntry[1])) { firstUnit = units[1]; secondUnit = units[0]; userConvertValue = Convert.ToDouble(splitEntry[2]); fileConvertValue = Convert.ToDouble(units[2]); result = userConvertValue / fileConvertValue; } if (!units.Contains(splitEntry[0]) || !units.Contains(splitEntry[1])) { Console.WriteLine("Error, measurement unit not recognised."); } </code></pre> <p>Above I have a text file that contains types of unit measurement (pounds, ounces, miles and such), the text from this file is split into a string array. The user enters two measurement units in the following format to convert to two units: unit,unit,amount In the text file, the conversion amount for two units is every third split string, like so: unit,unit,2.80 unit,unit,1.27 (etc)</p> <p>Is there a way of grouping each set of units and their conversion amounts? For example, if the user tries to convert two particular units, the program knows which conversion value to use when calculating the final result. Might be a little vague, but it's difficult to explain. EDIT: The user does not interact with the file, the program simply pulls the data from the file, which is then split into strings (',') and stored in an array.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBoggy B
    1. USBoggy B
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POArrays and measurement unit conversion
      1. This table or related slice is empty.
      1. VTDownMod
    1. CO-1: Unfortunately it's very vague, it doesn't help that there is a "text file", and "the user enters" things. Does the user enter things in to the text file? Can you provide a sample of the text file, why the user entered those values, and then tell us what the program is supposed to do with the data.
      singulars
      1. POArrays and measurement unit conversion
      1. USBinary Worrier
    2. COWhat is the purpose of the splitEntry array? I assume it's declared outside of this snippet.
      singulars
      1. POArrays and measurement unit conversion
      1. USJames Orr
    3. COThe purpose of 'splitEntry' is to split the user's input into an array. The values of that array are then checked against the values of the 'units' array, using .contains()
      singulars
      1. POArrays and measurement unit conversion
      1. USBoggy B
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload