Parsing data

[Anonymous]

Hi

I have list box values like pod1,pod2,\\pod1,\\pod2,pod3 and so on ,

i do not want \\ to be displayed , how do i remove them from the value and display the list box values just as pod1,pod2,pod3

Do i have to do this in the load script or in the list box properties?

Basically i want to treat \\pod1 = pod1.

Please Help....

[Anonymous]

Try using the Replace function in your script.

JS

[wizardo · Accepted solution]

put this in the listbox expression:

PurgeChar( field_with_pod_values , '\\' )

you should consider that selecting POD1 will select associated records both of "POD1" and of "\\POD1"

Mansyno

[Anonymous]

Thank you , and also i have some value like pod1 and POD1 how do i consider both as one,

is there a function which considers both lower case and upper case as single value ?

[wizardo]

hmm well

you can use the upper() and lower() functions to achieve that (look at the inside help)

but if you dont need to keep the original values you might want to consider moving the treatment of these values to the script and maybe you use a mapping table to force all values to be the same

Mansyno