Created
May 29, 2020 16:17
-
-
Save Yorzic/86357ad04686377fc9aa65607ad4b413 to your computer and use it in GitHub Desktop.
Extensions for handling CSV Files in iOS
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
extension UIViewController { | |
func handleCSVFile(url: URL) -> [[String]]? { | |
if let data = try? String(contentsOf: url) { | |
var result: [[String]] = [] | |
let rows = data.components(separatedBy: "\r\n") | |
for row in rows { | |
let columns = row.components(separatedBy: ",") | |
var cells: [String] = [] | |
for item in columns { | |
let cell = item.replacingOccurrences(of: "\"", with: "", options: NSString.CompareOptions.literal, range:nil) | |
if cell != "" { | |
cells.append(cell) | |
} | |
} | |
// Only append the array if it's not empty | |
if cells != [] { | |
result.append(cells) | |
print(cells) | |
} | |
} | |
// Double check that the array doesn't contain any empty entries | |
for i in 0 ..< result.count { | |
if result[i] == [] { | |
result.remove(at: i) | |
} | |
} | |
print(result.last!) | |
return result | |
} else { | |
return nil | |
} | |
} | |
func priceToString(_ priceInCents: Int, currency: String = "$") -> [String] { | |
var arrayOfValues = [String]() | |
var totalString = "" | |
var priceWithoutGSTString = "" | |
var gstString = "" | |
let gstTemp = priceInCents * 100 / 110 * 10 | |
let gstDouble: Double = (ceil((Double(gstTemp) / 100)) / 100).truncate(places: 2) | |
let totalPriceDouble: Double = (Double(priceInCents) / 100).truncate(places: 2) | |
let priceWithoutGSTDouble: Double = totalPriceDouble - gstDouble | |
print("\(priceWithoutGSTDouble), \(gstDouble), \(totalPriceDouble)") | |
// Price | |
if ceil(priceWithoutGSTDouble) == priceWithoutGSTDouble { | |
priceWithoutGSTString = "\(Int(priceWithoutGSTDouble)).00" | |
} else if ceil(priceWithoutGSTDouble * 10) == priceWithoutGSTDouble * 10 { | |
priceWithoutGSTString = "\(priceWithoutGSTDouble.truncate(places: 1))0" | |
} else { | |
priceWithoutGSTString = "\((priceWithoutGSTDouble + 0.005).truncate(places: 2))" | |
} | |
// GST | |
if ceil(gstDouble) == gstDouble { | |
gstString = "\(Int(gstDouble)).00" | |
} else if ceil(gstDouble * 10) == gstDouble * 10 { | |
gstString = "\(gstDouble.truncate(places: 1))0" | |
} else { | |
gstString = "\(gstDouble.truncate(places: 2))" | |
} | |
// Total | |
if ceil(totalPriceDouble) == totalPriceDouble { | |
totalString = "\(Int(totalPriceDouble)).00" | |
} else if ceil(totalPriceDouble * 10) == totalPriceDouble * 10 { | |
totalString = "\(totalPriceDouble.truncate(places: 1))0" | |
} else { | |
totalString = "\(totalPriceDouble.truncate(places: 2))" | |
} | |
// Custom currency display rules | |
switch currency { | |
case "₽": | |
arrayOfValues.append(priceWithoutGSTString + " (\(currency)") | |
arrayOfValues.append(gstString + " (\(currency)") | |
arrayOfValues.append(totalString + " (\(currency)") | |
default: | |
arrayOfValues.append(currency + priceWithoutGSTString) | |
arrayOfValues.append(currency + gstString) | |
arrayOfValues.append(currency + totalString) | |
} | |
return arrayOfValues | |
} | |
} | |
extension Double { | |
func truncate(places: Int) -> Double { | |
return Double(floor(pow(10.0, Double(places)) * self)/pow(10.0, Double(places))) | |
} | |
var km: Double { return self * 1_000.0 } | |
var m: Double { return self } | |
var cm: Double { return self / 100.0 } | |
var mm: Double { return self / 1_000.0 } | |
var ft: Double { return self / 3.28084 } | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment