Programming Logic

[Former Member]

Hi,

I have a question which I think is dumb but I was unable to think of any easy way out. I have a string which contains spaces with an uneven count between them for example

wa_test = 'firstname"space"lastname#"space"#"space" #address"space"#'.here space means ''.

and # is the delimiter. The wa_test would be written to an outbound file later. We need the space between the first name and the last name but we do not need any spaces between the hashes or before the # indicator, the key word condense would remove all the spaces which I do not want. Any ideas would be appreciated and rewarded.

Regards

Vick

Message was edited by: vick vennav

[Former Member]

TRANSLATE WA_TEST USING '# '.

CONDENSE WA_TEST. "tHIS WOULD DELETE ONLY EXTRANEOUS SPACES ONLY.

Regards,

Ravi

[Former Member]

Ravi,

I need the # operator or am I not doing it right.

Regards

Vick

[Former Member]

split wa_test at '#' into name dummy1 dummy2 dummy3 address dummy4.

nae would have the required result.

Regards,

Ravi

[Former Member]

Ravi,

Thanks for your time and effort, I was using condense no-gaps instead of just using condense. I know its dumb of me, I will give u full points regardless.

Regards

Vick