Search results

Hi Spikepl, Can I let us know how to write this query. Regards, Hari

Hi All, I have a table that contians more than 70,000 rows, where I want to export the table as two different excel files. 1. One excel file data from 1 to 65000 rows 2. Second excel file from 65000 to end of table. Can any one help in this regard. Regards, HARI

Hi, Can I use InStr(1,[YourFiledName],"Ltd",0)<>"0" Or InStr(1,[YourFiledName],"LTd",0)<>"0" Or InStr(1,[YourFiledName],"LTD",0)<>"0" Or InStr(1,[YourFiledName],"lTD",0)<>"0" in one expr1.

Hi vbaInet, how can I search multiple text strings in one expr1.

Many More thanks

Hi All, I need to search case sensitive text in a filed I need to find out the data with “Ltd” only from below data ABL BIO-TECHNOLOGIES LTD ABL BIO-TECHNOLOGIES LtD ABL BIO-TECHNOLOGIES ltd ABL BIO-TECHNOLOGIES lTD ABL BIO-TECHNOLOGIES Ltd I am useing below query but it giving all the...

the sample data provided as tested data with two ways.. from name to abb and abb to name. if the filed4 contians any abb those abbreviations are need to modify with new name, if no abbreviations are found, keep the old data. I think no inconsistency my data.

ID | Field4 | Required ---------------------------------------------- 1 ICI Bank,ADR, pfd ICI Bank,American Dep Rep, Preferred Stock 2 Man Bank, pfd Man Bank, Preferred Stock 3 Yes Bank...

It is giving the only abbvaitons not total data It should return along with the data in Field4

I changed the code as suggested same problems repeats Find sample attached

it is in Standard Module Only, Module4 is used this function

it is stopping the query and returns as Runtime error 5 Invalied Procedure or Argument Hari

it's around 20-30

Hi, as per my understanding if the Filed4 contains only ADR it replace to ADR I hope we have a little bit of miscommunication about understanding. in my ADR table Filed4 not only contians ADR, it contians along with other Text Also Adr ID | Field4 | Required...

yes.. I did the same thing as below. Created table with three coumns table name Abb ID. PK FieldName -American Dep Receipt FieldAbb -ADR My main table contians five columns as ADR ID. PK Filed1 Field2 Field3 Field4 - Contians Name Created new query Added two tables Inner JOIN with ID...

Hi, Filed1 is text string, it contains text with comma seperator Example Field1 ICICI Bank, ADR, pfd as in next filed Expr1:Replace(Filed1,"ADR","American Deposistory Receipt") Expr1:Replace(Field1,"pfd","Preferred Stocks") Regards, Hari

Hi, I am useing a query with Replace Function, one field contians data and another filed contians (Expr1:Replace(Field1,"string","replace string")), so I want to repeat this function for different words that contian in Filed1 in each row of data, all the replace values placed at Expr1. Hope...

Good Morning All, I have small requirement with Replace function, as per my understanding Replace function is used to replace a text in a filed. My requirement is if one filed contians more than 10 words to replace at once, how to repeat the sam function for that filed to give output in...

Hi, Now it's coming perfect, many more thanks for your help. Thanks you for valuable support. Regards, Hari

Hi, It my mistake to add comma between "Birmingham-Southern Hold, 5.35%" after placing comma it's returns only as final output as in name field as "d," it is not giving data as "Birmingham-Southern Hold" Can you check once.. Regards, Hari