Manipulating fields with spaces

[Carl Duff]

I am trying to copy a field in my xlate without success. I am sure I am confusing the list/string commands.

Input field is “BA01BLUE ADVANTAGE”

Output needs to be “BLUE ADVANTAGE”

I can get “BA01” or “BLUE” but not “BLUE ADVANTAGE”

Ideas please?

Many thanks,

Carl

Topic

[Jim Kosloskey]

If you are on a later release of Cloverleaf (6.1.1 for sure and later), there is a STRING Action.

If then you are sure you always want the fifth character to the end if the field, then the Substring function of the String Action with the arguments ‘4 end’ should give you what you want.

If, on the other hand your release does not have the STRING Action then you will need some Tcl.

I have a reusable Tcl xltp type proc which will extract a piece of a field. The proc is argument driven (just like the STRING Action Substring function) and you would provide the same start and end arguments.

If you would like this proc, email me.

If I am not understanding the issue, please clarify.

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Charlie Bursell]

What field?  Did you check maximum field length?

[Carl Duff]

This was the IN1.2 and.3 fields. The vendor concatenates the insurance ID and insurance name together. The field length was adequate but the developer’s knowledge wasn’t.  😀

The ‘string’ action did the trick. Thanks to both for responding.

Carl

[Author]

Replies