coder
(coder)
June 5, 2020, 8:33am
1
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
coder
(coder)
June 5, 2020, 8:49am
3
Thank you for you help but where i can write this ?
Where your using logic excel?
Please share your code or screen shot
coder
(coder)
June 5, 2020, 9:00am
7
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
coder
(coder)
June 5, 2020, 12:03pm
9
Thank you for you Reddy_Paluri
i will see that now
coder
(coder)
June 5, 2020, 12:35pm
10
Thank you very much, it works like I want
1 Like
coder
(coder)
June 5, 2020, 1:53pm
12
@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
coder
(coder)
June 5, 2020, 4:02pm
14
Thank you @Reddy_Paluri i understand
system
(system)
Closed
June 8, 2020, 4:16pm
15
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.