AT Command /

[EBOUGHEY]

I am trying to pull the 2 characters to the left of ".CSV"

Here is the code I have, but it's not working. Please HELP!

Thanks

Elena


REPL ALL KEY with LEFT(ORIGIN,2 at('.CSV',ORIGIN))


Number value changes.... ieSERVICE 37.CSV, SERVICE 21.CSV)

 

[thatguy]

how about something like this:

replace all key with (SUBSTR(ORIGIN,AT('.csv',ORIGIN)-2,2))

or if you know that the filename is always going to be two digits, then just use:

replace all key with (LEFT(ORIGIN,2))

hth
-- frank~

 

[wgcs]

How about:

REPL ALL KEY with RIGHT( forceExt(ORIGIN,''), 2 )

- Bill

Get the best answers to your questions -- See FAQ481-4875.

 

[thatguy]

oh oops.. i guess i skimmed over the fact that the filenames were in the format (SERVICE xx.CSV).. then the LEFT() function wouldn't work too well..

could also use:

replace all key with (RIGHT(JUSTSTEM(ORIGIN),2))

-- frank~

 

[mspratt]

Have you thought about using RAT() instead?

Regards,

Mike

 

[mmerlinn]

Here are two different ways you could do this:

Use RIGHT(LEFT(ORIGIN, AT('.CSV', ORIGIN) - 1), 2)

or the way I would do it:

RIGHT(ATXLEFT(ORIGIN, '.CSV'), 2)

See FAQ182-5975 for the code for the ATXLEFT() UDF.?


mmerlinn

"Political correctness is the BADGE of a COWARD!"

 

[EBOUGHEY]

Thanks soooo much everyone. Most of these worked like a charm!

Elena

 

[SBTBILL]

Remember the AT function returns the location so if you want to be after it you need to add 1, to state the obvious.

Bill Couture

http://www.sbtbill.com