Parsing field data.

[djlerman]

Is there a command in Business Object that is similar to the split command? I am using BO v5.1.8, and the access to the SQL is locked out.

I have a field that has the following data:

XXXXX:XXXXXX:XXXXXX:XXXXX:XXXXX

and I have to print and sort it as seperate columns:

Column1     Column2    Column3    Column4    Column5    
XXXXXXX     XXXXXX     XXXXXX     XXXXXX     XXXXXX

Thanks,
~Donavon

 

[BrianTyler]

Sorry Donavon,

You will have to use a number of Substring statements to gradually work through the string. If the elements are of varying length you will probably have to use POS to find the seperator and calculate the number of characters.

Brian.

 

[djlerman]

2 Questions:

1) How is this Done??
"You will have to use a number of Substring statements to gradually work through the string. If the elements are of varying length you will probably have to use POS to find the seperator and calculate the number of characters.
"

I could find the 1st element and the beginning of the 2nd element but I couldn't figure out a way to find the end of the 2nd element or any of the rest.

There is a ForEach command, so I was thinking that I could employ that but I could not find any examples or documentation beyond a short description.

2) Would the following work and what would be the proper formatting?

=ForEach(Pos(<field>, ":"))