sort data seperated by comma

[nehashri]

i want to knw how Search for text within single file in Ms Access, i have my data seperated by commas in the columns.......

how do i query through the file for single word. like for example i want to search a word say "language" in my database(in my database the data in each column is seperated by comma or my data) how do i query the word or how should i store the data so that is is queriable...

to be more clear my data is delimited by commas and i want to search through this. like in Ms Excell's find option is present if we query for a word it searches through whole sheet....through texts or any kind of data that perticular word is searched.... is it also default(same) in acsess. if no how do i do this......

[kartikss]

Hi

If you want to search the word or letter, create a query for particular table and select the field to be displayed in query. Just below the field ie in cirteria write this command - Like "*" & ["Field Name"] & "*"

Eg: Table having 5 field - code, name, add, city, pin

in query select all field if required, if you want to search address then below the address field in criteria -give the command - Like "*" & ["Address"] & *

try this option, it might work.

thanks & bye

Kartik

[pks00]

Hi Nehashri

are you saying each column has text which is split by commas?
Do u want to search all columns or a specific column

when u say a single word, this means it has to satisfy a number of conditions to be a single word, I hope you know what I mean
U have to search for

- the first word - ends with a space or comma or column just contains that word
- middle word - begins with a space or comma and ends with a space or comma or is last word

so lots of conditions, will make your searching a bit slow

[nehashri]

thnx for reply actually i want something like below

table A

codes address
1
2
3
4 GO:0000166, GO:0000775, GO:0000795, GO:0000800, GO:0003677
5
6
7
8 GO:0042802
9
10 GO:0005509, GO:0005856, GO:0007010, GO:0016020, GO:0051016

suppose i hv 2 tables table A and table B. table A is linked to table B by the column 'codes'. i hv the above data all i want is when user gives command for GO:0000795 this word should be searched. the what ever data which is present in table B associated with codes should be displayed here search should result in recognition of 4(in column codes) n linking to table B.....

this search should have criteria search only word in all the colums 'address' in table A recognise perticular code n display information of table B associated with that perticular code.

can usage of ASP as front end be of any use???
plz help
thnx again
neha

[kartikss]

Hi!!!


try this option

In Query select two table ie A & B and select the field as per your requirement.
Go to the field name "Codes" there is option certeria - write this code ' =Like "*" & ["Codes"] & "*" '

it will work

thanks & bye

Kartik