removed the single alphabet from the string

[alis2063]

Hi Guys,

How are you?

i want to get rid of single alphabet from the string

exp

NH JU Y OK

TH JU S OK

i have two strings as above so i am expecting the result as below can you please help me out.

NH JU  OK

TH JU  OK

if you all  have observed that i have removed  the single alphabet from given strings.

[alis2063]

Hi Susovan,

Can you please solutions for the same it just attachment .

[alis2063]

@Robertmika

Hi Mark,

I have implemented the same as above ,its working  as i wanted but when i used it through OLEDB CONNECTION then it is throwing error 

1)Microsoft OLE DB Provider for SQL Server, ErrorMsg: 'RecNo' is not a recognized built-in function name

2)Microsoft OLE DB Provider for SQL Server, ErrorMsg: 'SubFeild' is not a recognized built-in function name

Can you please suggest me  as i need to implement that on OLEBD Connection.

[swuehl]

Use a preceding LOAD statement to be able to use QV functions (which are not known to the DBMS driver):

Preceding Load

[danansell42]

If its just for presentation purposes on the front end then you could just create a calculated dimension within charts/tables etc.

Obviously this is also dependant on the format being the same in every instance

For example:

=left(Field,6)&right(Field,2)

[alis2063]

@STEFABWUHI

@ALIS2063

Hi Stefab,

Thanks for your quick respond.

finally got solution .

Regards,

Ali