To replace commas (and other special chars) whith blanks you can use DTW_TRANSLATE.
__________________________________________________________________________________-
Peter Vidal wrote:

Never mind. I found the issue. I was misplacing the factors. It should be:

@DTW_POS(",", CUSNME, COMMA)

Thanks anyway!!!


Peter Vidal PALL Corporation / SR Programmer Analyst, IT Development Group
10540 Ridge Rd., Ste 203, New Port Richey, FL 34654-5111
http://www.pall.com

"Good habits result from resisting temptation."
Ancient Proverb





Peter Vidal
01/19/2006 03:07 PM


       To:     WEB400
cc: Subject: DTW_POS

Hi list!

Why this is not working?

@DTW_POS(CUSNME, ",", COMMA)
Position: $(COMMA) CUSNME is the customer name and what I want to do is to eliminate a possible comma in the field. I want to determine if there is any comma in it. Later on, I want to allow the user to save the data on the browser down to a .CSV file but the comma in the customer name will shift the values of all the other fields.
__________________________________________________
"Truth is not always popular, but it is always right."
Anonymous



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.