Split G from 'Frontline G'

guptasweb · November 2, 2022, 5:16pm

I want to remove the G word from ‘Frontline G’ how to do it?

Tapan_Behera1 · November 2, 2022, 5:19pm

HI @guptasweb do this

Stringvar=" ‘Frontline G’"

Stringvar.replace(“G”,“”).trim

OR

System.Text.RegularExpressions.Regex.Replace(Stringvar,“(?:G)\b”,“”)

guptasweb · November 2, 2022, 5:42pm

it shows me value cannot be null

fernando_zuluaga · November 2, 2022, 8:01pm

Hey

give a try

yourStringVar.Split(" "c)(0)

Gokul001 · November 3, 2022, 5:16am

You can try with both Regex and Split expression

System.Text.RegularExpressions.Regex.Replace("Frontline G","\sG$","").ToString

Split("Frontline G"," G")(0)

Regards
Gokul

Tapan_Behera1 · November 3, 2022, 5:35am

guptasweb · November 3, 2022, 8:57am

How to write it in a excel file

Tapan_Behera1 · November 3, 2022, 8:58am

store this value in a variable and use write cell to write in a particular cell.

Gokul001 · November 3, 2022, 9:04am

You can use Add data row activity after the use write range activity @guptasweb