Databases
StackOverflow2013
Usersdbo
USMuleHeadJoe
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USMuleHeadJoe
    primarykey
    data
    text
    plurals
    1. POHow can I determine if an element exists in an array (perl)
      singulars
      1. PTQuestion
    1. POHow can I determine if an element exists in an array (perl)
      singulars
      1. PTQuestion
    2. PONeed to convert data as string into an Excel readable format
      singulars
      1. PTQuestion
    3. POhow can I convert a text timestamp to something Excel can manipulate? (Excel)
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. CO@TLP ... case is unimportant. And I don't think the source of the datasets is too important either since all data is reduced to arrays and elements (scalar vars). I have the element in hand, it is $term. I want to find IF $term exists in Array2. I don't need to pull anything out of Array2, this is an existence check only. If $term exists in Array2, then I have to do some work on the line that $term came out of (i.e., the original element form Array1). That also is already done, and not in question.
      singulars
      1. PO
      1. USMuleHeadJoe
    2. COI don't think this example will work as is, and I don't understand it well enough to see how it could be modified to suit. Array1 is the contents of a file, with each element of the array being an entire line from the file -- a row of data comprised of multiple elements. I have to chop that up to get the individual elements that I need to test against array2 which is a simpler array comprised of a plain list of single words. I can't compare an entire line from array1 against the single words in array2, that won't work.
      singulars
      1. PO
      1. USMuleHeadJoe
    3. COIs there a reason your example uses "for" and not "foreach"? Is it personal preference or is there a technical reason? In my script I use "foreach $line(@array1)" ... my array1 is a text file that I'm reading in (@array1=\`cat myfile\`;), chopping up each line so I can reorder elements and eventually output everything as a csv file that I can open & manipulate in Excel.
      singulars
      1. PO
      1. USMuleHeadJoe
 

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