topic Re: Programming Logic in Application Development and Automation Discussions

Programming Logic

Former Member — Fri, 30 Jun 2006 15:44:19 GMT

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

Re: Programming Logic

Former Member — Fri, 30 Jun 2006 15:47:29 GMT

TRANSLATE WA_TEST USING '# '.

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

Regards,

Ravi

Re: Programming Logic

Former Member — Fri, 30 Jun 2006 15:52:42 GMT

Ravi,

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

Regards

Vick

Re: Programming Logic

Former Member — Fri, 30 Jun 2006 15:55:40 GMT

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

nae would have the required result.

Regards,

Ravi

Re: Programming Logic

Former Member — Fri, 30 Jun 2006 16:33:00 GMT

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