Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a field Infection which has the data like this
RESP VIRAL PRF, PCR ***INACT 02/23/16 REFER TO RPPPR
i have to remove the *** from this ,
And also need to suppress blank values how do i achieve this ?
Iam trying with this below code
PurgeChar( Infection , '*') and If(Len(Trim(Infection )) > 0, Infection ) asInfection
May be try this:
If(Len(Trim(PurgeChar(Infection, '*'))) > 0, PurgeChar(Infection, '*')) as Infection
Try,
If(Len(Trim(Infection )) > 0, PurgeChar(Infection , '*') ) asInfection
HI Sunny ,
How do i give the space , i used the above expression it works perfectly , but when i removed *** there has to be space between
Try this:
If(Len(Trim(Replace(Infection, '***', ' '))) > 0, Replace(Infection, '***', ' ')) as Infection
Its not giving the space
It should replace *** with a space
Replace(Infection, '***', ' ')
Is that not working for you?
Check out the sample:
Use Replace function:
Replace(Infection, '*', '')
As Sunny suggested it should work with the replace function
Replace(Infection, '***', ' ')
here in the third parameter try to give as much space you want like a tab space you will observe the space getting generated