How we can replace any blank or special character with NA in queue transaction item

Help Activities
1

Hi,

I am fetching a text address(line1, line2, line3). While fetching line3 some times we’ll get value and sometimes not. For Example line3 -------- like this.

Address
Line 1-1234 geneva Street
Line2-rich Market
Line 3- 876 street number, TX

Line 1-1897 Anderson Street
Line2-River side Market
Line 3- -------------------

While adding to the queue how we can replace upper example with NA in transaction item.

1 Like
2

variable.replace(“target char”, "want to replace ")

example variable= awest

          variable.replace("a","f")

answer = fwest

3

Hello @mukesh_singh,
From my understanding of your problem,
you could use split activity to divide the address string.

Ex: assign Line3 = Address.Split(Environment.NewLine.ToCharArray)(2)

and then add if statement to check whether — contain or not.

Ex: if statement: Line3.Contian("------") true ==> Line3.Replace("-----","N/A")

or you could use Replace without checking as shown image below=>
image

I hope I could help you,
happy automation :robot: .

1 Like
4

Hey @mukesh_singh

You can just perform string replace.

str_Address.Replace("-------------------","NA")

Hope this helps.

Thanks
#nK

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.