Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
ATC not working as expected
I have a description field that I am trying to retrieve information from to use in new fields. I thought ATC would work but it keeps returning 0 as the value. Using the below example, I expect ATC(Desc, " ", 4) to return 21 (the position of the 4th occurence of a space). ln_position would have a value of 6. lc_invno would have a value of 123456. Which is what I want.
However, ATC(Desc, " ", 4) is always returning 0, so ln_position always has a value of -15 and in the below example returns 123456 0100. What am I doing wrong? BTW, V# will always be 6 positions, but IV# can be 1 to 10 positions.
TIA for your help! :)
Desc = V# ABC001 IV# 123456 0100
ln_position = (ATC(Desc, " ", 4) - 15)
IF ln_position < 0
lc_invno = ALLTRIM(SUBSTR(Desc, 15, 21))
ELSE
lc_invno = SUBSTR(Desc, 15, ln_position)
ENDIF
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement