Sfrgttk

Where to refill my bottle in India?

Calculate Levenshtein distance between two strings in Python

Is a car considered movable or immovable property?

Copycat chess is back

What are the advantages and disadvantages of running one shots compared to campaigns?

Re-submission of rejected manuscript without informing co-authors

Why airport relocation isn't done gradually?

What does 'script /dev/null' do?

How did the USSR manage to innovate in an environment characterized by government censorship and high bureaucracy?

What is the offset in a seaplane's hull?

Deciding between multiple birth names and dates?

What does "enim et" mean?

Finding files for which a command fails

Is domain driven design an anti-SQL pattern?

When blogging recipes, how can I support both readers who want the narrative/journey and ones who want the printer-friendly recipe?

Does it makes sense to buy a new cycle to learn riding?

Could a US political party gain complete control over the government by removing checks & balances?

Can I find out the caloric content of bread by dehydrating it?

What's the difference between repeating elections every few years and repeating a referendum after a few years?

I’m planning on buying a laser printer but concerned about the life cycle of toner in the machine

Piano - What is the notation for a double stop where both notes in the double stop are different lengths?

What do you call something that goes against the spirit of the law, but is legal when interpreting the law to the letter?

How to make payment on the internet without leaving a money trail?

Is "plugging out" electronic devices an American expression?

Find closed sub directory with full text search

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

I have a simple table with registered directory names inside a full text indexed varchar column.

For example:

1. 'c:Dir1'


2. 'c:Dir1Sub1'


3. 'c:Dir1Sub2'


4. 'c:Dir2'


5. 'c:Dir3'

I now need to find the closest subdirectory to file paths like:

'c:Dir1File.txt' -> 'c:Dir1'

'c:Dir1Sub2File.txt' -> 'c:Dir1Sub2'

'c:Dir2Sub1SubSub1File.txt' -> 'c:Dir2'

All my efforts with CONTAINS and NEAR failed.
Can somebody help me how I can solve this with text search?

sql-server t-sql

share

asked 2 mins ago

Steffen MangoldSteffen Mangold

397113

add a comment | 

0

I have a simple table with registered directory names inside a full text indexed varchar column.

For example:

1. 'c:Dir1'


2. 'c:Dir1Sub1'


3. 'c:Dir1Sub2'


4. 'c:Dir2'


5. 'c:Dir3'

I now need to find the closest subdirectory to file paths like:

'c:Dir1File.txt' -> 'c:Dir1'

'c:Dir1Sub2File.txt' -> 'c:Dir1Sub2'

'c:Dir2Sub1SubSub1File.txt' -> 'c:Dir2'

All my efforts with CONTAINS and NEAR failed.
Can somebody help me how I can solve this with text search?

sql-server t-sql

share

asked 2 mins ago

Steffen MangoldSteffen Mangold

397113

add a comment | 

I have a simple table with registered directory names inside a full text indexed varchar column.

For example:

1. 'c:Dir1'


2. 'c:Dir1Sub1'


3. 'c:Dir1Sub2'


4. 'c:Dir2'


5. 'c:Dir3'

I now need to find the closest subdirectory to file paths like:

'c:Dir1File.txt' -> 'c:Dir1'

'c:Dir1Sub2File.txt' -> 'c:Dir1Sub2'

'c:Dir2Sub1SubSub1File.txt' -> 'c:Dir2'

All my efforts with CONTAINS and NEAR failed.
Can somebody help me how I can solve this with text search?

sql-server t-sql

share

asked 2 mins ago

Steffen MangoldSteffen Mangold

397113

share

asked 2 mins ago

Steffen MangoldSteffen Mangold

397113

share

asked 2 mins ago

Steffen MangoldSteffen Mangold

397113

asked 2 mins ago

Steffen MangoldSteffen Mangold

397113

asked 2 mins ago

Steffen MangoldSteffen Mangold

397113