Character after "-" should be Capital letter

pavankatra · Post by **pavankatra** » Mon May 03, 2010 3:36 am

Hi,
my requirement is like

Character after "-" should be Capital letter

Ex:

input:
hi this - is dsxchange forum.
output:
hi this - Is dsxchange forum.
Can anyone please suggest me how to accomplish this.

Thanks In advance.

Thanks

ray.wurlod · Post by **ray.wurlod** » Mon May 03, 2010 4:25 am

Noting that you may need to modify the expression because of the space following the "-" character one solution is

Code: Select all

If Index(InLink.TheString, "-", 1) > 0 Then Field(InLink.TheString, "-", 1, 1) : "-" : UpCase(Left(Field(InLink.TheString, "-", 2, 1))) : Right(Field(InLink.TheString,"-",2,1),Len(Field(InLink.TheString, "-", 2, 1) -1) Else InLink.TheString

You could (should) extract the common subexpression into a stage variable.

pavankatra · Post by **pavankatra** » Mon May 03, 2010 4:35 am

ray.wurlod wrote:Noting that you may need to modify the expression because of the space following the "-" character one solution is
Code: Select all
If Index(InLink.TheString, "-", 1) > 0 Then Field(InLi ...[/quote]

Hi Ray,

Thanks for your reply

 i am not premium user.If you dontmind can you please elaborate that.And one more thing i need to do capital letter after hiphen(-).

Thanks in advace

battaliou · Post by **battaliou** » Mon May 03, 2010 8:40 am

Ha ha ha. Thats excellent.

ray.wurlod · Post by **ray.wurlod** » Mon May 03, 2010 4:47 pm

A simple remedy for your dilemma exists here.

I posted a full answer.