How to split this string?

Help Studio
, ,
2

@Kumar_Sahu_Sameer

looks like you have comma in only one field

so try like this

str.Split({","},3,StringSplitOptions.None)

in this 0 will give first value(1Z9…),1 will give second(1) and 2 will give remaining(Kids girls…,1111111111111)

Now 2 should be split further

str1 = secondpiece.Split(","c).Last - this will give last values - 11111111111

Now use replace str2 = secondpiece.Replace(str1,"").Split({","},StringSplitOptions.None).Last - this will give ashley…com

Now use str3 = secondpiece.Replace(str2,"").Replace(str1,"").Split({","},StringSplitOptions.None).Last - this will give asley marsh

now use
str4 = secondpiece.Replace(str3,"").Replace(str2,"").Replace(str1,"").Split({","},StringSplitOptions.None).Last - this will give USD

finally replace all above remaning is the address you need

address = secondpiece.Replace(str4,"").Replace(str3,"").Replace(str2,"").Replace(str1,"").Trim(",")

Hope this helps

cheers