Forum Discussion

JimHarrison's avatar
JimHarrison
Qrew Champion
4 years ago

Finding Non-breaking spaces in imported data

We have an import tool that takes an Excel spreadsheet and imports the data into Quickbase. We find there is an ASCII character char(160) that looks like a regular space but is read differently by ot...
Data import and export
JimHarrison's avatar
JimHarrison
Qrew Champion
4 years ago
Hi Mike,

We use ConvertAPI and Zamzar to go from xlsx to csv.

Regards,
Jim Harrison
Portland, OR

------------------------------
Jim Harrison
transparency = knowledge + understanding : The Scrum Dudes
------------------------------
MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
4 years ago
Does one of these programs actually automatically import the data into QB? ie the equivalent of clicking 'import from file'?

------------------------------
Mike Tamoush
------------------------------
  • JimHarrison's avatar
    JimHarrison
    Qrew Champion
    4 years ago
    No for that we use Workato, which is like Pipelines.

    Regards,
    Jim Harrison
    Portland, OR

    ------------------------------
    Jim Harrison
    transparency = knowledge + understanding : The Scrum Dudes
    ------------------------------