Define a range, return all numbers of range that are NOT in csv data

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

Define a range, return all numbers of range that are NOT in csv data

KiNeMs
Programmer named Tim

Posts: 12

Threads: 2

Joined: Dec 2019

Reputation: 0

Dec-31-2019, 02:12 AM (This post was last modified: Dec-31-2019, 02:12 AM by KiNeMs.)

Hi There,

I have a CSV file that contains the following data

"LineURI";"Type";"Number";"Extension"
"tel:+61383997000;ext=97000";"csuser";"+61383997000";"97000"
"tel:+61383997001;ext=97001";"csuser";"+61383997001";"97001"
"tel:+61383997003;ext=97003";"csuser";"+61383997003";"97003"
"tel:+61383997004;ext=97004";"csuser";"+61383997004";"97004"
"tel:+61383997099;ext=97099";"csmeetingroom";"+61383997099";"97099"

I would like to query the "Number" field in the CSV data via a range
(+61383997000,+61383997099)
and return all numbers within the range that are not included in the Number field in csv file.

Find

Messages In This Thread

Define a range, return all numbers of range that are NOT in csv data - by KiNeMs - Dec-31-2019, 02:12 AM

RE: Define a range, return all numbers of range that are NOT in csv data - by ichabod801 - Dec-31-2019, 02:51 AM

RE: Define a range, return all numbers of range that are NOT in csv data - by KiNeMs - Dec-31-2019, 03:10 AM

RE: Define a range, return all numbers of range that are NOT in csv data - by ichabod801 - Dec-31-2019, 03:18 AM

RE: Define a range, return all numbers of range that are NOT in csv data - by KiNeMs - Jan-02-2020, 01:28 AM

RE: Define a range, return all numbers of range that are NOT in csv data - by ichabod801 - Jan-02-2020, 01:44 AM

RE: Define a range, return all numbers of range that are NOT in csv data - by KiNeMs - Jan-02-2020, 02:13 AM

RE: Define a range, return all numbers of range that are NOT in csv data - by ichabod801 - Jan-02-2020, 03:02 AM

RE: Define a range, return all numbers of range that are NOT in csv data - by KiNeMs - Jan-02-2020, 10:08 PM

RE: Define a range, return all numbers of range that are NOT in csv data - by ichabod801 - Jan-02-2020, 10:16 PM

RE: Define a range, return all numbers of range that are NOT in csv data - by KiNeMs - Jan-02-2020, 11:20 PM

RE: Define a range, return all numbers of range that are NOT in csv data - by ichabod801 - Jan-02-2020, 11:41 PM

RE: Define a range, return all numbers of range that are NOT in csv data - by KiNeMs - Jan-06-2020, 02:15 AM

RE: Define a range, return all numbers of range that are NOT in csv data - by ichabod801 - Jan-06-2020, 02:32 AM

RE: Define a range, return all numbers of range that are NOT in csv data - by KiNeMs - Jan-06-2020, 02:59 AM

RE: Define a range, return all numbers of range that are NOT in csv data - by ichabod801 - Jan-06-2020, 03:09 AM

RE: Define a range, return all numbers of range that are NOT in csv data - by KiNeMs - Jan-06-2020, 03:24 AM

RE: Define a range, return all numbers of range that are NOT in csv data - by KiNeMs - Jan-06-2020, 05:56 AM

RE: Define a range, return all numbers of range that are NOT in csv data - by KiNeMs - Jan-24-2020, 06:19 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	How do I calculate a ratio from 2 numbers and return an equivalent list of about 1000	Pleiades	8	15,887	Jan-05-2024, 08:30 PM Last Post: sgrey
	[SOLVED] [loop] Exclude ranges in… range?	Winfried	2	1,590	May-14-2023, 04:29 PM Last Post: Winfried
	I hate "List index out of range"	Melen	20	3,548	May-14-2023, 06:43 AM Last Post: deanhystad
	How to check multiple columns value within range	SamLiu	2	1,241	Mar-13-2023, 09:32 AM Last Post: SamLiu
	Expand the range of a NumPy array?	PythonNPC	0	794	Jan-31-2023, 02:41 AM Last Post: PythonNPC
	Copying files if the name is in range	tester_V	9	1,678	Nov-24-2022, 12:21 AM Last Post: tester_V
	IndexError: Replacement index 2 out of range for positional args tuple - help?	MrKnd94	2	6,715	Oct-14-2022, 09:57 PM Last Post: MrKnd94
	Solving an equation by brute force within a range	alexfrol86	3	2,901	Aug-09-2022, 09:44 AM Last Post: Gribouillis
	IndexError: list index out of range	dolac	4	1,994	Jul-25-2022, 03:42 PM Last Post: deanhystad
	I'm getting a String index out of range error	debian77	7	2,422	Jun-26-2022, 09:50 AM Last Post: deanhystad

Users browsing this thread: 1 Guest(s)

View a Printable Version

Define a range, return all numbers of range that are NOT in csv data

User Panel Messages

Announcements