Split price column

Hi every body

I need help , i have this columns in excel i need to write only the first number after $ and before the second $ i try a lot to do that and i didn’t get to solve .

can any one help me please

Thank you

$55.99$55.99
$33.81$33.81
$41.82$41.82
$39.99$39.99 $49.14$49.14
$36.99$36.99
$39.99$39.99
$79.95$79.95
$22.99$22.99
$30.99$30.99
$40.17$40.17 $49.99$49.99
$27.99$27.99
$39.99$39.99 $49.99$49.99
$42.99$42.99
$59.99$59.99
$39.00$39.00 $49.00$49.00
$24.06$24.06
$27.65$27.65 $32.39$32.39
$41.99$41.99
$33.55$33.55 $39.99$39.99
$60.99$60.99
$34.99$34.99
$34.99$34.99
$46.99$46.99 $49.99$49.99

Input=“$39.99$39.99 $49.14$49.14”
Output=Input.substring(0,11)
$39.99$39.99

1 Like

Thank you for you help but where i can write this ?

Where your using logic excel?

i use for each row

Please share your code or screen shot

Main.xaml (11.6 KB) Untitled.xls (13.9 KB)

1 Like

Hi @coder,

Please find the solution.If you have any issues.Let me know.

@I made some changes in your code.

Main1.xaml (14.0 KB)

Result file

Regards,
Omkar P

1 Like

Thank you for you Reddy_Paluri

i will see that now

Thank you very much, it works like I want :heart_eyes: :tulip:

1 Like

Welcome @coder :smiley:

1 Like

@Reddy_Paluri can you please explain this line

row(1).ToString.Substring(0,6).ToString

i have other question if it possible

how i can remove the $ because i get this error or how i can keep the $ and solve this ?

Check price column is >= 40 : Input string was not in a correct format.

this is the If condition

CInt(row(1)) >= 40

so i want filter the price and add to queue it is work but because i have the $ give me the error

Thank you

row(1).ToString.Substring(0,6).ToString
My input string =“$39.99$39.99 $49.14$49.14”

Substring (start index,endindex)
Index start with zero so in your case you want first price means $39.99
012345
If you are not understanding.please refer below site

Regards,
Omkar P

1 Like

Thank you @Reddy_Paluri i understand

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