PDA

View Full Version : Data Parsing Question


Angelie
09-26-2005, 01:59 PM
Can anyone help me with a parsing a String that has both Alpha and Numeric characters. I was looking for a means of removing trailing zeros without having to convert them into a numeric field (since some fields have alpha characters).

CatNum
12345S00
67893R0
32423L0000
3242300000

i'd like to get

CatNum
12345S
67893R
32423L
32423

am using MS Access btw ;)

Thanks!!
Angelie
09-26-2005, 03:38 PM
Tarissa where are jooo!!!
Trevlen
09-26-2005, 03:54 PM
Just take out the 0's :D

Don't ya just hate a smart ass?
Angelie
09-26-2005, 03:56 PM
haha...:D

just need to do it for 19,999 lines more ;)
Angelie
09-26-2005, 04:06 PM
yay thanks...figured it out :D

replace(rtrim(replace(value,'0',' ')),' ', '0')

thanks anyone who read it anyway