Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
43918084
Creator II
Creator II

make csv text with leading zeros to numeric

I have to import a csv file but the numerical column appears as below.  May I know how can I make to to numeric format?

Capture.PNG

1 Solution

Accepted Solutions
43918084
Creator II
Creator II
Author

Thank you very much for your advice Kush.  Unfortunately, I still cannot get the required result.

I later get it resolved by using num(Evaluate(field))

View solution in original post

3 Replies
Taoufiq_Zarra

@43918084  Maye Num() function ?

Load *,Num(Field) as NewField inline

[
Field
+000025
-000055
+000111
-001111
]

output:

Taoufiq_Zarra_0-1607942449475.png

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Kushal_Chawda

@43918084  if it is stored as text then try below

num(num#(Field))

43918084
Creator II
Creator II
Author

Thank you very much for your advice Kush.  Unfortunately, I still cannot get the required result.

I later get it resolved by using num(Evaluate(field))