Text Contains

jacklcs

Good day everyone

I have the Address Text with ...

Line 1 
Line 2

Now I want to remove the from the Address attribute... how do I do that?

Please help...

tford

REPLACE_PATTERN function.

jacklcs

In User Guide:

"If REPLACE_PATTERN (Account.Name, ‘ohn’, ‘ack’) = ‘Jack Smith’
Then … " -> no more other example..

If REPLACE_PATTERN (Customer.Address) = ' ' then ???

how to tell the system to get ride of ' ' and remain others text?

million thanks...

tford

Try REPLACE_PATTERN (Customer.Address,' ','')

jacklcs

yes. it worked... million thanks.

what is the with the function of REPLACE ? How to use this?

jacklcs

Hi I have a think do not whether it worked.

The Address is a Text Type, so the user entered this:
Line 1 [Enter]
Line 2 [Enter]
Line 3 [Enter]

In order to show on HTML Address attribute with 3 lines, I need to replace the [Enter]. So I created one more Address_HTML attribute to copy the Address to Address_HTML and add if the user press [Enter]
Line 1 
Line 2 
Line 3

I have learned to take out the using the REPLACE_PATTERN function. Is there other way to put back the on the HTML Address?

Thanks...

jacklcs

Ok Cool.. final solved my problem

If Customer.Address IS DEFINED Then
Customer.Address = REPLACE_PATTERN (Customer.Address,' ','')
Customer.Address_HTML=Customer.Address
Customer.Address_HTML=REPLACE_PATTERN (Customer.Address_HTML,'\u000A',' ')

Now, I have a attribute printed on Report without the 
Line 1
Line 2
Line 3

I also have attribute show on HTML Form
Line 1
Line 2
Line 3

Cool... thanks for guidance...