I don't know what you're matching the 0685043 with, but
you will probably need the SUBSTRING function, which you
can learn about from Books Online, to extract that from the
rest of the 132 character string.
Generally, if substrings of a column have meaning of their own,
it is better to keep that information in a separate column of the
table.
Steve Kass
Drew University
Daniell wrote:
First thing I am new to write a query. I have two tables that I need
information from. The first table has the user, date and time. The second
table has the user, date, time and a record that contains 132 characters.
What I need to do is match the user, Date and time along with 7 characters
that are placed 7 positions in the record.
This is the begining of the record looks like and I only need the 0685043,
is this possible?
Re: CountIf ... If the cell contents are text you can create a separate column with ... just the first two characters or the last two as numerical values. ... =valueto extract 39 from the same cell.... (microsoft.public.mac.office.excel)
Re: How to use the MID function using the Query Builder in VB.NET ... > I would like to find the Maximun number using the query builder.... > tried using the Substring function but it didnt work, ... > the LEFT and RIGHT functions but didnt work for me. ... The easiest way is to get it to return a large number of characters,... (microsoft.public.dotnet.languages.vb)
Re: Data, Validation ... The characters in the Source box ... are limited but you can refer to a list in a separate column or ...worksheet as Dave said. ... (microsoft.public.excel)
Re: Ignore text but not numerics on SUM() function ... So, in a separate column, type the formula (this example supposed that the ... It will not trap other characters though. ... you simply make the sum of this column. ... (microsoft.public.excel.worksheet.functions)
