# 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 ?

i use for each row

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.

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

1 Like

Welcome @coder

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)