PAD remove empty space in text value

[Zy_Sin]

Hi

I notice there are empty space in the data that i script
but i am unable to use is blank or is empty operator

how do i write my Else If? The Text value might not necessary contain 2 empty spacing...

Thanks

[UshaJyothi20 · Accepted solution]

Hi @Zy_Sin 

Have you tried with the replace text activity

replace empty space with null

Please follow this..

if the spaces are before or after the text then you can use Trim text also

Feel free to connect if you have any concerns.

Hope this helps,

Usha Jyothi

[Zy_Sin]

Thanks @UshaJyothi20 

Totally forgotten can use Trimmed.

[VishnuReddy1997]

Hi @Zy_Sin ,

May be your Vbscript Output contains some void Spaces,so just trim the spaces as shown in below image.

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards

Vishnu Reddy