RE: Parsing problem
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
SELECT Temp.INVS, Right$([INVS],Len([INVS])-InStr([INVS],"-")) AS WOSUF,
Left$([INVS],InStr(1,[INVS],"-")-1) AS WOPRE
FROM Temp;
"Bre-x" wrote:
> hi,
>
> I have this query that I am using to parse this data 12345-1 into 12356 and
> 1
>
> SELECT INVS, Right$([INVS],Len([INVS])-InStr(1,[INVS],'-')-1) AS WOSUF,
> Left$([INVS],InStr(1,[INVS],"-")-1) AS WOPRE
> FROM Temp;
>
> I get the 12345 but not the "1"
>
> There is something wrong with the formula, but I cannot figure it out.
>
> Regards,
>
> Bre-x
>
>
>
>
>
.
Relevant Pages
- Re: Efficient way to parse large files
... > go from 250 megs and parse it down to about 10 megs of relevant data. ... "parse temp for what I need" ... FileOut = FreeFile ... (Where ParsedText is a function that accepts the input lines and returns ...
(microsoft.public.vb.general.discussion) - Re: Storing input into a character array
... you're not protecting your buffer against ... fields you want to parse). ... you're using &temp rather than temp - ... use fgets rather than fscanf. ...
(comp.lang.c) - Re: Need help creating temporary table from filter
... more sense than either 1) repeatedly creating/deleting a temp table, ... need to do that when you substitute a SELECT query? ... the same way as you were using tblTemp*. ... I'm currently reading up on For Each/Next loops to parse through the ...
(microsoft.public.access.formscoding) - Re: Question about "define" and "malloc"
... Together my complier will say "parse error". ... int main{ ... I think the error is you define the point "temp" after some ...
(comp.lang.c) - Re: Sybase error -5702 and -1
... It seems that insert query on temp tables by procedure is causing ... Prev by Date: ...
(comp.databases.sybase) |
|
