If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Help with string split

Started by nandamuri, 09 May 2023 02:31:58 PM

Previous topic - Next topic

nandamuri

Hello all, I have a prompt that takes a string which will have text separated by |. For example: abcde|ef|ghi|

The string can be any length and can have any |.

I need to extract like this (below) to compare and find any data that matches to the string.

1: abcde
2: abcde|ef
3: abcde|ef|ghi
3: abcde|ef|ghi% (any thing that starts with abcde|ef|ghi)

I am lost and have no clue on how to do this..any help is apprecated. TIA

dougp

sample input and output please

nandamuri

Thank you, Doug..

So, the input comes from the prompt.
The string entered will have text separated by |. For example: abcde|ef|ghi|

The string can be any length and can have any |.

Now I have to check if there are any matches in the database like this -
1: abcde
2: abcde|ef
3: abcde|ef|ghi
3: abcde|ef|ghi% (any thing that starts with abcde|ef|ghi)