Stack Overflow
Stack Overflow

Questions tagged [sequential-number]

50 questions
0
votes
2 answers

An integer 1000 in a column which to be divide by example 100, and then split into multiple rows accordingly

Oracle SQL Example 950/100 The table should able to populate as below 100 100 100 100 100 100 100 100 100 50 Had try CONNECT BY LEVEL , however it seems to be taking too long with huge data stored tables. Any other alternatives way instead of this…
Simplot
  • 13
  • 4
0
votes
1 answer

How to sequentially number data populated by a Userform

I am a real newbie and have been searching on here for help but cannot find what I'm after. I have created a user form that populates data into a target worksheet, I need it to sequentially number each row of data and ensure that every time I…
Niska
  • 1
  • 1
0
votes
0 answers

Firebase Cloud Functions - multiple returns in sequnce

I am new to Firebase cloud functions. I would like to have a function in index.js that trigger when a node in database is created - 1. it will take the params of the context 2. and find a value of a node, 3. get value from another database, 4.…
daniel ng
  • 3
  • 3
0
votes
3 answers

SQL Microsoft Access

I have a table of transactions in Microsoft Access that contains many transactions for many vendors. I need to identify if there is sequential transaction numbering for each vendor. I don't know what the sequence will be or the number of…
Mike
  • 1
0
votes
1 answer

renaming multiple sequential files extension

I have multiple sequential files naming in one directory with multiple incremental files extension. My objective is using rename command to rename just the file…
emilee
  • 25
  • 7
0
votes
1 answer

Rename file based on grand parent and parent directory and sequentially number multiple files

I have a files which are stored in the format C:\Users\xx\test powershell script\studyID\number\filenamedfolder\example.jpg The desired output is: studyID_number_1 #the final digit should be sequentially numbered for each instance of the jpg in…
JisL
  • 161
  • 8
0
votes
1 answer

How to add sequential numbers say 1,2,3 etc. to each file name and also for each line of the file content in a directory?

I want to add sequential number for each file and its contents in a directory. The sequential number should be prefixed with the filename and for each line of its contents should have the same number prefixed. In this manner, the sequential numbers…
fashion123
  • 21
  • 1
  • 4
0
votes
1 answer

SQL to add sequential numbers to rows by date

I'm trying to recreate a table that was made in MS Access. I need to add a column called 'Week' with a sequential number in descending order by date. Example of my…
Drivium
  • 537
  • 6
  • 24
0
votes
2 answers

Filter dataframe for longest sequence of repeated numbers by row in r

I am trying to create a "filter-by" matrix, which I can use to isolate rows of data in my data frame, such that each row contained only the values that correspond to the longest consecutive sequence of the same number, while the rest are kept zero.…
Mary
  • 41
  • 5
0
votes
0 answers

Access custom Increment ("yy" & 0000)

I have just dived into access for the first time. Pretty easy So far. I have created a form for my employees to use to create to job tickets. What I am trying to do now, is to number the tickets in the format 17-0001, 17-0002 etc automatically.…
user540174
  • 1
0
votes
1 answer

Check for sequential numbers in string in Python

I'm using Python 2.7 and wants to find out is there a way to check if a given string contains at least 4 sequential numbers going up or down? The only way I could come up with is to check every character and its 3 following characters to see if they…
itzick binder
  • 524
  • 10
  • 31
0
votes
1 answer

multi-shop orders table and sequential order numbers based on shop

I am looking at building a shop solution that needs to be scalable. Currently it retrieves 1-2000 orders on average per day across multiple country based shops (e.g. uk, us, de, dk, es etc.) but this order could be 10x this amount in two years. I…
user307927
  • 748
  • 9
  • 22
0
votes
4 answers

How do I extract the highest value from a set of sequential numbers within an array?

I'm trying to calculate whether or not a user has a straight in a poker hand using values from an associative array. Each player's hand is inside the same array, the structure of which being similar to this:
jerdiggity
  • 3,655
  • 1
  • 29
  • 41
0
votes
2 answers

How to search through sequentially numbered matrix variables in R

I have a question pertaining to R. I have some sequentially numbered matrices (all of the same dimensions) and I want to search them all and produce a final matrix that contains (for each matrix element) the number of times a defined threshold was…
user3453009
  • 1
0
votes
1 answer

error from Powershell when try to rename with sequential prefix *recursively*

I have no problem adding sequential prefixes to filenames. The following works great on the top directory in question. $path="E:\path\newtest1" $count=4000 Get-ChildItem $path -recurse | Where-Object {!$_.PSIsContainer -and $_.Name -NotMatch…
user3632867
  • 5
  • 2
1 2
3
4