Parse string to remove anything enclosed in braces

[skurkal]

Hi All,

I am looking for a formula that will parse a string to remove anything in braces.

eg.

Old Column = Jane Adams (gauurk), John Doe (xgdhug), Will Ray (sygtre)
New Column = Jane Adams, John Doe, Will Ray

Any help will be appreciated.

Thanks!

 

[tlbrown88]

Checkout this thread....I've used it before and it works perfectly

http://www.forumtopics.com/busobj/viewtopic.php?p=615604

 

[pmax9999]

Try this formula:

WhilePrintingRecords;
Local NumberVar c := Ubound(Split({Table.Your_Field}, ', '));
Local NumberVar i;
Local StringVar X;

For i := 1 to c do
X := X + Split(Split({Table.Your_Field}, ', ')[i], '(') [1] + ', ' ;

X := Replace(X, ' , ', ', ');

X := Left(X, Len(X)-2)

Cheers
Pete