python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - copybook

How to process mainframe numbers where "{" is the last character

I have a one mainframe file data like as below 000000720000{ I need to parse the data and load into a hive table like below 72000 the above field is income column and "{" sign which denote...
test-img

Nisha Gupta

hive

cobol

mainframe

spark-submit

copybook

Votes: 0

Answers: 1

Latest Answer

The number you want is 7200000 which would be 72000.00. The conversion you are looking for is: Positive numbers { = 0 A = 1 B = 2 C = 3 D = 4 E = 5 F = 6 G = 7 H = 8 I = 9 Negative numbers (this make...
test-img

Hogstrom

Posts

Questions

Blogs

Jobs