Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to trim all the words?

Status
Not open for further replies.

millbear

Programmer
May 16, 2002
23
SG
Anyone can correct me? (-:

When calling out the job no, the details will be displayed.

for eg : CHEVSINSMZ 100, CHEVSINSMZ 101, CHEVSINSMZ 102
I want to trim them into CHEVSINSMZ 100 & 101 & 102.

jt_hblno is the field name of CHEVSINSMZ 100..

Code as below in VFP version 6.
if k=1
if .not.(empty(jt_hblno))
arr[1,k]= "("+alltrim(str(k))
arr[2,k] = jt_hblno
k = k+1
else
k = k+1
endif
else
:
:
:
Result said:
CHEVSINSMZ 100, CHEVSINSMZ 101, CHEVSINSMZ 102

 
millieniumbear

Who are you answering?

Regards

Griff
Keep [Smile]ing
 
Griff

Call me April.. :)
I'm answering jrajesh..

I will try compiling suggested codes and let u know if it can work or not... [blush]



 
I have modified jrajesh's suggested codes a little into my form.

Jt_hblno is a part of the table (.dbf)in the form. It is like something that contains CHEVSINSMZ 100,CHEVSINSMZ 100, CHEVSINSMZ 101, CHEVSINSMZ 102, so on in the column...

So, I have edit this line as below. ~~
Code:
InputString= "Jt_hblno"

When I tested out the form by calling any job no (in yellow box of JOB NO), all the datas will be displayed. But I have a problem with this part - Click here ~ Result Output.

I purely have no idea how to get the desired result "CHEVSINSMZ 100 & 101 & 102. [ponder]

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top