Split value in Excel

[coder]

Hi All ,

I have like this value in excel

$85.89$85.89 $99.99$99.99

so i need to delete the $ sign and get the first number i mean like this

85.89

this what i create to delete $

row(“Price”).ToString.Replace(“$”,“”).TrimEnd()

and this to get first number

row(1).ToString().Substring(0,5).TrimEnd()

it is possible if i put this two in one line ?
I try but it is not work with me

Thanks

[TheBestBirth (Behzad Navabian)]

@coder

Substring(0,5)

@coder
Hi ,
try this
row(“Price”).ToString.Replace(“$”,“”).TrimEnd().Substring(0,5)

[coder]

Hi @TheBestBirth

Thank you , but i get this error

“message”: “Multiple Assign: Can not assign ‘row("Price").ToString.Replace("$","").TrimEnd().Substring(0,5)’ to ‘Price’.”,
** “level”: “Error”,**

[TheBestBirth (Behzad Navabian)]

@coder,
it would be better if you could share your workflow.
this is how i test it

Log:

output:

[TheBestBirth (Behzad Navabian)]

@coder
U can also use the follwing:
strX.split(" “c)(0).Split(”$"c)(1)

Where StrX is your string.

let me know if this resolves your problem