how to remove $ in money column?

[#1]

Hi all,

I have Price coulmn in excel sheetas below:

I used  trim(replace(Price),'$','') as Price1

Product              Price              My output          expected o/p

A                        $10                    10                         10

B                        $20                    20                          20

C                        $15                    15                         15

D                        $-10                    10                        -10

E                        $-5                      5                          -5

F                        $25                      25                        25

G                        $-30                    30                        -30

Thank you.

[sasikanth]

hi,

its working

Load * ,trim(Replace(Price,'$','')) as New_Price

Inline [

Product          ,    Price  

A,$10         

B         ,               $20          

D      ,                  $-10         

E     ,                   $-5          

F      ,                  $25          

G      ,                  $-30         

];

check once

[buzzy996]

do u like tis?

[#4]

May be in the excel the column format have Money format. So it showing $ on excel file.

The string functions only work if your source have string. Please check the excel file its number or string.

If you want use the string function, first convert into string with TEXT function & apply replace function.

Trim(Replace(Text(FieldName),'$',''))

[#5]

According your screenshot the excel file have number not string. so you don't need use any string functions.