Split value in Excel

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

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

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”,**

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

output:
image

1 Like

@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 :slight_smile:

1 Like

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