Using spreadsheet gem and rails
MY CODE GOES BELOW:
book = Spreadsheet.open ‘excel-file.xls’
sheet = book.worksheet 0
book.write ‘output-file.xls’
and here goes the first problem:
I want to remove data that comes after “;” (semicolon) in a column.
Example below.
FULTON BANK NA;FULTON BANK
I just want it to be FULTON BANK NA for example.
the second problem:
I want only leave price data like this: $78,000.00 and want to strip
all other data from specific column.
Example below.
MORTGAGE - CORPORATE;($78,000.00)
I just want it to be $78,000.00 for example.
Your help is appreciated,
thanks